JDBC Library Logstash 7.0.0

HI,
i'm using logstash-input-jdbc, and this is installed correctly

Step 3/4 : RUN logstash-plugin install logstash-input-jdbc
---> Running in 3fd593a57661
Validating logstash-input-jdbc
Installing logstash-input-jdbc
Installation successful
---> ded53e175008

After that, i configure my pipeline and copy the lib

jdbc {
jdbc_driver_library => "/usr/share/logstash/lib/ext/ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@10.0.0.119:1521:oradb"
jdbc_user => "ICBSBAVV_EC78"
jdbc_password => "ICBSBAVV_EC78"
statement => "select ID, DATA from FM_FILE_LOB where ID >:sql_last_value and IS_GENERATED = 1"
use_column_value => true
tracking_column => id
schedule => "*/5 * * * * *"
last_run_metadata_path => "/home/litr0x/docker/docker-nrtp-icbs/jdbc_last_run/metadata"
}

I check, the lib/plugin inside the machine is ok:
error

but the errors still ocurrs:

logstash_1 | 2076 LogStash::ConfigurationError
logstash_1 | 2076 Java::oracle.jdbc.OracleDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:163:in open_jdbc_connection' logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:221:inexecute_statement'
logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:277:in execute_query' logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:258:inblock in run'
logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:234:in do_call' logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:258:indo_trigger'
logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:300:in block in start_work_thread' logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:299:inblock in start_work_thread'
logstash_1 | 2076 org/jruby/RubyKernel.java:1411:in loop' logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:289:inblock in start_work_thread'
logstash_1 | 2076 tz:

Does this help?...

sudo chmod o+r /usr/share/logstash/lib/ext/ojdbc6.jar

Hi Badger
the lib have 777..

Your image shows it has mode 771.

today now 777 sorry, for my mistake

-rwxrwxrwx 1 litr0x litr0x 2714189 abr 23 11:23 ojdbc6.jar

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