AnsweredAssumed Answered

Single user unable to authenticate with LDAP

Question asked by infra on Jun 11, 2019
Latest reply on Jun 12, 2019 by Francesca Shiekh

Hi!

 

I got quite a mystery on my hands. I've setup SugarCRM for 50 users, where 49 of them can authenticate with LDAP...

I got one user that simply is unable to login with ldap.

 

[DEBUG] LDAP: querying with DN=dc=ad3,dc=company,dc=no and query=(sAMAccountName=username@company.no)
[DEBUG] LDAP: binding with DN=username@company.no
[INFO] Query: SELECT users.id FROM users WHERE (users.user_name = ?) AND (users.deleted = ?) LIMIT 1 OFFSET 0\nParams: {"1":"username@company.no","2":0}\nTypes: {"1":2,"2":5}
[DEBUG] Hook called: Users::before_retrieve
[DEBUG] SugarBean[User].load_relationships, Loading link (team_link).
[DEBUG] VardefManager::loadVardef called for module: Teams
[ERROR] Warning: Multiple links found for relationship users_team within module Users
[ERROR] Unable to determine best appropriate link for relationship users_team
[DEBUG] VardefManager::loadVardef called for module: Teams
[DEBUG] Retrieve User
[INFO] Query: SELECT users.id, users.user_name, users.user_hash, users.system_generated_password, users.pwd_last_changed, users.authenticate_id, users.sugar_login, users.picture, users.first_name, users.last_name, users.is_admin, users.external_auth_only, users.receive_notifications, users.description, users.date_entered, users.date_modified, users.last_login, users.modified_user_id, users.created_by, users.title, users.department, users.phone_home, users.phone_mobile, users.phone_work, users.phone_other, users.phone_fax, users.status, users.address_street, users.address_city, users.address_state, users.address_country, users.address_postalcode, users.default_team, users.team_set_id, users.acl_team_set_id, users.deleted, users.portal_only, users.show_on_employees, users.employee_status, users.messenger_id, users.messenger_type, users.reports_to_id, users.is_group, users.preferred_language, users.acl_role_set_id, teams_tn.name tn_name, teams_tn.name_2 tn_name_2 FROM users LEFT JOIN teams teams_tn ON (users.default_team = teams_tn.id) AND (teams_tn.deleted = ?) WHERE users.id = ? LIMIT 1\nParams: {"1":0,"2":""}\nTypes: {"1":5,"2":2}
[INFO] Query: SELECT users.id FROM users WHERE (users.user_name = ?) AND (users.deleted = ?) LIMIT 1 OFFSET 0\nParams: {"1":"username@company.no","2":0}\nTypes: {"1":2,"2":5}
[DEBUG] Hook called: Users::before_retrieve
[DEBUG] SugarBean[User].load_relationships, Loading link (team_link).
[ERROR] Warning: Multiple links found for relationship users_team within module Users
[ERROR] Unable to determine best appropriate link for relationship users_team
[DEBUG] Retrieve User
[INFO] Query: SELECT users.id, users.user_name, users.user_hash, users.system_generated_password, users.pwd_last_changed, users.authenticate_id, users.sugar_login, users.picture, users.first_name, users.last_name, users.is_admin, users.external_auth_only, users.receive_notifications, users.description, users.date_entered, users.date_modified, users.last_login, users.modified_user_id, users.created_by, users.title, users.department, users.phone_home, users.phone_mobile, users.phone_work, users.phone_other, users.phone_fax, users.status, users.address_street, users.address_city, users.address_state, users.address_country, users.address_postalcode, users.default_team, users.team_set_id, users.acl_team_set_id, users.deleted, users.portal_only, users.show_on_employees, users.employee_status, users.messenger_id, users.messenger_type, users.reports_to_id, users.is_group, users.preferred_language, users.acl_role_set_id, teams_tn.name tn_name, teams_tn.name_2 tn_name_2 FROM users LEFT JOIN teams teams_tn ON (users.default_team = teams_tn.id) AND (teams_tn.deleted = ?) WHERE users.id = ? LIMIT 1\nParams: {"1":0,"2":""}\nTypes: {"1":5,"2":2}
[ERROR] User was not found by provided name

What does the last logline mean here? The same ldap configuration works for all my other services and the user in question logs in just fine with the rest of my 50 users

Outcomes