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"