How can i configure LDAP Authentication in Vertica 7.1??

Armando_Tello

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