How can i configure LDAP Authentication in Vertica 7.1??

Comments

  • 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 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file