change mysql password

Products

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

Issue/Introduction

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

 

Environment

Release : 3.6

Component : IM Reporting / Admin / Configuration

Resolution

Note there are 2 accounts root and netqos the passwords must be the same. 

mysql -uroot -pnetqos 

mysql>ALTER USER 'user_name'@'localhost' IDENTIFIED BY 'MyNewPass';

You will then need to update the db.password field in the following files: 

db.password=<NEW_PASSWORD>

1. /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/em.properties 

2. /opt/CA/PerformanceCenter/sso/webapps/sso/WEB-INF/sso.properties 

3. /opt/CA/PerformanceCenter/DM/webapps/dm/WEB-INF/dm.properties

4. /opt/CA/PerformanceCenter/PC/webapps/pc/WEB-INF/cfg/portal.console.properties

Note in 3.6.8+, 3.7.4+ and 3.8 you will need to put the encrypted password in the files above. Use the doEncryption.sh command to get the encrypted password.

/opt/CA/PerformanceCenter/Tools/bin/doEncryption.sh <USER> <NEW_PASSWORD>

Then put the resulting string in the db.password= field of the files above