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
export
JAVA_HOME=install_dir/jre/jre
.Important: Create a backup of server.xml and database.yml files before you make any change.
Procedure
- Log in to the server where BigFix Inventory is installed.
- 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.
- 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.
- 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, click . Enter the unencrypted password for the database user and click Save.
- Restart the BigFix Inventory server.