CABI portal stopped working

Products

• CA Spectrum

Issue/Introduction

After applying Windows Security patches to our Jasper Server, we are no longer able to access the Jasper Console on the OneClick Web page. It is returning an error that the page is not found.

 

Looking at the jasperserver.log file, we see the application is attempting to connect to MySQL, but the connections are refused. 

Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Connection refused: connect

                at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:669)

                at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:587)

 

                at org.mariadb.jdbc.Driver.connect(Driver.java:105)

Resolution

The MySQL connection problem was a result of the MySQL service not running on the Jasper Server. The service are set to start manually, so after rebooting the server, the MySQL service was never started. Changing the service to run Automatically, and restarting the service corrected the issue.