Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.