Spectrum MIB Tools Error Could not initialize MySql connection

Products

• Spectrum

Issue/Introduction

Getting an error when trying to launch MIB Tools: "Could not initialize MySql connection"

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.