MySQL JDBC Error Preventing Login

Document ID : KB000008492
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After installing Release Automation (RA), using MySQL as the back end, upon starting the server, no users can login to ROC or Automation Studio. Upon checking the installation log, the following error is found:

[localhost-startStop-1] WARN (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:1142) - Could not retrieve version info from DB. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' 

(Note: Installation logs include <RA SERVER HOME>\.install4j\installation.log and <RA SERVER HOME>\logs\center_upgrade.log.)

Environment:
Any Release Automation environment configured to run on MySQL.
Cause:

This issue occurs when Release Automation does not have the required MySQL driver.

Resolution:

Copy the "mysql-connector-java-5.1.21.jar", obtained from MySQL, to the following locations: 

 

<RA SERVER HOME>\lib\ 

<RA SERVER HOME>\webapps\datamanagement\WEB-INF\lib\

 

Restart the NAC aftward, then the driver should be recognized by RA and enable connection to the MySQL database.