Skip to main content

How can i configure LDAP Authentication in Vertica 7.1??

  • August 19, 2014
  • 1 reply
  • 10 views

Armando_Tello
How can i configure LDAP Authentication in Vertica 7.1??

1 reply

Theodore_Choutz
this is how we set it up :


dbadmin=> CREATE AUTHENTICATION ldapaccess METHOD 'ldap' HOST '0.0.0.0/0';
CREATE AUTHENTICATION
dbadmin=> GRANT AUTHENTICATION ldapaccess TO "firstname.lastname";  GRANT AUTHENTICATION    dbadmin=> ALTER AUTHENTICATION ldapacces SET HOST='ldap://host',basedn='ou=...,ou=...,dc=...,dc=com',search_attribute='...',binddn='CN=...,OU=Users,OU=...,DC=...,DC=com',bind_password='...';  ALTER AUTHENTICATION    -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
i would recommend you try to connect like this:  $ vsql -h verticaDB_IP -U firstname.lastname      if you connect like this :  $ vsql -U firstname.lastname.    it may not work