To connect to the embedded PostgreSQL database, based on the existing configurations, set the following environment variables:
NOTE:
The parameter values are available in the zdm.xml file.
The zdm.xml file is available in the following location:
On Windows %ZENWORKS_HOME%\conf\datamodel
On Linux / Appliance /etc/opt/novell/zenworks/datamodel
Use the zman dgc commands to get the user name and password. For more information, see ZENworks Command Line Utilities Reference.
On Linux / Appliance Open the terminal and set the following parameters:
su zenpostgres
LD_LIBRARY_PATH=/opt/novell/zenworks/share/pgsql/lib; export LD_LIBRARY_PATH
PATH=$PATH:/opt/novell/zenworks/share/pgsql/bin; export PATH
PGPORT=<port_number>; export PGPORT
PGUSER=<user_name>; export PGUSER
PGDATABASE=<database_name>; export PGDATABASE
PGPASSWORD=<password>; export PGPASSWORD
cd /vastorage/opt/novell/zenworks/share/pgsql/bin/
./psql
On Windows Open command prompt and set the following parameters:
set PGPASSWORD=<password>
set PGUSER=<user_name>
set PGDATABASE=<database_name>
set PGPORT=<port_number>
cd C:\Program Files (x86)\Novell\ZENworks\share\postgres\bin
psql