How to install logstash-input-jdbc in windows

hi,

I tried to use logstash-input-jdbc using followed command :plugin install logstash-input-jdbc
But it is showing some error,

i am using logstash logstash-1.5.2 ,
how to install jdbc plugin in windows machine so I can get started with it ...

What kind of error, specifically? That's kind of important.

@magnusbaeck I guess my firewall/proxy setting does not allow to me download the plugin

plugin install logstash-input-jdbc
Unable to download data from https://rubygems.org/ - Errno::ECONNREFUSED: Connec
tion refused - Connection refused (https://api.rubygems.org/latest_specs.4.8.gz)

so any other alternative , so we can install it on windows ?

Have you configured use of your proxy? See https://github.com/elastic/logstash/issues/3314 and https://github.com/elastic/logstash/issues/2557.

I am working on windows environment and all the solution are given for linux ..
Is there any way to download the plugin and install it manually ,( just like how we do for es plugin like head)

Hi I have same problem.

"D:\logstash\logstash-1.5.4\vendor\jruby\bin\jruby"
io/console not supported; tty will not be manipulated
Validating logstash-input-jdbc
Unable to download data from https://rubygems.org/ - EOFError: End of file reach
ed (https://rubygems.org/latest_specs.4.8.gz)
ERROR: Installation aborted, verification failed for logstash-input-jdbc

D:\logstash\logstash-1.5.4\bin>plugin install logstash-input-jdbc-1.0.0.gem
io/console not supported; tty will not be manipulated
Validating logstash-input-jdbc-1.0.0.gem
Installing logstash-input-jdbc
Error Bundler::HTTPError, retrying 1/10
Could not fetch specs from https://rubygems.org/
Error Bundler::HTTPError, retrying 2/10
Could not fetch specs from https://rubygems.org/

I don't have internet access.

How can I install this plugin manually?

Thanks,

Currently, the only way to download this offline is to download it when online into a
local logstash instance, and then copy that logstash package into your offline environment. Since there are other dependencies, just fetching the ".gem" is not enough.

Thanks Talevy.
could you please explain how to install this.
As my proxy is not allowing me to dowload it from bin/plugin install xyz..
So I have downloaded it from github, please let me know how to proceed further ..

you can download the gem (found here: https://rubygems.org/downloads/logstash-input-jdbc-1.0.0.gem) elsewhere and then bring it over to your system. Although, this will still attempt to download dependencies.

Thanks for the quick reply

I have set proxy host with parameters -J-Dhttp.proxyHost and tried to install manually sequel 4.26.0

D:\logstash\logstash-1.5.4\vendor\jruby\bin>gem install sequel-4.26.0.gem
io/console not supported; tty will not be manipulated
Successfully installed sequel-4.26.0
WARNING: Unable to pull data from 'https://rubygems.org/': SocketError: initial
ize: name or service not known (https://rubygems.org/specs.4.8.gz)
1 gem installed

D:\logstash\logstash-1.5.4\bin>plugin install logstash-input-jdbc-1.0.0.gem

io/console not supported; tty will not be manipulated
Validating logstash-input-jdbc-1.0.0.gem
Installing logstash-input-jdbc
Error Bundler::InstallError, retrying 1/10
An error occurred while installing sequel (4.26.0), and Bundler cannot continue.

Make sure that gem install sequel -v '4.26.0' succeeds before bundling.
Error Bundler::InstallError, retrying 2/10
An error occurred while installing sequel (4.26.0), and Bundler cannot continue.

Make sure that gem install sequel -v '4.26.0' succeeds before bundling.
Error Errno::EBADF, retrying 3/10
Bad file descriptor - Bad file descriptor

Is there a place where I can download logstash with input_jdbc already installed?

not at the moment. but you can download logstash, install the plugin, and then re-package the logstash directory and push it anywhere you need.

Hello Denis,

Have you been successful installing logstash-input-plugin in windows?
Please guide.

Thank you!
Rehan