ContextQMD
Back to Lldap

Configuration for pgAdmin

example_configs/pgadmin.md

0.6.31.5 KB
Original Source

Configuration for pgAdmin

The configuration for pgAdmin is done in the config_local.py. Refer to the pgAdmin documentation for guidance on its config file. The Enabling LDAP Authentication describes all available variables related to enabling LDAP authentication for pgAdmin.

[!NOTE] The configuration can also be done through pgAdmin's PGADMIN_CONFIG_* environnement variables when run in Docker.

Add and adapt the following in your config_local.py where:

  • dc=example,dc=com is your LLDAP configured domain.
  • ldap://lldap:3890 is your ldap://HOSTNAME-OR-IP:PORT of your LLDAP server.
  • bind_user and REPLACE_ME are your user uid and password of the bind user for pgAdmin.
  • pgadmin_users is the group of the users you want to give access to pgAdmin.
python
AUTHENTICATION_SOURCES = ["ldap"]
LDAP_AUTO_CREATE_USER = True
LDAP_SERVER_URI = "ldap://lldap:3890"
LDAP_USERNAME_ATTRIBUTE = "uid"
LDAP_BASE_DN = "ou=people,dc=example,dc=com"
LDAP_SEARCH_BASE_DN = "ou=people,dc=example,dc=com"
LDAP_BIND_USER = "uid=bind_user,ou=people,dc=example,dc=com"
LDAP_BIND_PASSWORD = "REPLACE_ME"
LDAP_SEARCH_FILTER = "(memberof=cn=pgadmin_users,ou=groups,dc=example,dc=com)"