Changing the password for the ZSM7SP1 Sybase database

  • Document ID:7001464
  • Creation Date:01-Oct-2008
  • Modified Date:30-Apr-2012
    • Micro Focus Products:
      ZENworks Server Management

Environment

Novell ZENworks 7 Server Management Support Pack 1 - ZSM7 SP1 Tiered Electronic Distribution (TED)

Situation

How to change the password for the ZSM7SP1 Sybase database.

Resolution

To obtain a hot patch with the fix for this problem, follow the instructions in KB 3809227 "Updates to Novell ZENworks 7 Server Management" which can be found at https://www.novell.com/support

A utility/tool entitled "dbpasswordupdater" has been added to ZSM7SP1IR3A_HP1 code or later which enables this functionality.  This utility can be found in the directory: Zenworks\PDS\Tool directory after installing this patch. 
 
Usage:
  1. Unzip the DBPasswordUpdater.zip.
  2. Open up a command prompt. Go to the location where DBPasswordUpdater.zip was unzipped.
  3. Open the DBPasswordUpdater.bat in a text editor and make sure that the "zsmpath" variable is pointing to correct location (should point to where ZENWorks is installed).
  4. Type DBPasswordUpdater.bat (for windows) or just DBPasswordUpdater(on NetWare).Press Enter.
  5. The tool will ask for the server/or IP of the server on which Database is running. Please enter the details.Press Enter.
  6. The tool then asks for the port number of the database. The default port number is 2638. Please enter it if you have not changed the port during installation. Else enter the correct port number.Press Enter.
  7. The tool will then ask for a Database user-id. Please enter the user-id for which password needs to be changed.Press Enter.
  8. The tool then asks for the new password. Enter it. Press Enter.
  9. The tool will try to connect to the database using the details entered by the admin, change the password and then save the changed password in the DB.properties.

For easy usage, this tool should be run on servers on which ZSM server is installed.

Status

Security Alert

Additional Information

** Important Note **
A known bug exists when using this tool.  Please see TID 7001467