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,
  • set JAVA_HOME=<BFI_INSTALL_DIR>/jre/jre
  • export JAVA_HOME=<BFI_INSTALL_DIR>/jre/jre
Important: Create a backup of server.xml and database.yml files before you make any change.

For information about changing the DB2 database password, see: Maintaining passwords on servers. For information about changing the SQL Server password, see the SQL Server Login Password Expiration.

Procedure

  1. Log in to the computer where BigFix Inventory is installed.
  2. Run the following command and enter the new password for the database user.
    <BFI_INSTALL_DIR>/wlp/bin/securityUtility encode
    The password is returned as an encrypted string. Save it to use in the next steps.
    Note: If you use AES encryption, add the following parameter to the command above: --encoding=aes.
    <BFI_INSTALL_DIR>/wlp/bin/securityUtility encode --encoding=aes
  3. Edit the following configuration files, and enter the new encrypted password.
    • BFI_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 the password attribute, for example:
      • In case of 'xor' encoding : password="{xor}fgspGzAWPTApFzk="
      • In case of 'aes' encoding : password="{aes}fgspGzAWPTApFzk="
    • BFI_INSTALL_DIR/wlp/usr/servers/server1/config/database.yml

      Copy the new encrypted password to the encrypted_password parameter.

      Tip: Follow the instruction mentioned here while editing the database.yml file.
  4. If you use the same user for the BigFix database, you must also enter the new password in the following locations.
    • Update the database password in the BigFix server. For more information, see: Changing the database password.
    • In BigFix Inventory, go to Management > Data Sources. Enter the unencrypted password for the database user and click Save.
  5. Restart BigFix Inventory server.
    1. Stop the BigFix Inventory server.
    2. Start the BigFix Inventory server.