Hi,
i'm trying to use LDAP to authenticate Postgres against a Windows AD. On elder versions it succeeded.
Now I'm running postgresql-15-150500.8.19.noarch on a SLES 15 SP5 system.
I can't start the db server because it doesn't know the respective configuration parameters:
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] LOG: unrecognized configuration
parameter"ldapbinddn" in file "/var/lib/pgsql/data/postgresql.conf" line 106
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] LOG: unrecognized configuration
parameter"ldapserver" in file "/var/lib/pgsql/data/postgresql.conf" line 108
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] LOG: unrecognized configuration
parameter"ldapport" in file "/var/lib/pgsql/data/postgresql.conf" line 110
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] LOG: unrecognized configuration
parameter"ldaptls" in file "/var/lib/pgsql/data/postgresql.conf" line 112
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] LOG: unrecognized configuration
parameter"ldapbasedn" in file "/var/lib/pgsql/data/postgresql.conf" line 114
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] LOG: unrecognized configuration
parameter"ldapbindpasswd" in file "/var/lib/pgsql/data/postgresql.conf" line 116
Nov 02 20:42:15 geneious postgresql-script[15577]: 2023-11-02 19:42:15.387 GMT [15577] FATAL: configuration file
"/var/lib/pgsql/data/postgresql.conf"contains errors
Nov 02 20:42:15 geneious postgresql-script[15575]: pg_ctl: could not start server
Nov 02 20:42:15 geneious postgresql-script[15575]: Examine the log output.
Nov 02 20:42:15 geneious systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE
Here is my setup from postgresql.conf:
ldapbinddn = 'xxxxxxxxxxx'
ldapserver = ldaps.scidom.de
ldapport = 636
ldaptls = 1
ldapbasedn = 'xxxxxxxxx'
ldapbindpasswd = 'xxxxxxxxxxxxxxxxx'
I took the parameters from the doc from the official webpage.
Do I need to switch on LDAP in a certain way ?
Thanks for any idea.
Bernd
Bernd Lentes
--
Bernd Lentes
System Administrator
MCD
Helmholtzzentrum München
+49 89 3187 1241
bernd.lentes@helmholtz-munich.de
https://www.helmholtz-munich.de/en/mcd
Helmholtz Zentrum München – Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstraße 1, D-85764 Neuherberg, https://www.helmholtz-munich.de
Geschäftsführung: Prof. Dr. med. Dr. h.c. Matthias Tschöp | Aufsichtsratsvorsitzende: MinDir’in Prof. Dr. Veronika von
Messling
Registergericht: Amtsgericht München HRB 6466 | USt-IdNr. DE 129521671