SSL error when connecting to MySQL database in my Siddhi project

[Onur Özkır]

Hi community,
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.

Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 

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

[Onur Özkır]

Managing Keystore => https://ei.docs.wso2.com/en/latest/streaming-integrator/admin/working-with-Keystores/

13 Ocak 2022 Perşembe tarihinde saat 14:54:44 UTC+3 itibarıyla Onur Özkır şunları yazdı: