Before making any changes, ensure that you back up all configuration files.

When changing a database password, it's crucial to update the password in several locations to ensure seamless operations. 

The configuration files and properties described in this article must be updated with a new password.

1. WGS properties

Look for the sections where database credentials are configured in the tabs below. 

General tab: APWMQ Database User Password

Authorization and Authentication tab: Permits Database User Password

Update the password fields with the new password.

2.  Sensor logging

Under sensor logging, review all business views to identify where the sensor status is logged to the database. If a business view requires authentication, update the database password for it.

3. server.xml file

The server.xml file is typically located in the configuration directory of your server application. Open this file and locate the section where database connection settings are specified. Update the password field with the new password.

4. nsqjdbcmk.sh file

The nsqjdbcmk.sh file is a script used for database connection and operations. Open this script and locate the section where the database password is defined. Update this section with the new password.

Next steps

Restart services

After updating the password in all necessary locations, restart the relevant services to apply the changes.

Test connections

Test the database connections after making changes to confirm that the new password is working correctly.

Document changes

Document all configuration changes that you made above.