I have an error when i have 2 ldap server configured.
To Reproduce
Steps to reproduce the behavior:
configure 2 ldap servers and then try a sync
Error
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/models/users_ldap.py", line 73, in action_populate
)._get_or_create_user(conf, login, result)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/auth_ldap/models/res_company_ldap.py", line 230, in _get_or_createuser
raise AccessDenied(("No local user found for LDAP login and not configured to create one"))
odoo.exceptions.AccessDenied: Pas d'utilisateur local trouvé pour l’identifiant LDAP et n'est pas configuré pour en créer un
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1633, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
result = func()
^^^^^^
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1660, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1864, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 237, in _dispatch
response = super()._dispatch(endpoint)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(request.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, *params_ok)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 46, in call_button
action = self._call_kw(model, method, args, kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/api.py", line 468, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/api.py", line 453, in _call_kw_multi
result = method(recs, args, kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/models/users_ldap.py", line 187, in populate_wizard
res_id = wizard_obj.create({"ldap_id": self.id}).id
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 2, in create
File "/usr/lib/python3/dist-packages/odoo/api.py", line 414, in _model_create_multi
return create(self, [arg])
^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/wizards/populate_wizard.py", line 25, in create
) = ldap.action_populate()
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/models/users_ldap.py", line 77, in action_populate
self.env.cr.execute(
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.UndefinedFunction: ERREUR: l'opérateur n'existe pas : text = bytea
LIGNE 1 : SELECT id FROM res_users WHERE lower(login)='\x62656e6f69742...
^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
Module
LDAP Populate
Describe the bug
I have an error when i have 2 ldap server configured.
To Reproduce
Steps to reproduce the behavior: configure 2 ldap servers and then try a sync
Error
Traceback (most recent call last): File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/models/users_ldap.py", line 73, in action_populate )._get_or_create_user(conf, login, result) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/auth_ldap/models/res_company_ldap.py", line 230, in _get_or_createuser raise AccessDenied(("No local user found for LDAP login and not configured to create one")) odoo.exceptions.AccessDenied: Pas d'utilisateur local trouvé pour l’identifiant LDAP et n'est pas configuré pour en créer un
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/usr/lib/python3/dist-packages/odoo/http.py", line 1633, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying result = func() ^^^^^^ File "/usr/lib/python3/dist-packages/odoo/http.py", line 1660, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/http.py", line 1864, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 237, in _dispatch response = super()._dispatch(endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 154, in _dispatch result = endpoint(request.params) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/http.py", line 697, in route_wrapper result = endpoint(self, *args, *params_ok) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 46, in call_button action = self._call_kw(model, method, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw return call_kw(request.env[model], method, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/api.py", line 468, in call_kw result = _call_kw_multi(method, model, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/api.py", line 453, in _call_kw_multi result = method(recs, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/models/users_ldap.py", line 187, in populate_wizard res_id = wizard_obj.create({"ldap_id": self.id}).id ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "", line 2, in create
File "/usr/lib/python3/dist-packages/odoo/api.py", line 414, in _model_create_multi
return create(self, [arg])
^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/wizards/populate_wizard.py", line 25, in create
) = ldap.action_populate()
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/addons/users_ldap_populate/models/users_ldap.py", line 77, in action_populate
self.env.cr.execute(
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.UndefinedFunction: ERREUR: l'opérateur n'existe pas : text = bytea
LIGNE 1 : SELECT id FROM res_users WHERE lower(login)='\x62656e6f69742...
^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
The above server error caused the following client error: RPC_ERROR: Odoo Server Error at makeErrorFromResponse (http://10.1.1.44:8069/web/assets/468-e0049f2/web.assets_backend.min.js:993:163) at XMLHttpRequest. (http://10.1.1.44:8069/web/assets/468-e0049f2/web.assets_backend.min.js:1001:13)