Instructions on changing the database username and/or password for ITPAM
- Stop PAM Orchestrator(s).
- Open a command prompt and CD to <pam_install_dir>\server\c2o directory. You should see a script to encrypt password (eg: PasswordEncryption.bat if on a Windows system)
- Run the command to encrypt the new password.
PasswordEncryption.bat "newPassword" ( shows encrypted password on the command prompt)
PasswordEncryption.bat "newPassword" > encrptPass.txt (saves the encrypted password to a file for ease of copy paste)
Repeat this step if you are using different databases (say for reporting and library tables and have different passwords)
- Make a backup copy of <pam_install_dir>\server\c2o \.config\OasisConfig.properties (eg: rename to OasisConfig.properties.org) Make sure to store the backup copy in a directory outside of the PAM install directory. Java can still read files even if they are renamed.
- Open the properties file and look for *.database.username. You will see either 2 or 3 of these properties depending on the version of PAM you are using. Next to this property you will see *.database.password.
You will need to modify the properties (username and password) using the corresponding encrypted passwords generated in step 3 for ONLY the ones you want to change.
Eg: If you are using different databases for runtime and library tables from the reporting tables and would like to change the user / password for DB of runtime and library tables only, then you DO NOT need to change the values for the following :
- Save the changes and restart PAM Orchestrator(s).