Consoleone reporting no longer works after running DBPasswordUpdater Utility

  • 7001467
  • 01-Oct-2008
  • 30-Apr-2012

Environment

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

Situation

Zenworks Server Management Consoleone Reporting no longer works after running the Sybase password change utility DBPasswordUpdater. 

Resolution

  1. Copy the DB.properties which was generated by DBPasswordUpdater tool, to the bin directory of ConsoleOne installation.
  2. Restart ConsoleOne.
  3. Server Reporting would be accesible now.

Additional Information

After running DBPasswordUpdater tool, try to access Server Management Database -> Reporting through ConsoleOne. Authentication failure popup appears and the reports would not be shown.
 
We had a security issue where the default Sybase, Server Management database password cannot be changed. To fix this we developed a tool called DBPasswordUpdater (for more information please refer 'README' for ZSM7SP1IR3aHP2)  that would help to change the password. This tool was released with ZSM7sp1ir3a_hp2. One known issue with this fix was that the PDS reporting would fail. Trying to get server reports through ConsoleOne would result in authentication failure from Server Management database.
 
Cause: Changing the password using DBPasswordUpdater tool causes the password to be changed. The new password is saved in a properties file on server. A client program like ConsoleOne has no knowledge about properties file. So the code still tries to connect using the default password and it fails.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.