MIB Tools Error Could not initialize MySql connection

Document ID : KB000100637
Last Modified Date : 08/06/2018
Show Technical Document Details
Issue:
Getting an error when trying to launch MIB Tools: "Could not initialize MySql connection"

User-added image
Environment:
Platform Independent
Cause:
The most likely cause is the MySQL service is not running. 

 
Resolution:
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.