Environment
Novell ZENworks Configuration Management 10 Database
Novell ZENworks Configuration Management 11 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."
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
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
