Page MenuHomePhabricator

Removal of admin, bureaucrats, ... from closed wiki ukwikimedia
Closed, ResolvedPublic

Description

This wiki has been closed since its contents were shifted to an external host. Unlike other closed wikis the admins and crats were not removed, and it is desirable that the rights are removed for these rightsholders.


Version: wmf-deployment
Severity: normal

Details

Reference
bz68737

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:27 AM
bzimport set Reference to bz68737.
bzimport added a subscriber: Unknown Object (MLST).

Oh, the discussion and request from WMUK can be found at [[m:Special:PermanentLink/9331985]]

This is a steward thing, not an actual site request.

For other closed wikis it has been undertaken as part of the closure of the wiki, not separately. Plus as the discussion states, there is a longer list, and without ready reference to double check, it seemed more authoritative to do this as a data management issue.

hmm, or not removed systematically.

As this wiki isn't even accessible we decided it would be easier to remove all right holders server side.

mysql> DELETE FROM user_groups;
Query OK, 64 rows affected (0.00 sec)

Just as a reference: Those were removed:

MariaDB [ukwikimedia_p]> SELECT user_name FROM user INNER JOIN user_groups ON ug_user = user_id WHERE ug_group = 'sysop';
+----------------------------------+

user_name

+----------------------------------+

Mike Peel
Cfp
Tango
Seddon
AndrewRT
KTC
Steve virgin
LondonStatto
WereSpielChequers
RexxS
MichaelMaggs
Charles Matthews
Victuallers
Andrew Gray
Rock drum
MartinPoulter
The Land
Johnbod
ErrantX
Chase me ladies, I'm the Cavalry
Panyd
Pigsonthewing
HJ Mitchell
Jon Davies (WMUK)
Yaris678
Richard Symonds (WMUK)
Harry Wood
Daria Cybulska (WMUK)
Stevie Benton (WMUK)
Llywelyn2000
Katherine Bavage (WMUK)
Rhyswynne
Kelson
Richard Nevell (WMUK)
Deskana
Katie Chan (WMUK)
Toni Sant (WMUK)
Jonathan Cardy (WMUK)
Alastair McCapra
Robin Owain (WMUK)
MartinPoulter Jisc

+----------------------------------+
42 rows in set (0.01 sec)

MariaDB [ukwikimedia_p]> SELECT user_name FROM user INNER JOIN user_groups ON ug_user = user_id WHERE ug_group = 'bureaucrat';
+----------------------------------+

user_name

+----------------------------------+

MichaelMaggs
The Land
ErrantX
Chase me ladies, I'm the Cavalry
Jon Davies (WMUK)
Richard Symonds (WMUK)
Daria Cybulska (WMUK)
Stevie Benton (WMUK)
Katherine Bavage (WMUK)
Jon Davies WMUK
Kelson
Richard Nevell (WMUK)
Katie Chan (WMUK)
Toni Sant (WMUK)
Jonathan Cardy (WMUK)
Alastair McCapra
Robin Owain (WMUK)

+----------------------------------+
17 rows in set (0.00 sec)

MariaDB [ukwikimedia_p]> SELECT user_name FROM user INNER JOIN user_groups ON ug_user = user_id WHERE ug_group = 'bot';
+----------------------------+

user_name

+----------------------------+

Thehelpfulbot
LcawteBot
WMUK Wiki Migration Team
MediaWiki message delivery

+----------------------------+
4 rows in set (0.00 sec)

MariaDB [ukwikimedia_p]> SELECT user_name FROM user INNER JOIN user_groups ON ug_user = user_id WHERE ug_group = 'ipblock-exempt';
+--------------------------+

user_name

+--------------------------+

WMUK Wiki Migration Team

+--------------------------+
1 row in set (0.00 sec)