Moodle module integration

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

Thanks

@leofreitas any help?

Thanks

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.

Ross

I do to see any of the (gibbon) user accounts in Moodle yet :confused:
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.

Ross

Hi Tieku, according to this Moodle documentation:

“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. Thanks

Hi Tieku, according to this Moodle documentation:

“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.

I am prepared to grant access to my test sites.

Thanks

Tieku

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!

What password is used seeing the Password field is empty?

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!