Totara Talent Experience Platform Open Discussions

LDAP Sync task error

 
Nitin Agrawal
LDAP Sync task error
by Nitin Agrawal - Tuesday, 19 July 2022, 4:07 AM
 

Hi all,

I am getting following error when executing ldap sync cron job. I had also double check by calling individual task (php admin/tool/task/cli/schedule_task.php --execute=\\auth_ldap\\task\\sync_task). During investigation I found same query posted in Moodle forum (https://moodle.org/mod/forum/discuss.php?d=353846). I have also removed tmp_extuser table and check it but getting another error. Please let me know what I am missing here.


Connecting to LDAP server...

Creating temporary table tmp_extuser

Did not get any users from LDAP -- error? -- exiting

Potential coding error - existing temptables found when disposing database. Must be dropped!


Craig Eves
Re: LDAP Sync task error
by Craig Eves (Totara Support) - Wednesday, 20 July 2022, 4:38 PM
Group Totara

Hi Nitin

From the ticket this issue was solved by enabling Search Subcontexts in the LDAP server -> User Lookup Settings.  Once this was done it was finally trying to import the users into LDAP, but then gave an unusable characters error.  this was fixed by going to Site Administration -> Security -> Site Policies and enabling Allow Extended Characters in Usernames.

If this doesn't work then are you able to create a support ticket with the version of Totara and the settings you have used for LDAP.

I had a look at reported issues for LDAP and can only find issues regarding the updating of custom fields mapped in LDAP which look to have been fixed.

Regards