Last modified: 2014-09-18 06:40:08 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T41817, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 39817 - Migrate to SUL all non-clashing accounts
Migrate to SUL all non-clashing accounts
Status: ASSIGNED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Normal enhancement with 1 vote (vote)
: ---
Assigned To: Kunal Mehta (Legoktm)
https://www.mediawiki.org/wiki/Admin_...
: shell
Depends on: 67350 54760 61876 69291 70392
Blocks: sulfinalization
  Show dependency treegraph
 
Reported: 2012-08-30 23:25 UTC by Nemo
Modified: 2014-09-18 06:40 UTC (History)
18 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Nemo 2012-08-30 23:25:38 UTC
We've discussed a lot of times how to complete SUL migration but maybe we can do it by steps: four years later, I still have to tell users to merge their accounts even in trivial cases.
I think it should be too hard to unify all accounts which:
1) can be merged without user interaction (same username and email or password, right?),
2) would not leave any unattached account around.

The only drawback I can imagine right now is the very remote case that a user, even if there are no name conflicts, uses two or more local usernames on different wikis and could be automatically logged in with the wrong username. Nothing really bad would happen anyway.

Filing under CentralAuth because I suppose this require a script or so to be written first?
Comment 1 Nemo 2013-03-12 11:01:53 UTC
There are at over 10 millions usernames currently existing on a single wiki only (that could be easily unified), it seems. <https://www.mediawiki.org/w/index.php?title=Admin_tools_development/SUL_Audit&oldid=653987>
Comment 2 Nemo 2013-04-13 15:45:55 UTC
First pass for this is being done in these days by pgehres, while keeping an eye on database overload, about 1.4 millions in two days so far with migrateAccount.php --safe (usernames without global account and only a single local account).

<https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/CentralAuth.git;a=blob;f=maintenance/migrateAccount.php;h=5b82781667d37cebae788d482c660cbf62bce674;hb=HEAD>
Comment 3 MZMcBride 2013-09-29 21:40:11 UTC
James F.: should this bug continue to be assigned to you? Perhaps Dan G. should be assigned instead?
Comment 4 James Forrester 2014-03-01 03:03:59 UTC
(In reply to MZMcBride from comment #3)
> James F.: should this bug continue to be assigned to you? Perhaps Dan G.
> should be assigned instead?

{{done}}
Comment 5 Kunal Mehta (Legoktm) 2014-07-01 04:09:32 UTC
Note to self, query to get users who only exist on one wiki and don't have a global account: 

SELECT ln_name FROM localnames LEFT JOIN globaluser ON gu_name=ln_name WHERE gu_id IS NULL GROUP BY ln_name HAVING count(ln_name)=1 LIMIT 10;
Comment 6 Kunal Mehta (Legoktm) 2014-07-01 04:25:25 UTC
Nemo: Is there a reason bug 54760 should be a blocker to this? Since these user's usernames won't be changing, I don't see a reason to email them?
Comment 7 Nemo 2014-07-01 05:30:16 UTC
(In reply to Kunal Mehta (Legoktm) from comment #6)
> Nemo: Is there a reason bug 54760 should be a blocker to this? Since these
> user's usernames won't be changing, I don't see a reason to email them?

Unattached accounts having the same name as a global account are definitely affected and some portion of them need to be merged to said global account, even if they had no email set and were not merged automatically (often users forget to set/confirm/update email on some wikis). Bug 54760 is meant to catch those easy cases to avoid having to merge 110k global users manually, which would not be amusing for stewards.
Comment 8 Kunal Mehta (Legoktm) 2014-07-01 09:06:12 UTC
Ok, that makes sense. So the simplest case of this is users who only exist on one wiki, and are not attached (the query in comment 5). We should be able to migrating those without sending out emails.
Comment 9 Nemo 2014-07-01 09:27:17 UTC
(In reply to Kunal Mehta (Legoktm) from comment #8)
> Ok, that makes sense. So the simplest case of this is users who only exist
> on one wiki, and are not attached (the query in comment 5). We should be
> able to migrating those without sending out emails.

Sure, that should be done first. It was already done a first time in April 2013 (about 16 millions global accounts created IIRC).
Comment 10 Kunal Mehta (Legoktm) 2014-07-01 09:43:13 UTC
I ran the query in comment 5, and came up with 10596 users across all wikis. The result set is at /home/legoktm/one_account_no_sul.tsv on terbium.
Comment 11 Nemo 2014-07-05 08:47:49 UTC
(In reply to Kunal Mehta (Legoktm) from comment #10)
> I ran the query in comment 5, and came up with 10596 users across all wikis.
> The result set is at /home/legoktm/one_account_no_sul.tsv on terbium.

Hm. migrateAccount.php --safe should take care of those, shouldn't it? Can you run it now?
Comment 12 Kunal Mehta (Legoktm) 2014-07-05 09:20:20 UTC
(In reply to Nemo from comment #11)
> (In reply to Kunal Mehta (Legoktm) from comment #10)
> > I ran the query in comment 5, and came up with 10596 users across all wikis.
> > The result set is at /home/legoktm/one_account_no_sul.tsv on terbium.
> 
> Hm. migrateAccount.php --safe should take care of those, shouldn't it? Can
> you run it now?

Yup, you still need a list of users to migrate though. I'm planning to run the script on Tuesday.
Comment 13 Kunal Mehta (Legoktm) 2014-07-08 20:26:07 UTC
(In reply to Kunal Mehta (Legoktm) from comment #12)

> Yup, you still need a list of users to migrate though. I'm planning to run
> the script on Tuesday.

Attached a bunch of accounts today. There were also a lot of entries in localnames where the user just didn't exist, due to bug 67350.
Comment 14 Nemo 2014-09-18 06:40:08 UTC
Bryan, Reedy and others: who is able to run maintenance scripts as needed for this bug, in the coming weeks/months? Legoktm is currently busy with the coding side of things.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links