Update on Moodle/GApps SSO

For some reason, since I got SSO up and running a while back, an annoying problem hit; new users were not syncing over to Google, so Google was throwing up a SAML Invalid e-mail error, Please try again later.

Fortunately, it’s an easy fix (I can say that now, having spent ages trying to diagnose) – go to your LDAP authentication settings in Moodle, and, under the Bind section, turn Hide Password to No.

Then, delete all the users from mdl_block_gdata_gapps in your moodle’s database that have status = ‘accountcreationerror’ – connect to the moodle sql database – on my system it’s called moodle, then type:

mysql> delete from mdl_block_gdata_gapps where status = ‘accountcreationerror’;

NOTE: this doesn’t delete your users from Moodle, just from the gapps synchronisation database. But, if you’re not confident about it, don’t do it, and the usual disclaimer (if anything goes wrong, don’t shoot the messenger) applies.

Then, get your broken users to login to Moodle afresh. They should sync over just fine.

Advertisement