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

How do I setup DBViaualizer to connect to vertica using Kerberos authentication?

I need to connect to linux based vertica 7.1 with windows based dbvisualizer thru jdbc. The documentation says to configure the JAASConfigName property as verticajdbc. I am not sure where to put the configuration file. Do you have any information on how to set this up?
Thanks!

Comments

  • You will need to use the "Driver Properties" feature to
    set them. You get to driver properties as follows:

    - Select the actual database connection in the tree
    • In the Connection tab select the Database Properties sub tab
    at the bottom
    - In the Category tree, choose "Driver Properties"

    Click the + icon below the list of properties and simply add
    the name of the parameter and its value. Repeat the above for
    the other parameters.

    Don't forget to press Apply when ready. Then simply Connect.

    image
  • Thanks for your reply. I had just gotten this to work using the instructions in the vertica documentation but decided to try your way which was much simpler than editing the java.security file so I went back and removed the updates to that file, then simply added the correct parameters to the driver properties page and it connected properly.

    By the way, DBVisualizer version 9.2 has the java parameters already in the properties tab so there was no need to add them.

    Thanks for your help!
  • Also thanks to Evan for helping on this.

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.