I am trying to connect to Oracle database with JDBC input plugin using SSL (TCPS) connection. I am able to connect with regular connection (non SSL). However when thin URL with SSL TCPS, it doesn't work.
Here is example of connection string with no SSL (port 1521 is standard non-secured port)
jdbc_connection_string => "jdbc:oracle:thin:@testhost:1521:testdb"
Here is example of TCPS SSL (port 2517 is secured port) :
jdbc_connection_string => "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=testhost)(PORT=2517))(CONNECT_DATA=(SERVICE_NAME=testdb)))"
I used these connection strings in other jdbc configurations and it works. However in other jdbc SSL configurations, i specify other properties such ssl.trustStore, ssl.trustStoreType, ssl_version. I don't see SSL options for Logstash JDBC plug-in.
Are there any options available for SSL? We need to work with SSL as the non-SSL database ports will be shutdown in near future.