PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16399
PG Version10.12
OSWindows Server 2012
Opened2020-04-28 23:09:20+00
Reported byCiaran
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16399
Logged by:          Ciaran
Email address:      (redacted)
PostgreSQL version: 10.12
Operating system:   Windows Server 2012
Description:        

Hello,

Follow the documentation here:
https://www.postgresql.org/docs/10/auth-methods.html#AUTH-LDAP I'm
attempting to enable LDAP authentication on my postgres database. 

The relevant line for my testing this in my pg_hba.conf file is as
follows:
host 	all 		ciaranh 	0.0.0.0/0 		ldap
ldapurl="ldap://<DC>/OU=IT,DC=CNFLTD,DC=COM?sAMAccountName?one"
#ldapbinddn="CN=Postgres Bind, OU=Service Accounts, DC=CNFLTD, DC=COM"
ldapbindpasswd="cnfP@ssw0rd"

I receive the following error when trying to start the postgres service:
2020-04-28 16:00:02.619 PDT [4704] LOG:  authentication method "ldap"
requires argument "ldapserver" to be set
2020-04-28 16:00:02.619 PDT [4704] CONTEXT:  line 79 of configuration file
"C:/Program Files/PostgreSQL/10/data/pg_hba.conf"
2020-04-28 16:00:02.619 PDT [4704] FATAL:  could not load pg_hba.conf

I do not understand why the ldapserver need be set if it's specified in the
ldapurl field, this seems like a bug to me.

Messages

DateAuthorSubject
2020-04-28 23:09:20+00PG Bug reporting formBUG #16399: Ldap authentication bug
2020-04-29 02:26:48+00Thomas MunroRe: BUG #16399: Ldap authentication bug