title: Datagrip Intellij Cassandra SSL connection
body: <p>Looking for any suggestions connecting with an SSL enabled Cassandra cluster with Datagrip / Intellij / DBVisualizer or any other DB admin tool.</p>
  
  <p><a href="https://i.stack.imgur.com/18spn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/18spn.png" alt="enter image description here"></a></p>
  
  <p>Solution #1</p>
  
  <p>I've tried using the PEM files in the Intellij SSL tab that used for connecting with cqlsh. These do not work. The PEM files do work with cqlsh.</p>
  
  <p>Solution #2
  Wondering if there there are some properties to enable SSL. I've tried the following with JKS keystore and Truststore files:</p>
  
  <p><code>-Djavax.net.ssl.trustStore=
  -Djavax.net.ssl.trustStorePassword=
  -Djavax.net.ssl.keyStore=
  -Djavax.net.ssl.keyStorePassword=</code></p>
  
  <p>With these properties Intellij / Datagrip does not seem to connect via SSL I feel like a missing property is necessary to enable it.</p>
  
  <p>Connecting with a local non-ssl enable cluster works fine. Any advise would be appreciated with connecting with an SSL enabled cluster.</p>