Last modified: 2014-01-03 15:55:43 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-107. Summary: How many users have their logins unified? Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Paolo Massa <massa@fbk.eu> Date: Mon, 11 Oct 2010 13:08:15 ------------------------------------------------------------------------------- I would like to know how many users unified their logins, i.e. they can login in all wikipedias using the same login and password, see http://meta.wikimedia.org/wiki/Help:Unified_login Unfortunately I don't know which db tables are involved. It should be something about local and global accounts. I know that there is a tool that shows all the "Users with name Example on Wikimedia projects". I tried with my nickname (phauly) at http://toolserver.org/~vvv/sulutil.php?user=phauly Below there are the first lines of output of http://toolserver.org/~vvv/sulutil.php?user=phauly {{{ SUL account status Username: Phauly User ID: 546004 User registration: 13:03, 09 October 2008 Home wiki: enwiki Locked: no Hidden: no SUL admin (secure) • Contributions Database ↓ Project ↓ Editcount ↓ Registration date ↓ Flags ↓ Blocked ↓ SUL status ↓ angwiki (c) wikipedia 0 2010021809295409:29, 18 February 2010 0 No autocreated barwiki (c) wikipedia 0 2010022613112513:11, 26 February 2010 0 No autocreated cowiki (c) wikipedia 0 2009070618005718:00, 06 July 2009 0 No autocreated commonswiki (c) commons 0 2009051817232917:23, 18 May 2009 0 No autocreated Home wiki: enwiki_p Total editcount: 466 }}} I used the Unified login feature months ago. You can see that while en.wiki is my homewiki, I have an account in most of the wikipedias. The account at Spanish Wiki es.wiki is not controlled by me, there is a conflict and in fact it says "unattached". Most of the others are "autocreated". Is there a way to know how many users have used this Unified Login feature. My final goal is to analyze contributions of the same person in different wikipedias, so I need a way to know for sure that "Example" in en.wikipedia is the same physical person as "Example" in zh.wikipedia. Thanks a lot for any hint! Thanks!
------------------------------------------------------------------------------- From: Mr.Z-man <mrzmanwikimail@gmail.com> Date: Sun, 31 Oct 2010 18:57:17 ------------------------------------------------------------------------------- The globaluser table in the centralauth database contains all global accounts. mysql> SELECT COUNT(*) FROM globaluser; +----------+ | COUNT(*) | +----------+ | 8259190 | +----------+ 1 row in set (2 min 36.09 sec) https://wiki.toolserver.org/view/Database_schema/Global#Globaluser_table
------------------------------------------------------------------------------- From: Paolo Massa <massa@fbk.eu> Date: Tue, 02 Nov 2010 10:42:03 ------------------------------------------------------------------------------- Thanks a lot Mr.Z-man!!! I have a doubt, I checked at http://en.wikipedia.org/wiki/Special:Statistics and currently there are 13,331,812 users in en.wikipedia (which is the one with most registered users, I guess). The doubt is the following. Is it possible that ~8 millions out of ~13 millions users opted in for unified login? I believe this is not the case. So maybe the reason for 8259190 users in Globaluser_table is that users end up there automatically (since a certain date, possibly)? Probably the fields of Globaluser_table (such as gu_registration, gu_registration and gu_home_db for example) and localuser_table (such as lu_name and lu_attached_timestamp) are useful. May I ask you to run a query to get some records from these tables to get a better idea of what they are used for? You can use my account "Phauly" for posting results of queries. I checked at https://wiki.toolserver.org/view/Database_schema (and also the diagram at https://wiki.toolserver.org/view/Media:Mediawiki-database-schema.png ) but there is no mention I could find of these global tables.
------------------------------------------------------------------------------- From: Paolo Massa <massa@fbk.eu> Date: Tue, 02 Nov 2010 10:43:10 ------------------------------------------------------------------------------- The previous comment explains the additional info I might benefit from. Thanks!
------------------------------------------------------------------------------- From: Paolo Massa <massa@fbk.eu> Date: Tue, 02 Nov 2010 10:53:06 ------------------------------------------------------------------------------- The code of the script at http://toolserver.org/~vvv/sulutil.php might give an idea of the tables involved and their values. I also found some mentions of the values involved at http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/CentralAuth/evil-plans.txt?view=markup but this is not very clear to me. The old CentralAuth plugin (see http://www.marefa.org/extensions/CentralAuth/central-auth.sql ) had a gu_enabled_method field with enum('opt-in', 'batch', 'auto', 'admin') but I don't find this field in the current tables. Anyone can help? Thanks!!!
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: