# Logstash connection with oracle wallet

**URL:** <https://discuss.elastic.co/t/logstash-connection-with-oracle-wallet/289086>\
**Category:** Logstash\
**Created:** [November 12, 2021, 3:47pm UTC](https://discuss.elastic.co/t/logstash-connection-with-oracle-wallet/289086 "2021-11-12T15:47:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rodolfo\_pedra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rodolfo_pedra/32/97076_2.png) [@rodolfo\_pedra](https://discuss.elastic.co/u/rodolfo_pedra)\
**Post date:** [November 12, 2021, 3:47pm UTC](https://discuss.elastic.co/t/logstash-connection-with-oracle-wallet/289086/1 "2021-11-12T15:47:55Z")

</div>

Hello  
I'm trying to make a connection to oracle database that uses wallet. I didn't find enough information to do it, so I decided to do it according to my knowledge, but I'm not successful. If anyone can help me.

```auto
input {
  jdbc {
    tags => ["valecard-amplus"]
    jdbc_driver_library => "/home/Elastic/logstash-7.15.2/config/config.d/drivers/ojdbc8.jar, /home/Elastic/logstash-7.15.2/config/config.d/drivers/oraclepki.jar, /home/Elastic/logstash-7.15.2/config/config.d/drivers/osdt_cert.jar, /home/Elastic/logstash-7.15.2/config/config.d/drivers/osdt_core.jar, /home/Elastic/logstash-7.15.2/config/config.d/drivers/ucp.jar"
    jdbc_driver_class => "oracle.jdbc.driver.OracleDriver"
    jdbc_connection_string => "jdbc:oracle:thin:@name_high"
    jdbc_user => "user"
    jdbc_password => "password"
    schedule => "* * 12 * *"
    statement => "SELECT * FROM ..."
  }
}

```

within jvm.options

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/3/23c57ec34287d027c4b4d0e1647c9a825dc68217.png)

within log

 ![logstash1](https://us1.discourse-cdn.com/elastic/original/3X/3/1/31a8e9995beb43dfe522f0105092e23850ad12e0.jpeg)  
 ![logstash2](https://us1.discourse-cdn.com/elastic/original/3X/f/d/fdea97538d7a37d4c8708f52f48a495d5a0975a3.jpeg)

```auto
[2021-11-12T12:42:52,692][ERROR][logstash.javapipeline][main] Pipeline error {:pipeline_id=>"main", :exception=>java.security.KeyStoreException: problem accessing trust store, :backtrace=>["sun.security.ssl.TrustManagerFactoryImpl.engineInit(sun/security/ssl/TrustManagerFactoryImpl.java:73)", "javax.net.ssl.TrustManagerFactory.init(javax/net/ssl/TrustManagerFactory.java:278)", "org.apache.http.conn.ssl.SSLContextBuilder.loadTrustMaterial(org/apache/http/conn/ssl/SSLContextBuilder.java:106)", "jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)", "jdk.internal.reflect.NativeMethodAccessorImpl.invoke(jdk/internal/reflect/NativeMethodAccessorImpl.java:62)", "jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(jdk/internal/reflect/DelegatingMethodAccessorImpl.java:43)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:566)", "org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:426)", "org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:293)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.setup_trust_store(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb:649)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.RUBY$method$setup_trust_store$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/manticore_minus_0_dot_7_dot_1_minus_java/lib/manticore//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.ssl_socket_factory_from_options(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb:629)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.RUBY$method$ssl_socket_factory_from_options$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/manticore_minus_0_dot_7_dot_1_minus_java/lib/manticore//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.pool_builder(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb:396)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.RUBY$method$pool_builder$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/manticore_minus_0_dot_7_dot_1_minus_java/lib/manticore//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.pool(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb:404)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.manticore_minus_0_dot_7_dot_1_minus_java.lib.manticore.client.initialize(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/manticore-0.7.1-java/lib/manticore/client.rb:207)", "org.jruby.RubyClass.newInstance(org/jruby/RubyClass.java:939)", "org.jruby.RubyClass$INVOKER$i$newInstance.call(org/jruby/RubyClass$INVOKER$i$newInstance.gen)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client.manticore_adapter.initialize(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client/manticore_adapter.rb:26)", "org.jruby.RubyClass.newInstance(org/jruby/RubyClass.java:939)", "org.jruby.RubyClass$INVOKER$i$newInstance.call(org/jruby/RubyClass$INVOKER$i$newInstance.gen)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client.build_adapter(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client.rb:323)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client.RUBY$method$build_adapter$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java/lib/logstash/outputs/elasticsearch//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client.build_pool(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client.rb:327)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client.RUBY$method$build_pool$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java/lib/logstash/outputs/elasticsearch//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client.initialize(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client.rb:62)", "org.jruby.RubyClass.newInstance(org/jruby/RubyClass.java:939)", "org.jruby.RubyClass$INVOKER$i$newInstance.call(org/jruby/RubyClass$INVOKER$i$newInstance.gen)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client_builder.create_http_client(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client_builder.rb:106)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client_builder.RUBY$method$create_http_client$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java/lib/logstash/outputs/elasticsearch//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client_builder.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client_builder.build(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client_builder.rb:102)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.http_client_builder.RUBY$method$build$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/vendor/bundle/jruby/$2_dot_5_dot_0/gems/logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java/lib/logstash/outputs/elasticsearch//home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch/http_client_builder.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.plugin_mixins.elasticsearch.common.build_client(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/plugin_mixins/elasticsearch/common.rb:34)", "home.Elastic.logstash_minus_7_dot_15_dot_2.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_output_minus_elasticsearch_minus_11_dot_0_dot_5_minus_java.lib.logstash.outputs.elasticsearch.register(/home/Elastic/logstash-7.15.2/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.5-java/lib/logstash/outputs/elasticsearch.rb:275)", "org.jruby.RubyClass.finvoke(org/jruby/RubyClass.java:572)", "org.jruby.RubyBasicObject.callMethod(org/jruby/RubyBasicObject.java:354)", "org.logstash.config.ir.compiler.OutputStrategyExt$SimpleAbstractOutputStrategyExt.reg(org/logstash/config/ir/compiler/OutputStrategyExt.java:275)", "org.logstash.config.ir.compiler.OutputStrategyExt$AbstractOutputStrategyExt.register(org/logstash/config/ir/compiler/OutputStrategyExt.java:131)", "org.logstash.config.ir.compiler.OutputDelegatorExt.doRegister(org/logstash/config/ir/compiler/OutputDelegatorExt.java:117)", "org.logstash.config.ir.compiler.AbstractOutputDelegatorExt.register(org/logstash/config/ir/compiler/AbstractOutputDelegatorExt.java:68)", "org.logstash.config.ir.compiler.AbstractOutputDelegatorExt$INVOKER$i$0$0$register.call(org/logstash/config/ir/compiler/AbstractOutputDelegatorExt$INVOKER$i$0$0$register.gen)", "home.Elastic.logstash_minus_7_dot_15_dot_2.logstash_minus_core.lib.logstash.java_pipeline.register_plugins(/home/Elastic/logstash-7.15.2/logstash-core/lib/logstash/java_pipeline.rb:228)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1820)", "org.jruby.RubyArray$INVOKER$i$0$0$each.call(org/jruby/RubyArray$INVOKER$i$0$0$each.gen)", "home.Elastic.logstash_minus_7_dot_15_dot_2.logstash_minus_core.lib.logstash.java_pipeline.register_plugins(/home/Elastic/logstash-7.15.2/logstash-core/lib/logstash/java_pipeline.rb:227)", "home.Elastic.logstash_minus_7_dot_15_dot_2.logstash_minus_core.lib.logstash.java_pipeline.RUBY$method$register_plugins$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/logstash_minus_core/lib/logstash//home/Elastic/logstash-7.15.2/logstash-core/lib/logstash/java_pipeline.rb)", "home.Elastic.logstash_minus_7_dot_15_dot_2.logstash_minus_core.lib.logstash.java_pipeline.maybe_setup_out_plugins(/home/Elastic/logstash-7.15.2/logstash-core/lib/logstash/java_pipeline.rb:585)", "home.Elastic.logstash_minus_7_dot_15_dot_2.logstash_minus_core.lib.logstash.java_pipeline.RUBY$method$maybe_setup_out_plugins$0$ __VARARGS__ (home/Elastic/logstash_minus_7_dot_15_dot_2/logstash_minus_core/lib/logstash//home/Elastic/logstash-7.15.2/logstash-core/lib/logstash/java_pipeline.rb)"

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 10, 2021, 3:48pm UTC](https://discuss.elastic.co/t/logstash-connection-with-oracle-wallet/289086/2 "2021-12-10T15:48:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.