API Gateway: MySQL JDBC Connection encryption using TLS example
search cancel

API Gateway: MySQL JDBC Connection encryption using TLS example

book

Article ID: 192341

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Enterprise Service Manager (Layer 7) CA Microgateway

Issue/Introduction

How can we encrypt an existing JDBC connection to a MySQL database?

Are there additional properties that are put after the JDBC URL as options?

Need to know the additional properties details to configure JDBC connections over TLS ?

Environment

Release : 9.4

Component : API GATEWAY

Resolution


To add SSL to your MySQL JDBC Connection add the following to your JDBC URL: ?&useSSL=true&verifyServerCertificate=false




The JDBC URL should go from: 
jdbc:mysql://url.to.database_hostname/test_db_name
to
jdbc:mysql://url.to.database_hostname/test_db_name?&useSSL=true&verifyServerCertificate=false

Additional Information

Support for TLS 1.2 was added in Gateway 9.4