Repository Password Encryption Utility

When moving, migrating, and upgrading repositories, users may change the repository user ID and password values listed in WebAnalysis.properties. Because these file values are viewable over the Web using the Configuration Test Servlet, a method exists to encrypt password values.

  To change and encrypt repository passwords:

  1. Stop the application server.

  2. From release 11.x, the WebAnalysis.properties file settings are managed via the EPM System Configuration Module.

    The default location is \\WebAnalysis\conf\WebAnalysis.properties.

  3. In the Repos Config section, locate these variables:

    • db.user=<userID>

    • db.password=<encrypted password>

    • db.password-encrypted=true

  4. Edit values for user ID and password.

    Note that the password is not encrypted.

  5. Change the db.password-encrypted value to false.

  6. Save your changes.

  7. Navigate to \\WebAnalysis\conf\ and run EncryptUtil.bat or EncryptUtil.sh.

    You may use alternative methods to execute this file. EncryptUtil locates the user ID, password, and encryption variable, encrypts the password, and resets db.password-encrypted to true.

    To review the changes, open WebAnalysis.properties.

  8. Restart the application server.