LDAP to Shibboleth migration

LDAP to Shibboleth migration

by Alessandro Castellano -
Number of replies: 2

Hi, I have a moodle instance with about 29000 users, all authenticated via LDAP plugin. For some reasons I need to migrate all of them to Shibboleth.

Shibboleth is already installed and working fine, so the only needed task is the migration.

LDAP usernames have following format: a###### (a followed by 6 numbers)

Shibboleth usernames format is a######@exampledomain.com.

Are the following queries all I need to finalize the migration?

UPDATE mdl_user set username=concat(username, '@exampledomain.com') WHERE auth = 'ldap';

UPDATE mdl_user SET auth = 'shibboleth' WHERE auth = 'ldap';

Do I need some other step? Is there anything else I should be aware of?

Thanks in advance for your help

Alessandro

Average of ratings: -
In reply to Alessandro Castellano

Re: LDAP to Shibboleth migration

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

I am presuming that you have tested with a single user already?  And they were able to login and update their profile as needed?

If you have done that then, I think those two queries should be fine.  Again, I would also test the query on a single user first (WHERE userid = "whatever user you pick id number")

Average of ratings: -
In reply to Emma Richardson

Re: LDAP to Shibboleth migration

by Alessandro Castellano -
Yes, I have tested with a single user, after the "update" that user found all his courses, and he was able to update the profile.

I will make some more tests, and on next september I will migrate all users if I will not get issues or troubles.
Thank you
Alessandro
Average of ratings: -