Cannot connect to Registry with MySQL when ?useSSL=true

Article Id: 103032

Status: Published

Updated On: 21-06-2018 14:14

Products:

CA Application Test , Service Virtualization , CA Continuous Application Insight (PathFinder)

Issue/Introduction:

Our DBA team required the use of of ssl for the database connection.

After setting the properties I am getting an error on the registry. lisadb.pool.common.driverClass=com.mysql.jdbc.Driver lisadb.pool.common.url=jdbc:mysql://devdbv0202:3306/qmeca_db?useSSL=true

Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!

Cause:

MySQL was not configured to use SSL.

Environment:

Release:
Component: ITKOTF

Resolution:

Your MySQL must be configured to use this option on the JDBL URL

?useSSL=true

So until MySQL is configured on the Database to use SSL you must leave off this option.