Well, first off, you're on the wrong port for LDAPS://
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of Jeffrey Shaw <shawjef3@gmail.com> Sent: Thursday, August 10, 2017 4:57:51 PM To: Tang, Ronald K CIV FNMOC, N6 Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres user authentication with secure LDAP
Hi Ron,
What OS is your server running, and what OS is your client running?
I found that it was only possible to get clients from a Windows machine to authenticate via ldap against a server that was also running Windows. Hopefully someone else has more experience here than me.
On Thu, Aug 10, 2017 at 5:02 PM, Tang, Ronald K CIV FNMOC, N6 <ronald.k.tang@navy.mil> wrote:
Hi,
I am trying to configure my Postgres server to use LDAP for authentication. My pg_hba.conf config line is:
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