Set up SSL to MySQL database for DevTest

Products

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

Issue/Introduction

Setting up SSL to MySQL database, not seeing any doc on how to do this.

Error message indicates using useSSL=true variable but don't see that in any config or MySQL config where do I set this?

2018-04-27 17:40:11,458Z (13:40) [C3P0PooledConnectionPoolManager[identityToken->2xx5bd9v29taol1b9no59|7a7d1b47]-HelperThread-#2] ERROR System.err - Fri Apr 27 13:40:11 EDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 

Environment

All supported DevTest releases.

Cause

N/A

Resolution

The Customer wanted to use SSL but did not care about server authentication so they added the following to the connection string URL: ?verifyServerCertificate=false&useSSL=true

Example for the Registry from the site.properties file:
lisadb.pool.common.driverClass=com.mysql.jdbc.Driver
lisadb.pool.common.url=jdbc:mysql://[SERVERNAME]:3306/DevTest_Reg?verifyServerCertificate=false&useSSL=true
lisadb.pool.common.user=[user]
lisadb.pool.common.password=[password]

Additional Information

If you would like to just not have the message show you can set the useSSL=false in the same way

Example for the Registry from the site.properties file:
lisadb.pool.common.driverClass=com.mysql.jdbc.Driver
lisadb.pool.common.url=jdbc:mysql://[SERVERNAME]:3306/DevTest_Reg?useSSL=false
lisadb.pool.common.user=[user]
lisadb.pool.common.password=[password]

 

For more information please refer to these two links:

MySQL Connecting Securely Using SSL

How to disable “Establishing SSL connection without server's identity verification is not recommended” warning when connecting to MySQL database in Java?