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
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.
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
-----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
Ah! Thanks. I had removed the user_id in the import. I'll try it again. This could be very very helpful!
Jim On Jul 18, 2007, at 12:32 PM, Brion Vibber wrote:
-----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
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGnk6UwRnhpk1wk44RAsL1AJwMOAlmyPIC3CEGbJ6H9QRhQOHU4ACdGGFJ EuD08vZubvo5hmPYy0fjb6A= =aJig -----END PGP SIGNATURE-----
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@lists.wikimedia.org