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 BigFix Inventory.

Before you begin

Before you can run the security utility you must set the JAVA_HOME environment variable, for example export JAVA_HOME=install_dir/jre/jre.

Important: Create a backup of server.xml and database.yml files before you make any change.

Procedure

  1. Log in to the server where BigFix Inventory is installed.
  2. Run the following command and enter the new password for the database user.
    install_dir/wlp/bin/securityUtility encode
    Note: If you use AES encryption, add the following parameter to the command above: --encoding=aes.

    The password is returned as an encrypted string.

  3. Edit the following configuration files, and enter the new encrypted password.
    • install_dir/wlp/usr/servers/server1/server.xml

      Search the database entry "properties.db2.jcc" for DB2 and "properties.microsoft.sqlserver" for SQL Server and then change the password for the database entry.

      Copy the new encrypted password to password attribute, for example:
      • in case of 'xor' encoding : password="{xor}fgspGzAWPTApFzk="
      • in case of 'aes' encoding : password="{aes}fgspGzAWPTApFzk="
    • install_dir/wlp/usr/servers/server1/config/database.yml

      Copy the new encrypted password to encrypted_password.

  4. If you use the same user for the BigFix database, you must also enter the new password in the following locations:
    1. Update the database password in the BigFix server. For more information, see: Changing the database password.
    2. In BigFix Inventory, click Management > Data Sources. Enter the unencrypted password for the database user and click Save.
  5. Restart the BigFix Inventory server.