change/update the Nolio Release Automation database user password

Products

• CA Release Automation - DataManagement Server (Nolio)
• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

How do I change the Release Automation's database password if the password policy restriction in the organization changes or the 'Nolio' account is locked.

Environment

Release Automation 6.x

Resolution

1. Stop the 'Release Automation Server' service.
   
   
2. On the database server change the password for the 'nolio' user account.
   
   
3. Open '<Release Automation Home Dir>\webapps\datamanagment\WEB-INF\distributed.properties' file and specify the password:
   
   data.management.database.pwd = <password>
   
   
4. Start the 'Release Automation Server' service.
   
   
5. Check whether you can login to Release Operation Center (ROC).

To encrypt the password:

1. Navigate to the '<Release Automation Home Dir>\scripts' folder using the command prompt.
   
   
2. The encrypt_password.bat file can be used to create the encrypted password. Open this file and replace the single dot with two dots as below in the relative paths section:
   
   
   
   
3. Execute the batch file to create an encrypted password.
   
   Syntax: encrypt_password.bat <password>
   
   Sample screenshot:
   
   
   
4. Stop the 'Release Automation Server' service.
   
   
5. Replace the value of data.management.database.pwd property in the '<Release Automation Home Dir>\webapps\datamanagment\WEB-INF\ distributed.properties' file.
   
   
6. Start the 'Release Automation Server' service.
   
   
7. Check whether you can login to Release Operation Center (ROC).