we just did an upgrade from 21.2.2 to 21.2.9 on our production systems, but the Performance center install failed.
(in Performance_Center_Install log)
FATAL ERROR - class com.ca.im.installanywhere.action.GenerateInstallFailure FatalInstallException: MySql is not running.
(in post_mysql_upgrade log)
Exception: com.ca.im.installanywhere.util.DbMigrateException: Unable to open database connection: (jdbc:mysql://localhost:3306/mysql?
The PostMysqlUpgrade step failed, as it could not connect to the MySql database
Release : 21.2.9
Component :
Make sure you can login to the MySql database as both root and netqos, with the same password
if you are not able to, mysql may be hung. kill pid for mysql and then start mysql again
Rerun postmysqlupgrade as follows
Make sure all PC services are down except mysql.
Run
/opt/CA/PerformanceCenter/Tools/bin/npcshell.sh postmysqlupgrade --production --dbhost localhost --dbport 3306 --dbuser 'root' --origDbPass 'MyPasswordHere' --dbpass 'MyPasswordHere' --log /opt/CA/PerformanceCenter/InstallLogs/post_mysql_upgrade.log.
Once successful rerun the upgrade using CAPerformanceCenter.bin