Cannot connect to Registry with MySQL when ?useSSL=true
Article ID: 103032
Updated On:
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!
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
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.
?useSSL=true
So until MySQL is configured on the Database to use SSL you must leave off this option.
Feedback
Yes
No
Powered by
