Cannot connect to Registry with MySQL when ?useSSL=true
book
Article ID: 103032
calendar_today
Updated On:
Products
CA Application TestService VirtualizationCA 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.