Unable to install logstash-input-jdbc to connect to Oracle Db

[groverjatin17 (Jatin)]

Hi,

I am using ELK 6.2.4 for a while. Till now i have been uploading .csv files to create index in ES and create dashboards.
But recently my team asked to make it more dynamic and automated as in connect to a database , fetch data and create index and dashboard. My only lead is this plugin for Logstash.

Since I am using ELK on a secure server where i couldn't directly install this plugin, so I downloaded it from Github as a zip and tried installing with this command

/bin/logstash-plugin install file:///path_of_the_file.zip

It returned this error:-

ERROR: Invalid pack for: file:///home/tomadm/logstash-input-jdbc-master.zip, reason: The pack must contains at least one plugin, message: The pack must contains at least one plugin

Please help me solve this issue.

Thanks

[magnusbaeck (Magnus Bäck)]

That method for offline installation of plugins doesn't work. See https://www.elastic.co/guide/en/logstash/current/offline-plugins.html.

[groverjatin17 (Jatin)]

Hello sir. I did try this as well.

`

./bin/logstash-plugin prepare-offline-pack logstash-input-jdbc

`

It returned:-

** Failed to open TCP connection to rubygems.org:443**

I am assuming it means that it still requires to connect to rubygems.org to install the dependencies.

[magnusbaeck (Magnus Bäck)]

Did you run the prepare-offline-pack command on an internet-connected host?