I am trying to configure logstash with jdbc input for oracle db in my lab environment; I am not permitted to access internet directly. I downloaded logstash-input-jdbc-master.zip and scp to my rhel logstash host. I unzipped and a new directory logstash-input-jdbc-master was created in my logstash directory. bin/plugin install logstash-input-jdbc fails and my input config fails as the logstash error is "Couldn't find any input plugin named jdbc. I can't seem to find the oracle-connector-java-5.1.33-bin.jar file in any of the logstash directories. I am new to RHEL and working on ELK for a few weeks. Any help is greatly appreciated. Thanks.
To install plugins locally, you must first build the gem using jruby.
gem build logstash-input-jdbc.gemspec
Then you can go ahead and install that gem artifact using
bin/plugin install logstash-input-jdbc-1.0.0.gem
oracle--connector-java-5.1.33-bin.jar, no jdbc driver libraries are packaged within this plugin, you must download and provide the path to the library on your own.
let me know if that helps!