# Logstash - Cassandra error-NoHostAvailableException **URL:** \ **Category:** Logstash\ **Created:** [June 24, 2016, 8:24pm UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923 "2016-06-24T20:24:19Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Srivastavark](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@Srivastavark](https://discuss.elastic.co/u/Srivastavark)\ **Post date:** [June 24, 2016, 8:24pm UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/1 "2016-06-24T20:24:19Z")
Hello Experts, I am new to logstash and trying to index Cassandra data in Elasticsearch using JDBC input plugin but facing issue in test Logstash 2.3.3, Cassandra -3.5 Pipeline aborted due to error {:exception=\>#\ "jdbc:cassandra://localhost:9160/Excelsior" # The user we wish to execute our statement as jdbc\_user =\> "cassandra" # The path to our downloaded jdbc driver jdbc\_driver\_library =\> "/Users/mk/Desktop/CassandraJdbcDriver/cassandrajdbc1.1.jar" # The name of the driver class for Postgresql jdbc\_driver\_class =\> "com.dbschema.CassandraJdbcDriver" # our query statement =\> "select \* from esdemo" } } output { stdout { codec =\> json\_lines } } Any help appreciated. Regards Mstrong text ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 25, 2016, 9:04pm UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/2 "2016-06-25T21:04:28Z")
> [@Srivastavark](#): > > Pipeline aborted due to error {:exception=\># That does not look like the entire error, posting that would be helpful. However based on your subject it looks like it cannot connect to Cassandra. ---
**Author:** ![Srivastavark](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@Srivastavark](https://discuss.elastic.co/u/Srivastavark)\ **Post date:** [June 26, 2016, 10:53am UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/4 "2016-06-26T10:53:21Z")
Many thanks Mark, Sorry, didn't paste properly. Here is the error ![](https://us1.discourse-cdn.com/elastic/original/2X/4/4a9ff52d8843361835ecce85e8ef8314436829d6.jpg) log ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 26, 2016, 8:37pm UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/5 "2016-06-26T20:37:37Z")
Please don't post pictures of text, they are difficult to read and some people may not be even able to see them. But again, from what I can see it looks like it cannot connect to Cassandra for some reason. ---
**Author:** ![Srivastavark](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@Srivastavark](https://discuss.elastic.co/u/Srivastavark)\ **Post date:** [June 28, 2016, 12:17pm UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/6 "2016-06-28T12:17:51Z")
Okay. Thank you, let me check. ---
**Author:** ![Srivastavark](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@Srivastavark](https://discuss.elastic.co/u/Srivastavark)\ **Post date:** [July 1, 2016, 8:47pm UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/7 "2016-07-01T20:47:07Z")
org.apache.cassandra.cql.jdbc.CassandraDriver Hi Mark, Here is my configuration. Can u help me, what i am missing? Configuration OK , check by --configtest JDBC driver - [http://www.dbschema.com/cassandra-jdbc-driver.html](http://www.dbschema.com/cassandra-jdbc-driver.html) input { jdbc { jdbc\_connection\_string =\> "jdbc:cassandra://localhost:9160/mydata" jdbc\_user =\> "cassandra" jdbc\_driver\_library =\> "D:\driver\cassandrajdbc1.1" jdbc\_driver\_class =\> "org.apache.cassandra.cql.jdbc.CassandraDriver" statement =\> "SELECT \* from sampledata" } } output { ``` stdout { codec => json } ``` } error D:\ELK\logstash-2.3.3\logstash-2.3.3\bin\>logstash -f d:\cass.conf io/console not supported; tty will not be manipulated Settings: Default pipeline workers: 4 ←[31mPipeline aborted due to error {:exception=\>#org.apache.cassandra.cql.jdbc.CassandraDriver not loaded. Are you sure you've in cluded the correct jdbc driver in :jdbc\_driver\_library?\>, :backtrace=\>["D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin\_mixins/jdbc.rb:156:in prepare\_jdbc\_connection'", "D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167:in register'", "D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.3-java/lib/logstash/pipeline.rb:330:in start\_inputs'", "org/jruby/RubyArray.java:1613:ineach'", "D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.3-java/lib/logstash/pipeline.rb:329:in start\_inputs'", "D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.3-java/lib/logstash/pipeline.rb:180:in start\_workers'", "D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.3-java/lib/logstash/pipeline.rb:136:in run'", "D:/ELK/logstash-2.3.3/logstash-2.3.3/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.3-java/lib/logstash/agent.rb:473:in start\_pipeline'"], :level=\>:error}←[0m stopping pipeline {:id=\>"main"} The signal HUP is in use by the JVM and will not work correctly on this platform Thanks ---
**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:49am UTC](https://discuss.elastic.co/t/logstash-cassandra-error-nohostavailableexception/53923/8 "2017-07-06T04:49:49Z")
Closed on July 6, 2017, 4:49am UTC