Can I get some help looking at Moodle module integration to sync user accounts and courses. I have run the
External database → Test settings
I get:
Test authentication settings - External database
(mysqli): SET NAMES ‘utf8’
(mysqli): SELECT * FROM moodleUser WHERE username <> ‘random_unlikely_username’
×External table contains the following columns:
username, preferredName, surname, email, website
Test enrol settings - External database
(mysqli): SET NAMES ‘utf8’
(mysqli): SELECT * FROM moodleEnrolment
×External enrolment table contains following columns:
gibbonCourseID, name, username, role
(mysqli): SELECT * FROM moodleCourse
×External course table contains following columns:
gibbonCourseID, gibbonSchoolYearID, gibbonDepartmentID, name, nameShort, description, map, gibbonYearGroupIDList, orderBy
So looks like it’s set up correctly. However I can’t login to Moodle with my gibbon site user accounts. Need help. Thanks
Moodle has it’s own password, so after the sync you’ll need to use Moodle’s password recovery functionality in order to reset and learn the password. Hopefully this helps, if not, let us know.
I do to see any of the (gibbon) user accounts in Moodle yet
Are the user accounts created in Moodle the first time (gibbon) user logs in to Moodle?
Or are the user accounts pushed/synced to Moodle?
This is not single sign-on? (same/synced username + password?)
Hi Tieku,
Moodle has it’s own password, so after the sync you’ll need to use Moodle’s password recovery functionality in order to reset and learn the password. Hopefully this helps, if not, let us know.
“External database enrolment happens at the moment when a user logs into Moodle. The plugin will attempt to automatically enrol the student in all their courses according to the data in the external database and, optionally, create empty courses where they do not already exist. To check if it is working, you can log in as a student and then check that their list of courses is as you would expect.”
Sorry I meant to say User accounts are NOT being created in Moodle when I attempt a login with my Gibbon account usernames (despite the fact that the external database tests appear to show a successful connection to the gibbon site). Using Moodle 3.91 and Gibbon v20. Thanks
“External database enrolment happens at the moment when a user logs into Moodle. The plugin will attempt to automatically enrol the student in all their courses according to the data in the external database and, optionally, create empty courses where they do not already exist. To check if it is working, you can log in as a student and then check that their list of courses is as you would expect.”
Hopefully this works as expected. Let us know!
Ross
Sorry I meant to say User accounts are NOT being created in Moodle when I attempt a login with my Gibbon account usernames (despite the fact that the external database tests appear to show a successful connection to the gibbon site). Using Moodle 3.91 and Gibbon v20.
Hi Tieku, OK, that is interesting. Are you able to check PHP and MySQL error logs on both servers (Moodle and Gibbon) right after you sync, to see if they are throwing up anything useful? Thanks!
I finally got the Gibbon users created in/synced to Moodle by going to:
Site administration/Server/Tasks/Scheduled tasks, enabling, and running manually.
Do I then need to set passwords manually?
Hi Tieku, OK, that is interesting. Are you able to check PHP and MySQL error logs on both servers (Moodle and Gibbon) right after you sync, to see if they are throwing up anything useful? Thanks!
