How to connect SSL enable MYSQL from LOGSTASH

Elastic Stack Logstash
1

Hello

I would like to sync my data from MYSQL to ElasticSearch using Logstash. I can do that easily from a standard MYSQL database.

But facing problem with a SSL enable MYSQL database, It's unable to connect to my jks files. My JKS files are okay because able to connect through other java application.

Getting this error:
2012 Java::JavaSql::SQLNonTransientConnectionException: Cannot open file:/etc/certs/mysql-client-keystore.jks [Keystore was tampered with, or password was incorrect]

JDBC Connection String is as follows:

jdbc_connection_string => "jdbc:mysql://xx.xx.xx.xxx:3306/my_db?ssl=true&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&verifyServerCertificate=true&useSSL=true&requireSSL=true&clientCertificateKeyStoreUrl=file:mysql-client-keystore.jks&clientCertificateKeyStorePassword=xxx&trustCertificateKeyStoreUrl=file:mysql-truststore.jks&trustCertificateKeyStorePassword=xxx"

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.