Odoo Help


LDAP correct syntax for ldap-filter

on 4/3/13, 2:25 AM 13,295 views


I installed the LDAP module, and configured it as follow :

LDAP filter : uid=%s

Question : What are the variable used by openerp for LDAP filter (%uid, %mail, %s...etc) ?

Moreover, I'd like something like this :

LDAP filter : (&(uid=%s)(memberOf=cn=share,ou=Groups,dc=ip-198-27-46,dc=net))

Finally, I'd also like to have Openerp-ldap-module retrieve my users emails as well as their username...is it possible ?

Thank you.

Vianney Adou
On 7/28/15, 1:47 PM

It is possible you retrieve your users emails as well as their username.

Do it :

Modify the source code of auth_ldap module.

open users_ldap.py go to map_ldap_attributes methode.

replace this code :

values = { 'name': ldap_entry[1]['cn'][0],

'login': login,

'company_id': conf['company'],


by this:


values = { 'name': ldap_entry[1]['cn'][0],

'login': login,

'company_id': conf['company'],

'email': ldap_entry[1]['mail'][0],



values = { 'name': ldap_entry[1]['cn'][0],

'login': login,

'company_id': conf['company'],


best regards.

Voathnak Lim
On 4/24/15, 2:20 AM

Hello sulliwan, I just got the same issue here. have you got success can you share your experience. thanks

On 4/3/13, 7:28 AM

Your filter depends on the LDAP server and what you want as username. With an LDAP browser (search on internet) you can see and check what your LDAP filter and LDAP base should be set to. For example I have "sAMAccountName=%s" as filter and "OU=SBSUsers,OU=Users,OU=MyBusiness,DC=DOMAIN,DC=local" as base. LDAP is on a SBS2011 server. Users can log on to OpenERP with their own username & password.

I use the exact same filter on owncloud ldap-module, and it works great against my ldap server : (&(uid=%s)(memberOf=cn=share,ou=Groups,dc=ip-198-27-46,dc=net)). If changing the ldap base to cn=share,ou=Groups,dc=ip-198-27-46,dc=net, the authentication stop working...thx for your anwser

on 4/3/13, 7:36 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/3/13, 2:25 AM
Seen: 13295 times
Last updated: 7/28/15, 2:44 PM