How to test SSL working both Server and Client?

cp00634326

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

SergeB

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

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

It worked...thanks