JDBC communication link failure in the catalina.out (Linux) stdout.log (Windows) file on Spectrum Report Manager system

Products

• CA Spectrum

Issue/Introduction

The following error is seen in the catalina.out (Linux) stdout.log (Windows) file on Spectrum Report Manager system:

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Environment

Release : 10.4

Component : Spectrum Reporting

Resolution

1. Make a backup copy of the $SPECROOT/mysql/my-spectrum.cnf file

2. Edit the $SPECROOT/mysql/my-spectrum.cnf file and add following under [mysql] section:

bind-address=127.0.0.1

3. Restart mysql. The easiest way to do that is to restart processd:

    a. On Linux

        i. Login or su to the root user

        ii. cd to the $SPECROOT/lib/SDPM directory:

        iii. Enter the following command to stop processd:

./processd.pl stop

        iv. Verify mysql is no longer running

        v. Enter the following command to start processd:

./processd.pl start

        vi. Check the $SPECROOT/tomcat/logs/catalina.out file for the error.

    b. On Windows:

        i. Log into the system as an ADMIN user

        ii. Launch the Windows Services

        iii. Stop the Spectrum Process Daemon service (Do not restart)

        iv. Start the Spectrum Process Daemon service

        v. Check the $SPECROOT/tomcat/logs/stdout.log file for the error     

If you are still seeing the error, please add the following under the [client] section of the $SPECROOT/mysql/my-spectrum.cnf file and restart processd  as noted above:

bind-address=127.0.0.1

If you are still seeing the error, please add the following under the [mysql] section of the $SPECROOT/mysql/my-spectrum.cnf file and restart processd and tomcat as noted above:

connect_timeout=20

If you are still seeing the same issue, please create a case with Spectrum Support and upload the following files to the case for review:

- $SPECROOT/mysql/my-spectrum.cnf

- $SPECROOT/tomcat/logs/catalina.out (Linux)

-$SPECROOT/tomcat/logs/stdout.log (Windows)