Postgres Pro
Downloads
Home   >   mailing lists

Re: askin for LDAP configuration - Mailing list pgadmin-support

From Khushboo Vashi
Subject Re: askin for LDAP configuration
Date
Msg-id CAFOhELcD2F--hxMWLC21Yf96EZFpoEuQ7t3=zX84K4nwnPT8Zw@mail.gmail.com
Whole thread Raw
In response to askin for LDAP configuration  (Salih Zengin <salih.zengin@sellics.com>)
List pgadmin-support
Tree view
Hi,

Please provide the sample ldapsearch command which you use to connect the ldap server.

Also, go through the documentation (https://www.pgadmin.org/docs/pgadmin4/4.29/enabling_ldap_authentication.html) which provides the details of all the necessary parameters to be set.

Thanks,
Khushboo

On Fri, Jan 8, 2021 at 3:19 PM Salih Zengin <salih.zengin@sellics.com> wrote:
Hi guys,

I am trying to setup our Azure ADDS LDAP with pgadmin.
I have two problems where I cant find a good solution.
          - name: PGADMIN_CONFIG_LDAP_USERNAME_ATTRIBUTE
            value: "'cn'"
This is only working for cn for me. userPrincipalName, mail or
sAMAccountName as attribute are not working, idk why. We have some
users with special character in their cn, and also in general this
should be classic the account name.

I want to limited the user access. When I use this, it is also not working:
          - name: PGADMIN_CONFIG_LDAP_BASE_DN
            value:
"'(&(objectClass=user)(|(memberof=CN=ldap_PGadmin,OU=AADDC
Users,DC=xxxyyy,DC=com)))'"
 
To limit the user's access, you can use the LDAP_SEARCH_FILTER  config parameter. You can find the details in the documentation.

Of course the general BASE_DN works and find my cn user
          - name: PGADMIN_CONFIG_LDAP_BASE_DN
            value: "'OU=AADDC Users,DC=xxxyyy,DC=com'"

Does anyone have a hint / advice for this?

Thanks in advance.
salih


pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: Create server in pgAdmin
Next
From: "Karsten Lenz (KLE)"
Date:
Subject: AD Authentication PgAdmin Web