Cannot connect to Registry with MySQL when ?useSSL=true

book

Article ID: 103032

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

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.