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

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(dot)janes(at)gmail(dot)com> wrote:

> 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
>