Hi!
I'm trying to connect to Sybase SQLAnywhere
My Logstash input plugin is:
input {
jdbc {
jdbc_connection_string => "jdbc:sqlanywhere://host:port/db_name"
jdbc_user => "user"
jdbc_password => "passs"
jdbc_validate_connection => true
jdbc_driver_library => "/usr/share/logstash/jconn3-6.0.jar"
jdbc_driver_class => "com.sybase.jdbc3.jdbc.SybDriver"
statement => "SELECT User_ID, User_Name FROM users"
}
}
and I get the following error:
Error registering plugin {:plugin=>"<LogStash::Inputs::Jdbc jdbc_connection_string=>"jdbc:sqlanywhere://... , :error=>"NoMethodError: undefined method new' for #<Array:0x5031fa45>"} Pipeline aborted due to error {:exception=>#<Sequel::DatabaseConnectionError: NoMethodError: undefined methodnew' for #Array:0x5031fa45>, :backtrace=>["/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/adapters/jdbc.rb:222:in connect'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool.rb:116:inmake_new'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:228:in make_new'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:201:inavailable'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:137:in _acquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:151:inacquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:282:in sync'", "org/jruby/ext/thread/Mutex.java:149:insynchronize'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:282:in sync'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:150:inacquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/extensions/connection_validator.rb:98:in acquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:106:inhold'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/database/connecting.rb:285:in synchronize'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/database/connecting.rb:295:intest_connection'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/plugin_mixins/jdbc.rb:171:in prepare_jdbc_connection'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/inputs/jdbc.rb:191:inregister'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:268:in register_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:279:inregister_plugins'", "org/jruby/RubyArray.java:1613:in each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:279:inregister_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:429:in start_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:323:instart_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:214:in run'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:398:instart_pipeline'"]}
What does it means? How can I fix it?
Any ideas?