Re: BUG #16064: Ldap Authentication failing with pg_hba.conf entry - Mailing list pgsql-bugs

From Yudhveer Kandukuri
Subject Re: BUG #16064: Ldap Authentication failing with pg_hba.conf entry
Date
Msg-id CAA36N_=WFkX20AvS+xXNpDRPgi+-mWjmuXOLT1iMwiCvmgJzgA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16064: Ldap Authentication failing with pg_hba.conf entry  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
Hi all,

Here are the full details
host      all           all           10.10.117.43/32         ldap
 ldapserver=10.10.117.43 ldapbasedn="ou=People,dc=internal,dc=com"
 ldapbinddn="cn=Tom,ou=People,dc=internal,dc=com" ldapbindpasswd="Test123#"
 ldapport=389



Thanks and regards
Yudhveer Kandukuri 

On Thu, Oct 17, 2019 at 4:16 PM Jeff Janes <jeff.janes@gmail.com> wrote:
On Thu, Oct 17, 2019 at 1:59 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16064
Logged by:          Yudhveer Kandukuri
Email address:      k.yudhveer@gmail.com
PostgreSQL version: 10.10
Operating system:   Ubuntu 18.04
Description:       

Can any one please guide me what is the issue with my ldap authentication on
Postgresql 10.10. Here is the Entry for ldap in pg_hba.conf file

host      all           all           XX.XX.XXX.XX/32         ldap
ldapserver=XX.XX.XXX.XX ldapbasedn="ou=People,dc=internal,dc=com"
ldapbinddn="cn=Tom,ou=People,dc=internal,dc=com" ldapbindpasswd="Test123#"
ldapport=389

I created the same user "Tom" in the Postgres database too . Also created
the User "Tom" other user "svc-ldap" in active directory too.

When I am trying to connect to PostgreSQL server from other remote server,
the authentication is failing with

psql: FATAL:  no pg_hba.conf entry for host "XXX.XX.XXX.XXX", user "Tom",
database "Tom", SSL off



Just by counting the placeholders, we know that  XX.XX.XXX.XX cannot be the same thing as  XXX.XX.XXX.XXX.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #16064: Ldap Authentication failing with pg_hba.conf entry
Next
From: 石勇虎
Date:
Subject: checkpoint process is hang