Changing the Database Schema Passwords
If you must change the PPM database schema passwords, be sure to change them both in the database and in the
What to consider before you change all the database schema passwords
Check your environment definitions to determine whether any contain a password that is to be changed. You can use the tool
<PPM_Home>/bin/kEnvUpdatePassword.shto automatically change all occurrences of a specific password for a particular host and user name.
Note: This functionality is also available from the Environments section of the PPM Workbench. (Open an environment on the Environment page, and then, on the Environment menu, click Update Password.)
Check both server and client passwords, as well as database passwords.
Check passwords associated with application codes.
Although it is not a recommended practice, you can hard-code passwords into commands in workflow steps, requests, and object types.
There is no need to change commands that use tokens for passwords (that is,
SOURCE_ENV.DB_PASSWORD), as long as the password is changed in the respective environment definitions.
Changing the PPM database schema passwords
Make sure that all users are logged off the system.
Stop the PPM Server. (For information about how to stop PPM Servers, see Starting and Stopping the PPM Server on a Single-Server System.)
Change passwords, as necessary in the database.
To change the passwords in the
server.conffile, run the
kConfig.shscript to set the
Note: When changing the passwords, do not edit the
server.conffile directly. To encrypt password values correctly, use the
Restart the PPM Server.