Skip to main content
Question

How to test SSL working both Server and Client?

  • June 25, 2020
  • 3 replies
  • 8 views

cp00634326
Forum|alt.badge.img+1

Hi,
I have installed a self signed SSL in a 3 node cluster and it installed successfully. Even i have tested running few COPY statements in VSQL and it ran successfully ,Verified also in Session table and for those COPY commands it is SERVER is SSL_STATE which means SSL enabled.Also when i ran few user queries also it is SERVER in SSL_STATE.

Now my question is ,when i am running a query from my DBVisualizer which is a jdbc client and if i see that session_id in Session table it comes as None in SSL_State, how to resolve this issue and make it whatever query comes from jdbc to be SERVER in SSL_STATE column.
Do i need to configure anything in client?in dbvisualizer when i make SSL =true it is not connecting

3 replies

SergeB
Forum|alt.badge.img
  • Participating Frequently
  • June 26, 2020

For JDBC cliennts, you will need to specify a truststore and possibly a keystore. https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/Security/TLS/ConfiguringTLSForJDBCClients.htm
If using Vertica jdbc driver 9.2 or higher, you might also be able to specify the truststore/keystore in the Connection properties (similar to how you set SSL=true)
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/ConnectingToVertica/ClientJDBC/JDBCConnectionProperties.htm?zoom_highlight=KeystorePath+Truststorepath


cp00634326
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 27, 2020

Thanks Serge,As i am using the DB Visualizer,where can i do the configuration of JDBC setuo...Can you please share if you have already?


cp00634326
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • July 2, 2020

It worked...thanks