Postgres Pro
Downloads
Home   >   mailing lists

LDAP authentication failed - Mailing list pgsql-admin

From Pierre Ochsenbein
Subject LDAP authentication failed
Date
Msg-id CABG8FoOb0S2EiNSbAgHuv+BzndymvV_VLu969qb3tmXFQ6Z-fQ@mail.gmail.com
Whole thread Raw
Responses Re: [External] LDAP authentication failed
Re: LDAP authentication failed
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Hoa Phan
Date:
Subject: How to create a postgres user that auth by AUTH_REQ_MD5
Next
From: Vijaykumar Jain
Date:
Subject: Re: [External] LDAP authentication failed