login about faq

I am using SSH Tectia Manager with Oracle database.

I have upgraded the Manager from version 2.2. to 6.x. Now I cannot connect to the GUI, and there are errors like these in the syslog.

ssh-mgmt-server[14320]: [ID 453588 daemon.error] Child 15109 (ssh-mgmt-engine) exited with status 1

What can I do to fix the situation?

asked May 11 '10 at 13:40

SSH%20KB's gravatar image

SSH KB ♦
509250247238


To see what is going wrong, run manager in debug when starting up:

  1. Stop manager: /etc/init.d/ssh-mgmt-server stop
  2. Run the debug: /opt/ssh-mgmt/server/sbin/ssh-mgmt-engine -d6 2> ssh-mgmt-engine-output.txt

Look at the resulting debug log file.

If it has the following error:

error: ../src/scmlib/sshwaf/core-server.scm:292: unhandled exception: Failed to connect to database using ConnectionId "dsn=SSH Tectia Manager Datasource;uid=dbtestuser;pwd=" [ODBC SQLSTATE IM002 (sqlcode 0): [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded] while executing: SELECT fieldname, type, value, recordtype, binvalue FROM sshdyndata WHERE recordid=?

In this case, the server is exiting because it is trying to use the OpenLink ODBC drivers, which are no longer supported by the 6.x.

This is caused by you having this in your /var/opt/ssh-mgmt/server/server-config.dat file:

(db-driver-type . oracle)

Change this to be (db-driver-type . oci), or alternatively (db-driver-type . external) but NOT (db-driver-type . oracle).

NOTE! Be careful when editing the file, and be sure to take a backup of the original file before making any changes.

If the error you get is like this: 2010-04-30 17:35:42.680 SshCsmOci/oci-interface.c:219/ssh_oci_thread_error: Xact f1f648 using connid dbname=testmanager.test.com/MANAGERDB;uid=dbtestuser;pwd= failed: login to database failed [OCI (sqlcode 12541): ORA-12541: TNS:no listener]

Make sure that the manager is configured to have the correct connection string. In the above case the manager tries to connect to the server testmanager.test.com to DB name MANAGERDB to the oracle default port, which is 1521.

If you are using a non-default port, you can edit the oracle-gdn filed in your server-config.dat file to be (oracle-gdn . "server/DBName[//]host[:port][/service]) where brackets indicate optional components. Note that if you are not running the database in the default port, then the port is not optional!

Note also: Also if the service name and port have been configured in tnsnames.ora in the directory the field oracle-tns-admin specifies in the server-config.dat, they do not need to be specified directly in the oracle-gdn field.

link

answered May 11 '10 at 14:02

SSH%20KB's gravatar image

SSH KB ♦
509250247238

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×82
×63
×13
×10
×1

Asked: May 11 '10 at 13:40

Seen: 6,294 times

Last updated: May 11 '10 at 14:02

All user contributed content licensed under the cc-by-sa license.
Powered by OSQA.