Re: Pgadmin with active directory.

Hi,

On Tue, Oct 6, 2020 at 1:07 PM Le-DOC <ledoc666(at)gmail(dot)com> wrote:

> Hello,
>
> Email/Username is not valid.
> When I try username. Case sensitive is correct.
>
So, you are able to login with your LDAP username and password.
Currently, the pgAdmin LDAP implementation only allows case sensitive
username, but we do have RM (Ref: https://redmine.postgresql.org/issues/5836)
to support the case insensitive username.

>
> If I try an email: incorrect username or password.
>
Which email address are you trying ?
In case of LDAP Authentication, you can login only through valid LDAP
username.

Thanks,
Khushboo

>
> Thanks
>
>
> Le mar. 6 oct. 2020 à 06:44, Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> a écrit :
>
>> Hi,
>>
>>
>> On Mon, Oct 5, 2020 at 6:44 PM Le-DOC <ledoc666(at)gmail(dot)com> wrote:
>>
>>> Hello, I'm trying to enable ldap authentication with our active
>>> directory.
>>> I configure config_distro.py with:
>>>
>>> AUTHENTICATION_SOURCES = ['ldap', 'internal']
>>> LDAP_AUTO_CREATE_USER = True
>>> LDAP_CONNECTION_TIMEOUT = 30
>>> LDAP_SERVER_URI = 'ldap://xxxx.pam.lan:389'
>>> LDAP_USERNAME_ATTRIBUTE = 'sAMAccountName'
>>> LDAP_SEARCH_FILTER = '(&(objectClass=user)(|(memberof=CN=00 -
>>> Gestionnaires
>>> Applications,OU=Distribution,OU=_Groupes,DC=pam,DC=lan)(memberof=CN=00 -
>>> Administration
>>> Système,OU=Distribution,OU=_Groupes,DC=pam,DC=lan)(memberof=CN=Urbanisation
>>> SEI,OU=Distribution,OU=_Groupes,DC=pam,DC=lan)))'
>>> LDAP_SEARCH_SCOPE = 'SUBTREE'
>>> LDAP_BIND_USER = 'Browse(dot)PGAdmin(at)pam(dot)lan'
>>> LDAP_BIND_PASSWORD = '...'
>>>
>>> Please set LDAP_SEARCH_BASE_DN, Refer
>> https://www.pgadmin.org/docs/pgadmin4/4.26/enabling_ldap_authentication.html
>> for more information.
>>
>> Thanks,
>> Khushboo
>>
>>
>>> But still login or password invalid.
>>> I have no more error in Apache log, or pgadmin log.
>>> Do you have an idea?
>>>
>>