From: | Gregory Nicol <Gregory(dot)Nicol(at)Medbank(dot)com(dot)mt> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | LDAP authentication without OU in ldapbasedn |
Date: | 2017-07-13 09:46:59 |
Message-ID: | 055b780f471f4661b7f293fc16b8c955@MBEX01-LV.medbank.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good morning all,
I can't seem to get LDAP Authentication working without an OU in the ldapbasedn. My users are spread across multiple OUs without a common root OU which is why I'm trying to authenticate with just the DC.
With pg_hba.conf like this, I can connect successfully from psql...
local all all ldap ldapserver=192.168.xxx.xxx ldapbasedn="OU=DB_Accounts,DC=acme,DC=local" ldapbinddn="CN=XXXX ,OU=DB_Accounts,DC=acme,DC=local" ldapsearchattribute=sAMAccountName ldapbindpasswd=xxxxxxxxxxxxxxx
But if I remove the OU from the ldapbasedn, like this ...
local all all ldap ldapserver=192.168.xxx.xxx ldapbasedn="DC=acme,DC=local" ldapbinddn="CN=XXXX ,OU=DB_Accounts,DC=acme,DC=local" ldapsearchattribute=sAMAccountName ldapbindpasswd=xxxxxxxxxxxxxxx
Then I get:
psql: FATAL: LDAP authentication failed for user "xxxxxxxx"
select VERSION();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit
psql --version
psql (PostgreSQL) 9.6.2
Kind Regards,
Greg
________________________________
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and / or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Ruderich | 2017-07-13 12:40:57 | Long wrapped header lines in psql with expanded mode (9.6.3) |
Previous Message | Michael Paquier | 2017-07-13 09:26:59 | Re: Associating a basebackup and it's .backup WAL file |