| From: | "Tang, Ronald K CIV FNMOC, N6" <ronald(dot)k(dot)tang(at)navy(dot)mil> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Postgres user authentication with secure LDAP |
| Date: | 2017-08-10 21:02:28 |
| Message-ID: | DBF3E054DB2B404ABFD101589632D6521E02E0E7@NAWEMUGUXM02V.nadsuswe.nads.navy.mil |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I am trying to configure my Postgres server to use LDAP for authentication. My pg_hba.conf config line is:
ldap ldapserver=ldaps://myldaps.company.com ldapport=636 ldaptls=1 ldapprefix="uid=" ldapsuffix=",ou=People,o=my.company.com"
I queried the LDAP server successfully with the 'ldapsearch' tool with the same DN. However, I cannot get it to work successfully on Postgres. I have ssl=on and all server and CA certs installed.
Postgres version 9.5.6.
Error log:
could not initialize LDAP: No such file or directory
LDAP authentication failed for user "user1"
auth_failed, auth.c:288
---------------------------------------
Thanks for any helps.
Ron
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Torralba | 2017-08-10 21:56:50 | Why? Just curious and need to know timestamp |
| Previous Message | Don Seiler | 2017-08-10 18:14:53 | Re: Shutdown Order with Primary/Standby? |