# Logstash input JDBC - Oracle wallet support **URL:** \ **Category:** Logstash\ **Created:** [October 6, 2021, 12:20pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-oracle-wallet-support/286023 "2021-10-06T12:20:10Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Prashant\_Achari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_achari/32/49232_2.png) [@Prashant\_Achari](https://discuss.elastic.co/u/Prashant_Achari)\ **Post date:** [October 6, 2021, 12:20pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-oracle-wallet-support/286023/1 "2021-10-06T12:20:10Z")
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. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 3, 2021, 12:20pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-oracle-wallet-support/286023/2 "2021-11-03T12:20:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.