I am trying to setup Logstah to work with Oracle wallet. I am unable get any configuration that supports wallet. I cannot keep open passwords in config files that is against the security policy.
I am getting below error
{ 2088 rufus-scheduler intercepted an error:
2088 job:
2088 Rufus::Scheduler::CronJob "* * * * *" {}
2088 error:
2088 2088
2088 Sequel::DatabaseConnectionError
2088 Java::JavaSql::SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "host:port:sid"
2088 oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:489)
2088 oracle.jdbc.driver.PhysicalConnection.(oracle/jdbc/driver/PhysicalConnection.java:553)
2088 oracle.jdbc.driver.T4CConnection.(oracle/jdbc/driver/T4CConnection.java:254)
2088 oracle.jdbc.driver.T4CDriverExtension.getConnection(oracle/jdbc/driver/T4CDriverExtension.java:32)
2088 oracle.jdbc.driver.OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:528)
2088 jdk.internal.reflect.GeneratedMethodAccessor39.invoke(jdk/internal/reflect/GeneratedMethodAccessor39)
2088 jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(jdk/internal/reflect/DelegatingMethodAccessorImpl.java:43)
2088 java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:564)
2088 org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:471)
2088 org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:329)
Config
jdbc {
jdbc_validate_connection => true
jdbc_connection_string => "jdbc:oracle:thin:/@TEST_WALLET?TNS_ADMIN=/home/Test/DEV/TNS"
jdbc_driver_library =>"/home/Test/DEV/logstash-7.14.0/logstash-core/lib/jars/ojdbc8.jar,/home/Test/DEV/logstash-7.14.0/logstash-core/lib/jars/oraclepki.jar,/home/Test/DEV/logstash-7.14.0/logstash-core/lib/jars/osdt_core.jar,/home/Test/DEV/logstash-7.14.0/logstash-core/lib/jars/osdt_cert.jar,/home/Test/DEV/logstash-7.14.0/logstash-core/lib/jars/ucp.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
statement =>"select sysdate wallet_sysdate from dual"
schedule => "* * * * *"
type => jdbc
}
Or is their any solution where i can keep my password encrypted.