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
- Copy the DB.properties which was generated by DBPasswordUpdater tool, to the bin directory of ConsoleOne installation.
- Restart ConsoleOne.
- 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.