LDAP Configuration - Mailing list pgsql-admin

From Anjul Tyagi
Subject LDAP Configuration
Date
Msg-id em62afb13f-e34b-48c8-8500-7edfd179a57b@iboss01108
Whole thread Raw
Responses Re: LDAP Configuration  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: LDAP Configuration  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Team,

we are implementing the LDAP authentication and we are able to connect with LDAP and able to authenticate the user with that. However we have 2 type of users, one - corporate users and available of Active Directory and second application user, which is used by different application to connect with database. 

Below entry i did in the pg_hba.conf file, if i create user in DB (similar exist on AD) it works. However if i create one user with password, it calls the LDAP server for authentication and fails as it does not exists in AD. 

host    all             all       0.0.0.0/0            ldap ldapserver=<LDAL Server> ldapbasedn="OU=Corporate,DC=etch,dc=com" ldapbinddn="CN=AdSyncAcct,OU=Service Accounts,DC=etch,DC=com" ldapbindpasswd="Password" ldapsearchattribute="sAMAccountName"

we are using the postgres 10.10 version. 

can you please suggest the pg_hba.conf file entry, that will help us to authenticate the users from LDAP and from postgres as well. 
 
 
 

Regards,

Anjul TYAGI

 

ü Go Green


pgsql-admin by date:

Previous
From: Ramakrishna Chava
Date:
Subject: Re: Can not make further subscriptions
Next
From: Laurenz Albe
Date:
Subject: Re: LDAP Configuration