# Does Logstash support oracle wallet for jdbc connection? **URL:** \ **Category:** Logstash\ **Created:** [June 17, 2020, 8:13pm UTC](https://discuss.elastic.co/t/does-logstash-support-oracle-wallet-for-jdbc-connection/237536 "2020-06-17T20:13:19Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![amritpal\_singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amritpal_singh/32/70564_2.png) [@amritpal\_singh](https://discuss.elastic.co/u/amritpal_singh)\ **Post date:** [June 17, 2020, 8:13pm UTC](https://discuss.elastic.co/t/does-logstash-support-oracle-wallet-for-jdbc-connection/237536/1 "2020-06-17T20:13:19Z")
Hi , I am trying to use oracle wallet in logstash jdbc connection and I am getting below error in logs. Unable to connect to database. Tried 1 times {:error\_message=\>"Java::JavaSql::SQLRecoverableException: IO Error: Unknown host specified "} Jun 17 20:52:00 blp07601010 logstash: 2654 error: Jun 17 20:52:00 blp07601010 logstash: 2654 2654 Jun 17 20:52:00 blp07601010 logstash: 2654 Sequel::DatabaseConnectionError Jun 17 20:52:00 blp07601010 logstash: 2654 Java::JavaSql::SQLRecoverableException: IO Error: Unknown host specified Jun 17 20:52:00 blp07601010 logstash: 2654 oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:743) Jun 17 20:52:00 blp07601010 logstash: 2654 oracle.jdbc.driver.PhysicalConnection.connect(oracle/jdbc/driver/PhysicalConnection.java:666) Jun 17 20:52:00 blp07601010 logstash: 2654 oracle.jdbc.driver.T4CDriverExtension.getConnection(oracle/jdbc/driver/T4CDriverExtension.java:32) Jun 17 20:52:00 blp07601010 logstash: 2654 oracle.jdbc.driver.OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:566) Jun 17 20:52:00 blp07601010 logstash: 2654 java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498) Jun 17 20:52:00 blp07601010 logstash: 2654 org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:470) Jun 17 20:52:00 blp07601010 logstash: 2654 org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:328) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.adapters.jdbc.connect(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/adapters/jdbc.rb:227) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.connection\_pool.make\_new(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection\_pool.rb:122) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.connection\_pool.threaded.assign\_connection(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection\_pool/threaded.rb:209) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.connection\_pool.threaded.acquire(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection\_pool/threaded.rb:139) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.connection\_pool.threaded.hold(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/connection\_pool/threaded.rb:91) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.database.connecting.synchronize(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/database/connecting.rb:270) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.database.connecting.test\_connection(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/database/connecting.rb:279) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.database.connecting.connect(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/database/connecting.rb:58) Jun 17 20:52:00 blp07601010 logstash: 2654 usr.share.logstash.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_27\_dot\_0.lib.sequel.core.connect(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.27.0/lib/sequel/core.rb:121) Below is the input config i have added in config file. input { jdbc { jdbc\_driver\_library =\> "/logstash/jars/ojdbc7.jar,/logstash/jars/oraclepki.jar,/logstash/jars/osdt\_cert.jar,/logstash/jars/osdt\_core.jar" jdbc\_connection\_string =\> "jdbc:oracle:thin:/@DBName" jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver" jdbc\_user =\> "" jdbc\_password =\> "" last\_run\_metadata\_path =\> "/logstash/last\_run\_files/.logstash\_jdbc\_last\_run\_temp" statement =\> "select 1 from tb\_table" schedule =\> "\*/15 \* \* \* \*" } } Also i am able to make connection from server via sqlplus utility but getting error via logstash. ---
**Author:** ![gildssantos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gildssantos/32/71375_2.png) [@gildssantos](https://discuss.elastic.co/u/gildssantos)\ **Post date:** [June 30, 2020, 12:25pm UTC](https://discuss.elastic.co/t/does-logstash-support-oracle-wallet-for-jdbc-connection/237536/2 "2020-06-30T12:25:53Z")
This issue was resolved ? ---
**Author:** ![amritpal\_singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amritpal_singh/32/70564_2.png) [@amritpal\_singh](https://discuss.elastic.co/u/amritpal_singh)\ **Post date:** [June 30, 2020, 10:38pm UTC](https://discuss.elastic.co/t/does-logstash-support-oracle-wallet-for-jdbc-connection/237536/3 "2020-06-30T22:38:26Z")
No Mate , still no luck ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 28, 2020, 10:38pm UTC](https://discuss.elastic.co/t/does-logstash-support-oracle-wallet-for-jdbc-connection/237536/4 "2020-07-28T22:38:27Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.