DevTest JDBC MySQL running on AWS RDS shows connection error unknown_ca

book

Article ID: 185158

calendar_today

Updated On:

Products

CLOUDTEST CA Application Test CA Cloud Test Mobile MOBILECLOUD Service Virtualization

Issue/Introduction

When trying to connect to AWS RDS MySQL using a JDBC step, the following error is shown: 
Caused by:
javax.net.ssl.SSLHandshakeException: Received fatal alert: unknown_ca

Environment

Release : 10.4

Component : CA Service Virtualization

Resolution

Use the following JDBC connect string for MySQL:

jdbc:mysql://server-name:port/schema?useSSL=true&clientCertificateKeyStoreUrl=file:C:\custom_truststore.jks&clientCertificateKeyStorePassword=pwd&clientCertificateKeyStoreType=JKS

Other options:
Add the MySQL certificate(s) to cacerts of the Java installation used by DevTest.