Cannot connect to Registry with MySQL when ?useSSL=true

Products

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

Issue/Introduction

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

After setting the properties 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

All supported DevTest releases.

Resolution

MySQL must be configured to use this option on the JDBC url 

?useSSL=true

Until MySQL is configured on the Database to use SS, this option must be left off.