# Logstash-all-plugins-2.3.1 connect to Sybase error

**URL:** <https://discuss.elastic.co/t/logstash-all-plugins-2-3-1-connect-to-sybase-error/49879>\
**Category:** Logstash\
**Created:** [May 12, 2016, 9:52am UTC](https://discuss.elastic.co/t/logstash-all-plugins-2-3-1-connect-to-sybase-error/49879 "2016-05-12T09:52:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhanght1](https://avatars.discourse-cdn.com/v4/letter/z/958977/32.png) [@zhanght1](https://discuss.elastic.co/u/zhanght1)\
**Post date:** [May 12, 2016, 9:52am UTC](https://discuss.elastic.co/t/logstash-all-plugins-2-3-1-connect-to-sybase-error/49879/1 "2016-05-12T09:52:27Z")

</div>

After I configure the logstash.conf  
input{  
jdbc {  
jdbc\_driver\_library =\> "/data/logstash/vendor/jar/jdbc/jconn3.jar"  
jdbc\_driver\_class =\> "com.sybase.jdbc3.jdbc.SybDriver"  
jdbc\_connection\_string =\> "jdbc:sybase:Tds:10.122.11.119:5000"

I got this error  
Pipeline aborted due to error {:exception=\>#\<Sequel::DatabaseConnectionError: Java::JavaSql::SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).\>, :backtrace=\>["java.sql.DriverManager.getConnection(java/sql/DriverManager.java:664)", "java.sql.DriverManager.getConnection(java/sql/DriverManager.java:247)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)", "RUBY.connect(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/adapters/jdbc.rb:210)", "RUBY.make\_new(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool.rb:103)", "RUBY.make\_new(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:224)", "RUBY.available(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:197)", "RUBY.\_acquire(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:133)", "RUBY.acquire(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:147)", "RUBY.sync(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:265)", "org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)", "RUBY.sync(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:265)", "RUBY.acquire(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:146)", "RUBY.hold(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:104)", "RUBY.synchronize(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/database/connecting.rb:256)", "RUBY.test\_connection(/data/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/database/connecting.rb:266)", "RUBY.prepare\_jdbc\_connection(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin\_mixins/jdbc.rb:170)", "RUBY.register(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167)", "RUBY.start\_inputs(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.1-java/lib/logstash/pipeline.rb:330)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)", "RUBY.start\_inputs(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.1-java/lib/logstash/pipeline.rb:329)", "RUBY.start\_workers(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.1-java/lib/logstash/pipeline.rb:180)", "RUBY.run(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.1-java/lib/logstash/pipeline.rb:136)", "RUBY.start\_pipeline(/data/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.1-java/lib/logstash/agent.rb:465)", "java.lang.Thread.run(java/lang/Thread.java:745)"], :level=\>:error}

Could you kindly give me some help for this error?  
BR

---

<div class="post-metadata">

**Author:** ![webvisor](https://avatars.discourse-cdn.com/v4/letter/w/db5fbb/32.png) [@webvisor](https://discuss.elastic.co/u/webvisor)\
**Post date:** [June 24, 2016, 9:55am UTC](https://discuss.elastic.co/t/logstash-all-plugins-2-3-1-connect-to-sybase-error/49879/2 "2016-06-24T09:55:59Z")

</div>

Works fine with me but I've added the db\_name after the portnumber in the connection string (seperated by a '/')

E.g dbc\_connection\_string =\> "jdbc:sybase:Tds:10.122.11.119:5000/DBNAME"

Hope it helps!

Grtz,  
Bert

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:50am UTC](https://discuss.elastic.co/t/logstash-all-plugins-2-3-1-connect-to-sybase-error/49879/3 "2017-07-06T04:50:55Z")

</div>