How to change the 'Nolio' database user password?

Document ID : KB000048155
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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

Solution:

  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 Automation Studio (ASAP).

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:

    Figure 1

  3. Execute the batch file to create an encrypted password.

    Syntax: encrypt_password.bat <password>

    Sample screenshot:

    Figure 1

  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 Automation Studio (ASAP).