Before making any changes, ensure that you back up all configuration files.
When changing a database password, it's crucial to update it in several configuration files and UI settings across meshIQ products to ensure seamless operations and continued connectivity; below is a detailed list of locations that require updates.
1. WGS Properties
Locate the sections where database credentials are configured:
General tab: APWMQ Database User Password
Authorization and Authentication tab: Permits Database User Password
Update the password fields with the new password.
2. Job Scheduler Properties
Go to the Database tab under Job Scheduler properties and update the stored password.
3. Expert Properties
For all configured experts:
-
Click on Database tab
-
Update the password if the expert connects to the database
4. Sensor logging
-
Review all business views under Sensor Logging
-
Identify views that log sensor status to the database
-
Update the database password if authentication is required
5. server.xml file
-
Typically located in the server’s configuration directory
-
Open the file and locate the database connection settings
-
Update the
passwordfield with the new value
6. nsqjdbcmk.properties File
-
Contains JDBC configuration for meshIQ tools
-
Open the file and update the
passwordfield
7. nsqjdbcmk.sh Script
The nsqjdbcmk.sh script is 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
Verify database connectivity across the platform to ensure the new password is functioning as expected.
Document Changes
Maintain a record of all configuration changes for future reference and auditing purposes.