Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] Postgres user authentication with secure LDAP - Mailing list pgsql-admin

From Tang, Ronald K CIV FNMOC, N6
Subject [ADMIN] Postgres user authentication with secure LDAP
Date
Msg-id DBF3E054DB2B404ABFD101589632D6521E02E0E7@NAWEMUGUXM02V.nadsuswe.nads.navy.mil
Whole thread Raw
Responses Re: [ADMIN] Postgres user authentication with secure LDAP
Re: [ADMIN] Postgres user authentication with secure LDAP
List pgsql-admin
Tree view 
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
successfullyon 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

pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: [ADMIN] Shutdown Order with Primary/Standby?
Next
From: Jorge Torralba
Date:
Subject: [ADMIN] Why? Just curious and need to know timestamp