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
-
set JAVA_HOME=<BFI_INSTALL_DIR>/jre/jre
-
export JAVA_HOME=<BFI_INSTALL_DIR>/jre/jre
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
- Log in to the computer where BigFix Inventory is installed.
- Run the following command and enter the new password for the database
user.
The password is returned as an encrypted string. Save it to use in the next steps.<BFI_INSTALL_DIR>/wlp/bin/securityUtility encode
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
- 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="
- In case of 'xor' encoding :
- 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.
- BFI_INSTALL_DIR/wlp/usr/servers/server1/server.xml
- 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 . Enter the unencrypted password for the database user and click Save.
- Restart BigFix Inventory server.