I am trying to sync users (primarily) and courses between gibbon and moodle, gibbon being the source. I have configured the external database and the connection seems to be working. I am having trouble syncing the users though.
This is a log from the server sync tool in moodle;
“Execute scheduled task: Synchronise users task (auth_db\task\sync_users)
… started 06:40:01. Current memory use 26.9 MB.
User entries to add: 3
Error inserting user Kiyingi - user with this username was already created through ‘manual’ plugin.
Error inserting user lMoodle
Error inserting user tMoodle
… used 7 dbqueries
… used 0.0059928894042969 seconds
Scheduled task complete: Synchronise users task (auth_db\task\sync_users)”
I understand the error with the first user but not the other two. What could be keeping the users from syncing? Any help?
I figured out what the problem was. My usernames in Gibbon had uppercase letters which are not accepted in Moodle. Users are now successfully being added to moodle though they receive a new password, which kinda defeats the single sign on goal I had.
To make this work I had to use internal password management because Moodle does not support sha256 which gibbon appears to be based on. Is there a work around for this? It’s the only piece missing for full SSO I think.
Hi @elkiyingi Thanks for sharing your solution, which could certainly help other users who encounter the same problem.
It sounds like Moodle may have changed their password handling, as I believe they supported sha2 in the past. Gibbon supports Google and/or Microsoft SSO as well, if this helps, these can be found in System Admin > Third Party Settings.