How to test SSL working both Server and Client?

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

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.