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.)
This issue occurs when Release Automation does not have the required MySQL driver.
Any Release Automation environment configured to run on MySQL.
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.