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 '[email protected]%' identified by 'new-password';
   • alter user '[email protected]' identified by 'new-password';
   • alter user '[email protected]%' identified by 'new-password';
   • alter user '[email protected]' 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
   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/PC/webapps/pc/WEB-INF/cfg/portal.console.properties
   2. /opt/CA/PerformanceCenter/DM/webapps/dm/WEB-INF/dm.properties
   3. /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/em.properties
   4. /opt/CA/PerformanceCenter/sso/webapps/sso/WEB-INF/sso.properties
6. Stop the four services:
   1. systemctl stop caperfcenter.console
   2. systemctl stop caperfcenter.devicemanager
   3. systemctl stop caperfcenter.eventmanager
   4. systemctl stop caperfcenter.sso
7. Start the four services:
   1. systemctl stop caperfcenter.sso
   2. systemctl stop caperfcenter.eventmanager
   3. systemctl stop caperfcenter.devicemanager
   4. Wait 60 seconds.
   5. systemctl stop caperfcenter.console