Updating the database password

You can update the database user password when needed, for example if the password is changed and users cannot log in to License Metric Tool.

1. Update the password of the database user.
   • For application update 9.2.30 and later, run the SetupDatabase script and update the database password. For more information, see: Changing database connection parameters.
   • For application update 9.2.29 and earlier, perform the following steps.
     1. Log in to the computer where the License Metric Tool server is installed.
     2. Ensure that the JAVA_HOME environment variable is set. For example: export JAVA_HOME=install_dir/jre/jre.
     3. Stop the License Metric Tool server.
     4. Open the command-line interface and run the following command to encrypt the new password for the database user.
        • To encrypt the password by using the XOR encoding, run the following command.
          • <install_dir>/wlp/bin/securityUtility encode --encoding=xor
          • <install_dir>/wlp/bin/securityUtility.bat encode --encoding=xor
        • To encrypt the password by using the AES encoding, run the following command.
          • <install_dir>/wlp/bin/securityUtility encode --encoding=aes
          • <install_dir>/wlp/bin/securityUtility.bat encode --encoding=aes
        Where <install_dir> is the installation directory of the License Metric Tool server. By default, the server is installed in the following location.

        • opt/ibm/LMT/
        • C:\Program Files\ibm\LMT\
        Note: For more information about the securityUtility command, see securityUtility command manual.
     5. Enter the new encrypted password in the following files.
        • install_dir/wlp/usr/servers/server1/server.xml
          Copy the new encrypted password to the password attribute.

          Important: Update the password attribute that is listed in the properties.db2.jcc element for DB2 or the properties.microsoft.sqlserver element for MS SQL Server. Do not update the password attribute that is listed in the keyStore element.

          • For XOR encoding: password="{xor}fgspGzAWPTApFzk="
          • For AES encoding: password="{aes}fgspGzAWPTApFzk="
        • install_dir/wlp/usr/servers/server1/config/database.yml

          Copy the new encrypted password to the encrypted_password parameter.

     6. Start the License Metric Tool server.
2. Change the database password on the database engine.
   • For information about changing the DB2 database password, see: Maintaining passwords on servers.
   • For information about changing the MS SQL Server password, see: MS SQL Server Login Password Expiration.
3. If you use the same user for the BigFix® database, update the password in the following places.
   • BigFix server. For more information, see: Changing the database password.
   • In License Metric Tool, go to Management > Data Sources. Enter the unencrypted password for the database user, and click Save.