Skip to main content

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

  • January 30, 2015
  • 3 replies
  • 16 views

RCasey
Forum|alt.badge.img+1
  • Participating Frequently
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!

3 replies

id10t
Forum|alt.badge.img
  • Participating Frequently
  • January 31, 2015
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

RCasey
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • January 31, 2015
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!

RCasey
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • January 31, 2015
Also thanks to Evan for helping on this.