Re: BUG #16064: Ldap Authentication failing with pg_hba.conf entry

On Thu, Oct 17, 2019 at 1:59 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 16064
> Logged by: Yudhveer Kandukuri
> Email address: k(dot)yudhveer(at)gmail(dot)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