change mysql password

Article Id: 143312

Status: Published

Updated On: 24-01-2020 10:19

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