We have a pipeline that connects to db Mysql aurora. We have enabled ssl on db and its failing to connect. We have tried using both verifyServerCertificate=true&useSSL=true&requireSSL=true and useSSL=true&requireSSL=true&verifyServerCertificate=false in connection string, but did not work. Can you please advise.
input {
jdbc
{
id => "sslid"
jdbc_driver_library => "/Users/logstash-7.17.0/driver/mysql-connector-j-8.1.0.jar"
jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
#VA TSF connectionString
jdbc_connection_string => "jdbc:mysql://mysql.cluster.us-east-1.rds.amazonaws.com:3306/?useSSL=true&requireSSL=true&verifyServerCertificate=false&autoReconnect=true"
jdbc_user => "db_user"
jdbc_password => "${db_pwd}"
schedule => '*/1 * * * *'
statement => "SELECT * FROM db.table limit 1;"
}
}