The most likely cause is the MySQL service is not running.
There are several ways you can start the mysql process. The recommend method here is to use the launchinstdbapp command to start MySQL under Processd:
- nav to <SPECROOT>/bin
- run ./launchinstdbapp localhost MYSQL y MYSQL.OUT
If this does not solve the error, then you can try restarting all Processd services and Tomcat server.
NOTE: stopping Processd will also stop the Location Server, which will in turn stop the SpectroSERVER. If this is occurring in PRODUCTION, then please be aware. The SpectroSERVER will have to be started back up once Processd is also back up and running.
- nav to <SPECROOT>/lib/SDPM
- run ./processd.pl stop
- wait ~ 5 minutes
- run ./processd.pl start
- nav to <SPECROOT>/tomcat/bin
- run ./stopTomcat.sh
- run ./startTomcat.sh
If that still fails to resolve the MySQL error, then next suggestion is to open a case with CA Spectrum Support.