# Cassandra to Kibana

**URL:** <https://discuss.elastic.co/t/cassandra-to-kibana/218062>\
**Category:** Logstash\
**Tags:** elastic-stack-monitoring, elastic-stack-alerting\
**Created:** [February 5, 2020, 10:51pm UTC](https://discuss.elastic.co/t/cassandra-to-kibana/218062 "2020-02-05T22:51:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karthik2411](https://avatars.discourse-cdn.com/v4/letter/k/ed8c4c/32.png) [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\
**Post date:** [February 5, 2020, 10:51pm UTC](https://discuss.elastic.co/t/cassandra-to-kibana/218062/1 "2020-02-05T22:51:41Z")

</div>

I am trying to constantly check the status of cassandra for every one hour and send all the information into kibana so that I can create a watcher that reports whenever I find a failure in the log. Would it be possible for logstash to send this information from cassandra to Kibana on a daily basis. If yes what are the steps I need to follow.Please reply.

---

<div class="post-metadata">

**Author:** ![Vadims\_Daleckis](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadims_daleckis/32/57613_2.png) [@Vadims\_Daleckis](https://discuss.elastic.co/u/Vadims_Daleckis)\
**Post date:** [February 7, 2020, 2:45pm UTC](https://discuss.elastic.co/t/cassandra-to-kibana/218062/2 "2020-02-07T14:45:54Z")

</div>

I'm not sure if that would solve your problem, but you could configure Elastic Packetbeat for Cassandra: [https://www.elastic.co/guide/en/beats/packetbeat/master/configuration-cassandra.html](https://www.elastic.co/guide/en/beats/packetbeat/master/configuration-cassandra.html)

Here is a description of Packetbeat: [https://www.elastic.co/guide/en/beats/packetbeat/master/packetbeat-overview.html](https://www.elastic.co/guide/en/beats/packetbeat/master/packetbeat-overview.html)

---

<div class="post-metadata">

**Author:** ![Karthik2411](https://avatars.discourse-cdn.com/v4/letter/k/ed8c4c/32.png) [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\
**Post date:** [February 12, 2020, 6:56pm UTC](https://discuss.elastic.co/t/cassandra-to-kibana/218062/3 "2020-02-12T18:56:56Z")

</div>

Hello @Vadims_Daleckis,

Thanks for the reply. I wan't sure about the way I want to do this when I posted the question initially. Now I have decided that I want to use an existing logstash server after reading this article "[https://www.elastic.co/blog/logstash-jdbc-input-plugin](https://www.elastic.co/blog/logstash-jdbc-input-plugin)". I have written a JSON and now I am confused where exactly I need to put this JSON in order to fulfill the requirement. Please throw some light on this if you could. The following is the JSON:

# file: simple - out.conf

input {  
jdbc {  
# cassandra jdbc connection string to our database, BTS  
jdbc\_connection\_string =\> "jdbc:cql://localhost:[173.39.231.46/BTS](http://173.39.231.46/BTS)"  
# The user we wish to execute our statement as  
jdbc\_user =\> "cassandra"  
# The path to our downloaded jdbc driver  
jdbc\_driver\_library =\> "/path/to/cql-3.2.1-1201.jdbc41.jar"  
# The name of the driver class  
for cqlsh  
jdbc\_driver\_class =\> "org.apache.cassandra.cql.jdbc.CassandraDriver"  
# our query  
statement =\> "cqlsh --cqlversion 3.2.1 [173.39.231.46](http://173.39.231.46)-u pcia\_rw -p hyT%sD3z1KAq25eY -k ks\_amer\_pda"  
}  
}  
output {  
stdout {  
codec =\> json\_lines  
}  
}

---

<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:** [March 11, 2020, 6:56pm UTC](https://discuss.elastic.co/t/cassandra-to-kibana/218062/4 "2020-03-11T18:56:56Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.