Changing and encrypting a TrueSight Smart Reporting repository database password

When you change a TrueSight Smart Reporting database password, you must encrypt it and then update the <install_directory>\appserver\webapps\ROOT\WEB-INF\web.xml file with the encrypted password.

Do the following:

  1. Go to the <install_directory>\utilities\cli directory, and run the following command:
    java -jar EncryptPassword.jar
  2. Enter the updated password when prompted.
  3. After the password is encrypted, copy the password.

  4. Open the <install_directory>\appserver\webapps\ROOT\WEB-INF\web.xml, file, and search for the JDBCPassword string as shown below:

    <init-param>
    <param-name>JDBCPassword</param-name>
    <param-value>03Std5z/BjK1XsH7KXtHkg==</param-value>
    </init-param>

  5. Replace the value of the JDBCPassword string with the encrypted password that you copied.
  6. Restart the TrueSightSmartReporting service.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*