How can I change the mySql password on Performance Center (CAPC)?
Release : 3.6
Component : IM Reporting / Admin / Configuration
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