| From: | Pierre Ochsenbein <pierreochsenbein(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | LDAP authentication failed |
| Date: | 2019-05-09 08:23:06 |
| Message-ID: | CABG8FoOb0S2EiNSbAgHuv+BzndymvV_VLu969qb3tmXFQ6Z-fQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello
I'm running on PostgreSQL 10.6 and would like to connect with LDAP users.
I have sync all users from my group in my database.
I can connect when I use auth "trust" in pg_hba but I would like to connect
remotely with AD password and I have this error:
SSL is ON in postgresql.conf
FATAL: LDAP authentication failed for user "userA" FATAL: no pg_hba.conf
entry for host "10.1.1.181", user "userA", database "DB01", SSL off
*pg_hba.conf:*
hostssl all all 10.1.1.18/32 ldap
ldapurl="ldap://ldap.local/OU=ASA,OU=Forest%20Admin%20Accounts%20%26%20Roles,DC=ASATL,DC=NET?sAMAccountName?sub"
ldaptls=1 ldapbinddn="CN=POSTGRES,OU=Service Accounts,OU=Global,OU=Member
Servers,DC=PMINTL,DC=NET" ldapbindpasswd='password001'
I need to put the Group AD in ldap query line in pg_hba file?
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vijaykumar Jain | 2019-05-09 09:10:33 | Re: [External] LDAP authentication failed |
| Previous Message | Hoa Phan | 2019-05-09 07:48:00 | How to create a postgres user that auth by AUTH_REQ_MD5 |