I have Moodle setup to use my organisations Active Directory for authentication, and it works great.
Users can login with their credentials, Moodle creates an account for them, and away they go.
The trouble is, users can't be added to their classes until their accounts have been created - after they login.
The answer seems to be the LDAP Sync Task - this should slurp every account that exists on AD and put them on Moodle.
When I run the command:
php moodle/admin/tool/task/cli/schedule_task.php --execute\\auth_ldap\\task\\sync_task
I get a screen full of dots as it's working away, and then I get this error:
...... used 199013 dbqueries ... used 223.62434101105 seconds
Shecduled task failed: LDAP user sync job (auth_ldap\task\sync_task), Error writing to database
Potential coding error - existing temptables found when disposing database. Must be dropped!
The database user has full permissions granted.
The server is:
- Moodle 3.0.2
- PHP 5.4.16
- MariaDB 5.5.44
- CentOS 7
Any clues appreciated.