Page MenuHomePhabricator

Find list owners for lists without them
Open, MediumPublic

Description

legoktm@lists1001:~$ grep '\[\]' listadmins-2021-04-21.txt  | grep -v obsolete
b'ac-temp: owner = []' - archived (in mm3)
b'helpdesk-l: owner = []' - archived (in mm3)
b'licom-l.disabled.rt7307: owner = []'
b'mediation-en-l: owner = []'  - archived
b'pressemeldungen: owner = []' - archived (in mm3)
b'spcommittee-l: owner = []' - archived
b'test-second: owner = []' - archived
b'wikifr-colloque-l: owner = []' - archived
b'wikiid-l: owner = []'
b'wikimedia-ci: owner = []'
b'wikimediabr: owner = []' - ??? not to be confused with wikimediabr-l
b'wikimediase-l: owner = []' - looks active
b'wikisv-l: owner = []' - looks active
b'wmf_community_dept: owner = []' - archived (in mm3)

Some of these should be archived some others might be active and need admin recruitment.

Event Timeline

Dzahn triaged this task as Medium priority.May 4 2021, 12:48 AM

So archiving a mailing list in mm3 is not that specified (or at least I didn't find anything, there's delete but that's not what we want here). ac-temp is on emergency moderation already, I just set the message acceptance policy to reject for both members and non-members. Does that sound good enough?

Seems like the "define what archived means" is T281778. As close as it gets to the commands that were used on mailman2 for the same thing?

German Wikinews response is they are asking for an archive of "pressemeldungen".

I closed all the ones mentioned above + pressmeldungen

So there was no archive for pressemeldungen then?

that mailing list doesn't have an archive kept.

ACK, i'll let them know. Then it can be closed as well. Since the only response so far was that they didn't know it but asked for an archive.

Saving this query for later:

mysql:mailman3@m5-master.eqiad.wmnet [mailman3]> select mailinglist.list_id from mailinglist where not exists(select * from member where member.list_id=mailinglist.list_id and (role=2));
+-------------------------------------------+
| list_id                                   |
+-------------------------------------------+
| ac-temp.lists.wikimedia.org               |
| fundraiser.lists.wikimedia.org            |
| helpdesk-l.lists.wikimedia.org            |
| iegcom.lists.wikimedia.org                |
| pressemeldungen.lists.wikimedia.org       |
| spcommittee-l.lists.wikimedia.org         |
| spcommittee-private-l.lists.wikimedia.org |
| test-second.lists.wikimedia.org           |
| wikifr-colloque-l.lists.wikimedia.org     |
| wikiid-l.lists.wikimedia.org              |
| wikimedia-ci.lists.wikimedia.org          |
| wikimediase-l.lists.wikimedia.org         |
| wikisv-l.lists.wikimedia.org              |
| wmf_community_dept.lists.wikimedia.org    |
+-------------------------------------------+
14 rows in set (0.009 sec)

Lego has this great idea to add "list-disabled@" (going to blackhole) as owner which also can at least tag which mailing lists are disabled in a machine-readable way. Most of these mailing lists are closed so this would address this issue to a great degree too.

Change 686879 had a related patch set uploaded (by Ladsgroup; author: Ladsgroup):

[operations/puppet@production] exim4: Add blackhole for "disabled-lists"

https://gerrit.wikimedia.org/r/686879

Change 686879 merged by Legoktm:

[operations/puppet@production] exim4: Add blackhole for "disabled-lists"

https://gerrit.wikimedia.org/r/686879

On mm3:

MariaDB [mailman3]> select list_id from member where list_id not in (select list_id from member where role = 2 group by list_id) group by list_id limit 50;
+-----------------------------------+
| list_id                           |
+-----------------------------------+
| wikiid-l.lists.wikimedia.org      |
| wikimedia-ci.lists.wikimedia.org  |
| wikimediase-l.lists.wikimedia.org |
| wikisv-l.lists.wikimedia.org      |
+-----------------------------------+
4 rows in set (0.113 sec)