From: | Bernd Lentes <bernd(dot)lentes(at)helmholtz-muenchen(dot)de> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | unrecognized configuration parameter "ldapbinddn" in file "/var/lib/pgsql/data/postgresql.conf" |
Date: | 2023-11-02 19:56:40 |
Message-ID: | PR3PR04MB7340275A4B83BB8BFD48F37BD6A6A@PR3PR04MB7340.eurprd04.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)lentes(at)helmholtz-munich(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2023-11-02 20:16:33 | Re: unrecognized configuration parameter "ldapbinddn" in file "/var/lib/pgsql/data/postgresql.conf" |
Previous Message | Ron | 2023-11-02 19:31:51 | Re: How to _not_ save startup options in postmaster.opts? |