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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: k(dot)yudhveer(at)gmail(dot)com
Subject: BUG #16064: Ldap Authentication failing with pg_hba.conf entry
Date: 2019-10-17 17:58:50
Message-ID: 16064-9dd182cda52e2eef@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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

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

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


Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Henry 2019-10-17 19:08:58 postgres has no spinlock support on riscv rv64imafdc
Previous Message David G. Johnston 2019-10-17 14:40:29 Re: BUG #16063: Error retrieving data from the server: INTERNAL SERVER ERROR: string indices must be integers