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.
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
within log
[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)"