Cassandra database tls connection issue on logstash

Elastic Stack Logstash
1

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.

2

Welcome!

Could you share your existing job configuration?

3 
 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.

4

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, right?

It has not been updated for 7 years. I'm not sure it supports SSL...
I think you need to ask the author...

5

we are okay use new driver as well but what connection string we need to pass for cassandra connection for ssl.

6

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

So look at the jdbc driver docs to see what is needed.

7

Thanks for reply, I tried but it didn't work.

8

What did you try? I didn't give any advice but to look at the documentation of the jdbc driver.

9

In logstash input file added below lines

String jdbcUrl = "jdbc:cassandra://:/?ssl=true&sslTruststore=path/to/truststore&truststorePassword=password";

But still connection failed.

10

Where is the documentation about those settings? Could you share the link? And how does look your Logstash config now?

11

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