# Cassandra database tls connection issue on logstash **URL:** \ **Category:** Logstash\ **Created:** [March 28, 2024, 8:41am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367 "2024-03-28T08:41:25Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![gadde36256](https://avatars.discourse-cdn.com/v4/letter/g/f0a364/32.png) [@gadde36256](https://discuss.elastic.co/u/gadde36256)\ **Post date:** [March 28, 2024, 8:41am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/1 "2024-03-28T08:41:25Z")
Hello All, Recently we made changes on Cassandra database to connect with tls, I don't find much details to configuring tls on logstash. Can you pls share the any help link for configuring the ssl with logstash. Thanks advance. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 28, 2024, 9:04am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/2 "2024-03-28T09:04:03Z")
Welcome! Could you share your existing job configuration? ---
**Author:** ![gadde36256](https://avatars.discourse-cdn.com/v4/letter/g/f0a364/32.png) [@gadde36256](https://discuss.elastic.co/u/gadde36256)\ **Post date:** [March 28, 2024, 1:18pm UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/3 "2024-03-28T13:18:17Z")
```auto jdbc { jdbc_driver_library => "./cassandra-jdbc-driver-0.6.4-shaded.jar" jdbc_driver_class => "com.github.cassandra.jdbc.CassandraDriver" jdbc_connection_string => "jdbc:c*://${host}:${port}/${keyspace}" jdbc_user => "${user}" jdbc_password => "${password}" jdbc_validate_connection => true lowercase_column_names => true statement => "${statement}" record_last_run => false } ``` I have used above configuration for connecting cassandra database, now I need to connect with ssl based. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 28, 2024, 1:36pm UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/4 "2024-03-28T13:36:43Z")
Please don't post unformatted code, logs, or configuration as it's very hard to read. Instead, paste the text and format it with \ icon or pairs of triple backticks (```), and check the preview window to make sure it's properly formatted before posting it. This makes it more likely that your question will receive a useful answer. I think you are using [this driver](https://github.com/zhicwu/cassandra-jdbc-driver), right? It has not been updated for 7 years. I'm not sure it supports SSL... I think you need to ask the author... ---
**Author:** ![gadde36256](https://avatars.discourse-cdn.com/v4/letter/g/f0a364/32.png) [@gadde36256](https://discuss.elastic.co/u/gadde36256)\ **Post date:** [March 28, 2024, 4:10pm UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/5 "2024-03-28T16:10:24Z")
we are okay use new driver as well but what connection string we need to pass for cassandra connection for ssl. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 28, 2024, 4:49pm UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/6 "2024-03-28T16:49:25Z")
It depends on the driver I guess. Each datasource/driver has its own parameters. For postgresql, I think it's something like ``` ssl=true ``` See [Using SSL | pgJDBC](https://jdbc.postgresql.org/documentation/ssl/#configuring-the-client) So look at the jdbc driver docs to see what is needed. ---
**Author:** ![gadde36256](https://avatars.discourse-cdn.com/v4/letter/g/f0a364/32.png) [@gadde36256](https://discuss.elastic.co/u/gadde36256)\ **Post date:** [March 29, 2024, 5:29am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/7 "2024-03-29T05:29:55Z")
Thanks for reply, I tried but it didn't work. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 29, 2024, 6:33am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/8 "2024-03-29T06:33:00Z")
What did you try? I didn't give any advice but to look at the documentation of the jdbc driver. ---
**Author:** ![gadde36256](https://avatars.discourse-cdn.com/v4/letter/g/f0a364/32.png) [@gadde36256](https://discuss.elastic.co/u/gadde36256)\ **Post date:** [March 31, 2024, 9:26am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/9 "2024-03-31T09:26:34Z")
In logstash input file added below lines String jdbcUrl = "jdbc:cassandra://:/?ssl=true&sslTruststore=path/to/truststore&truststorePassword=password"; But still connection failed. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 31, 2024, 11:28am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/10 "2024-03-31T11:28:02Z")
Where is the documentation about those settings? Could you share the link? And how does look your Logstash config now? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 28, 2024, 11:28am UTC](https://discuss.elastic.co/t/cassandra-database-tls-connection-issue-on-logstash/356367/11 "2024-04-28T11:28:57Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.