SSL error when connecting to MySQL database

[onurozkir]

Description:

i am getting javax.net.ssl.SSLException: readHandshakeRecord error where connection to MySQL database in siddhi project. i followed all the steps given the link Managing Keystore and defined the certificate file in the client-truststore.jks file

i got :

[2022-01-13_13-49-13_036] ERROR {com.zaxxer.hikari.pool.HikariPool} - HikariPool-5 - Exception during pool initialization.
[2022-01-13_13-49-13_036] ERROR Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
[2022-01-13_13-49-13_036] ERROR Caused by: javax.net.ssl.SSLException: readHandshakeRecord

this is my file :

@store(type = 'rdbms', jdbc.url = "${DBHOST}", username = "${USERNAME}", password = "${PASSWORD}", jdbc.driver.name = "com.mysql.jdbc.Driver")
...

I only catch this when connecting to the production database. no problem in dev and local db

Affected Siddhi Version: 4.0.0

Steps to reproduce:

Related Issues:

[Colcefer]

"${DBHOST}?useSSL=false"