DX NetOps Spectrum OneClick install/upgrade failed running the mysql.cus script

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

While upgrading Spectrum OneClick from 20.2 to 22.2.2, the post installation log shows the following error running the mysql.cus script

running Custom Script Install-Tools/CUS/mysql.cus
 Error(s) occurred. Please see D:/win32app/Spectrum/Install-Tools/LOGS/22.2.2.0.19_20221003/mysql.log.

*********CUSTOM SCRIPT SUMMARY**********
Script Install-Tools/CUS/mysql.cus has failed

Errors occurred during the execution of
the custom scripts noted above. Please
refer to the appropriate install.log
file for specific information on the
error. These errors must be resolved
before installing any Service Packs or
hot fixes.

The mysql.log is showing the following error:

"The mysql service is starting........
The mysql service could not be started.

More help is available by typing NET HELPMSG 3523.

**^G Error during net start msyql"

However, mysql is running and there does not appear to be any issues.

Environment

Release : DxNetOps Spectrum running on Windows

Component : SPECTRUM INSTALLATION

Cause

This is looking like it took longer for mysql to start than anticipated by the install. The install did not detect the mysql service started within a specified time so it produced the error in the log file.

Resolution

- Verify the mysql service is up and running.

- Check the $SPECROOT/tomcat/logs/stdout.log file for any errors related to OneClick and mysql. 

- Log into mysql from the command line and run mysql queries

    - Log into the system as the user that owns the Spectrum installation
    - Start a bash shell by running "bash -login"
    - cd to the $SPECROOT/mysql/bin directory and run the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -pMySqlR00t

    - Run the following command to see if you get any errors:

show full processlist;

Additional Information

KB : Unable to Upgrade Spectrum to 22.2 on Windows due to MySQL Error: "Script Install-Tools/CUS/mysql.cus has failed"