We have upgraded an 1.8 installation to a 1.9.7 installation.
After this we noticed that the MnetHostID values were changed in the user table.
Previously the value here was 1 but this has been changed into 3.
We have looked for a explanation but did not find any. can some explain why and how this can happen?
We upgraded from 1.9.3+ to 1.9.7+ and the mnethostid changed from 1 to 3, both changing this value for all users in the mdl_user table and also the mnet_localhost_id value in the mdl_config table.
We import our own users into the mdl_user table and use a custom auth plugin to an external system. Any new users were created with the old mnet value of 1 and as a result the auth plugin worked, but they were then asked to provide all their profile details which created a new record in the mdl_user table with an mnet value of 3.
- Deleted all the duplicate mdl_user records with the correct mnet of 3.
- Updated the mnet value for the valid mdl_user records.
- Changed our user import procedure to user mnet 3 as the default from now on.
Hope this helps the next person... Hope I haven't broken our system.
Have you noticed any fallout from your efforts? We're in a similar situation after testing the 1.9.8 upgrade.
We've just come across this issue after upgrading last week from 1.9.4 to 1.9.8.
This made users created after the upgrade to appear as remote users.
I've changed the default in the row inserts to 3.
Hope this is no additional fallout from this issue, but will stay tuned.