Linux dbisql can't connect to local internal sybase database without additional parameter

  • 7000764
  • 27-Jun-2008
  • 05-May-2016

Environment

Novell ZENworks Configuration Management 10 Database
Novell ZENworks Configuration Management 11 Database

Situation

On a linux server with ZCM 10.x or 11.x installed, run /opt/novell/zenworks/share/sybase/bin32s/dbisql
 
Use database tab / find key to select the local database, and under Identification tab, login to the tool using the credentials gathered from the zman dgc command (for audit database zman dgca command).
 
ERROR:
"Could not connect to the database.
Database server not found
Ensure that the name in the "Server name" field is spelled correctly and that the database server has been started."



Resolution

Assuming that the database is started and listening on the port (2638 by default), the following setting should be added to the Advanced Tab, under the section titled "Enter connection parameters, one per line, in the form of "name=value "  Note:  For ZENworks 11.1 this can be placed in Advanced/Other section:
 
links=tcpip{host=IPorDNSName,port=2638}
 
where IPorDNSName is the IP address or DNS name of the linux server, and port is the sybase configured listening port.
 
 

Additional Information

NOTE: 11.3.x introduced the Audit database - modify examples above for reports from Audit database.
ZENworks Audit Database: To get the zenauditadmin password use zman dgca.

Advanced options
ZEN:other:links=tcpip{host=127.0.0.1,port=2638,verify=no}
Audit:other:links=tcpip{host=127.0.0.1,port=2639,verify=no}

Picture of dbisql on 11.1