MySQL error while upgrading to CA Spectrum 10.3

Document ID : KB000115405
Last Modified Date : 19/09/2018
Show Technical Document Details
Issue:
Failed to upgrade the OneClick + SRM machine to 10.3 release of CA Spectrum.

In the postinst log file:
********** Started: Mon Sep 10 17:57:51 2018 **********
running Custom Script Install-Tools/CUS/mysql.cus
 Error(s) occurred. Please see E:/Spectrum/Install-Tools/LOGS/10.3.0.0.341_20180910/mysql.log.

In the mysql.log file:
******* Begin Installation of the Distributed Data Manager *******

******* Upgrading mysql *******

Stopping the mysql service
******* Starting mysql *******
Waiting for mysql to start up...
Waiting for mysql to start up...
Waiting for mysql to start up...
Final attempt to reach mysql...
**^G Error during mysqladmin --defaults-file=E:/Spectrum/mysql/my-spectrum.cnf -uroot ping
Environment:
CA Spectrum 10.3
Cause:
After the Spectrum MySQL server service is restarted, cannot access the MySQL server.

> ./mysql -uroot -proot 
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 
OC+SRM_hostname%/e/Spectrum/mysql/bin 


MySQL was configured to bind to a specific IP address.
Resolution:
Comment out the bind-address parameter in my-spectrum.cnf file and bounced the MySQL server service.
Perform the upgrade again.