How to change the MySql password in Performance Management

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How can I change the mySql password on Performance Center (CAPC)?

How can we change the current complex MySql Password in use by the DX NetOps Performance Management Portal database?

 

Cause

Admin user of tool left the company. Company policy requires any passwords the user had access to be changed.

Environment

All supported DX NetOps Performance Management releases

Resolution

There are 2 accounts used in the tool for MySql DB access. The root and netqos users. Their passwords must be the same.

To change the password take these steps. Default paths shown.

1. Open a new MySql prompt. Enter the current password when prompted.
   1. /opt/CA/MySql/bin -uroot -p
2. Run the following commands. For each replace new-password with the new password.
   • alter user 'netqos'@'%' identified by 'new-password';
   • alter user 'netqos'@'localhost' identified by 'new-password';
   • alter user 'root'@'%' identified by 'new-password';
   • alter user 'root'@'localhost' identified by 'new-password';
3. Run the following command to validate the users have the same password set. It should show the same encrypted string for all users.
   1. select host,user,authentication_string from mysql.user;
4. Generate a new encrypted password string.
   1. Go to /opt/CA/PerformanceCenter/Tools/bin
   2. Run:
      1. ./doEncryption.sh encrypt new-password
   3. Record the new encryption string for the next step.
5. Update the db.password field in the following files:
   
   1. /opt/CA/PerformanceCenter/DM/webapps/dm/WEB-INF/dm.properties
   2. /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/em.properties
   3. /opt/CA/PerformanceCenter/sso/webapps/sso/WEB-INF/sso.properties
6. Update the dbPassword field in the following file:
       /opt/CA/PerformanceCenter/PC/webapps/pc/WEB-INF/cfg/portal.console.properties
7. Stop the four services:
   1. systemctl stop caperfcenter_console
   2. systemctl stop caperfcenter_devicemanager
   3. systemctl stop caperfcenter_eventmanager
   4. systemctl stop caperfcenter_sso
8. Start the four services:
   1. systemctl start caperfcenter_sso
   2. systemctl start caperfcenter_eventmanager
   3. systemctl start caperfcenter_devicemanager
   4. Wait 60 seconds.
   5. systemctl start caperfcenter_console