search cancel

Cannot connect to Registry with MySQL when ?useSSL=true

book

Article ID: 103032

calendar_today

Updated On:

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.