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: [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 KB ♦
To see what is going wrong, run manager in debug when starting up:
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.
answered May 11 '10 at 14:02
SSH KB ♦