-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jim Hu wrote:
So... I decided to try it, and it seems like it doesn't work, at least on my system. I get the usernames, but the passwords are shot. I suspect that this is because I'm going from a G5 Mac to an Intel Mac, and there is a difference in bit order, which trashes the blobs.
This shouldn't make a difference.
The thing you should be aware of, though, is that the default password hashing includes a salt of the user_id. This means that if you change the account to have a different user_id, the old user_password field will have the 'wrong' value in it, and the password won't match when you try to log in.
So, you may have to do some resetting of passwords for affected accounts if you're doing a manual merge like this.
- -- brion vibber (brion @ wikimedia.org)
Any thoughts on how to migrate users without having to ask them to all reset their passwords. I suppose that not being able to do this is a good thing, in terms of security.
JH
On Jul 16, 2007, at 10:21 PM, Jim Hu wrote:
I think this has been asked before but I can't seem to find the answer. I have a bunch of wikis on two different servers. I want users of wiki A to get the same usernames, passwords, etc on wiki B, in addition to having users who are only on wiki B. Can I just do an sql dump from the user table of wiki A and import the data into the user table of wiki B? I mean, I know I can do it, but will it have the desired effect?
Jim
===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l