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

Comments

• Options

  id10t

  January 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.
  
  
  

  0
• Options

  RCasey

  January 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!
  

  0
• Options

  RCasey

  January 2015

  Also thanks to Evan for helping on this.
  

  0