I trying to log SQL server data using logstash but getting following error:
PS D:\elk\logstash\bin> .\logstash -f simple.conf io/console not supported; tty will not be manipulated Settings: Default pipeline workers: 4 LoadError: no such file to load -- D:/ELK/sqljdbc4 require at org/jruby/RubyKernel.java:1040 require at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/polyglot-0.3.5/lib/polyglot.rb:65 load_drivers at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/plugin_mixins/jd bc.rb:115 each at org/jruby/RubyArray.java:1613 load_drivers at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/plugin_mixins/jd bc.rb:113 prepare_jdbc_connection at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/plugin_mixins/jd bc.rb:127 register at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.0/lib/logstash/inputs/jdbc.rb:1 54 start_inputs at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:319 each at org/jruby/RubyArray.java:1613 start_inputs at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:318 start_workers at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:169 run at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/pipeline.rb:123 execute at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/agent.rb:211 run at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/runner.rb:90 call at org/jruby/RubyProc.java:281 run at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.2.2-java/lib/logstash/runner.rb:95 call at org/jruby/RubyProc.java:281 initialize at D:/ELK/logstash/vendor/bundle/jruby/1.9/gems/stud-0.0.22/lib/stud/task.rb:24
My config file is
file: simple-out.conf
input {
jdbc {
# Postgres jdbc connection string to our database, mydb
jdbc_connection_string => "jdbc:sqlserver://155.17.41.140:1433;"
# The user we wish to execute our statement as
jdbc_user => "xxxxx"
jdbc_password => "xxxx"
# The path to our downloaded jdbc driver
jdbc_driver_library => "D:\ELK\sqljdbc4.jar"
# The name of the driver class for Postgresql
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
# our query
statement => "SELECT * from vEvents"
}
}
output {
stdout { codec => json_lines }
}
Please Help.