MNethostID changed after upgrade

MNethostID changed after upgrade

av Wim Van Borm -
Antall svar: 6

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?

thanks.

Gjennomsnittlig vurdering: -
Som svar til Wim Van Borm

Re: MNethostID changed after upgrade

av Penny Leach -
Hi, I think maybe it was related to the fix for this bug:

http://tracker.moodle.org/browse/MDL-16879

Are you having a problem because of this, or was it just something weird you noticed?
Som svar til Wim Van Borm

Re: MNethostID changed after upgrade

av Dennis Chew -
Just got to the bottom of this with our Moodle install.

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.

To fix:
- 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.
Gjennomsnittlig vurdering:Useful (2)
Som svar til Dennis Chew

Re: MNethostID changed after upgrade

av Erik Hoover -
Steven-

Have you noticed any fallout from your efforts? We're in a similar situation after testing the 1.9.8 upgrade.

Thanks,
-Erik
Som svar til Wim Van Borm

Re: MNethostID changed after upgrade

av Owen Grubbs -

We've just come across this issue after upgrading last week from 1.9.4 to 1.9.8.

We use Windows server and LDAP authentication, and have a special process that creates mdh_user row inserts that defaulted the mnethostid to 1.

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.