Apparently an old group was named like that but after it was removed members were left in the group and now users such as Chad are flagged as "importers" when they're not in that group. As it had to be done in other cases, a SQL command is required to clean this up. Thanks.
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
This needs someone with access to silver I guess. @bd808 do you have access there and can run the SQL query?
Comment Actions
I do have access; I think all deployers do as well, although that may require using the mwdeploy shared agent from tin rather than direct access with their normal ssh key.
Is is just these user_groups records that need to be removed?
(wikiadmin@silver) [labswiki]> select user_name, ug_group from user, user_groups where user_id = ug_user and ug_group = 'importers'; +---------------+-----------+ | user_name | ug_group | +---------------+-----------+ | Chad | importers | | Petrb | importers | | Thehelpfulone | importers | +---------------+-----------+ 3 rows in set (0.00 sec)
Comment Actions
@bd808 Yep, that's them https://wikitech.wikimedia.org/wiki/Special:ListUsers?username=&group=importers. Should they still need to do XML importing they should be added to the 'importer' group instead via Special:UserRights.
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2017-10-17T14:47:18Z] <bd808> wikitech: Cleaned up 'importers' user_group entries (T171682)
Comment Actions
(wikiadmin@silver) [labswiki]> select * from user_groups where ug_group = 'importers'; Empty set (0.00 sec)