Demande #5278
Nettoyer les abonnements openmailbox
Start date:
03/13/2021
Due date:
% Done:
0%
Estimated time:
Difficulté:
2 Facile
Description
Le domaine openmailbox est à l'abandon depuis plus de deux ans. Cf https://linuxfr.org/users/aurelieng/journaux/openmailbox
Je sais pas pk sympa ne les désabonne pas très vite mais ça fait 2 ans que ce domaine nous pourri les queues mail.
Je propose de supprimer les abonnements.
MariaDB [sympa]> select count(user_subscriber),sum(bounce_score_subscriber),list_subscriber from subscriber_table where user_subscriber like "%@openmailbox.org" group by list_subscriber; +------------------------+------------------------------+-----------------------+ | count(user_subscriber) | sum(bounce_score_subscriber) | list_subscriber | +------------------------+------------------------------+-----------------------+ | 1 | 0 | 20ans | | 17 | 30 | april-actu | | 1 | NULL | campagne-adhesion | | 3 | NULL | candidatsfr-actu | | 1 | 0 | candidatsfr-locaux | | 1 | 0 | communique | | 1 | 0 | comptabilite | | 1 | 11 | copyleft_attitude | | 1 | NULL | diversite | | 3 | 89 | educ | | 1 | NULL | gnu30parisorg | | 1 | 0 | informatique-deloyale | | 1 | 0 | lef | | 1 | 17 | libreassociation | | 1 | NULL | news | | 1 | 10 | trad-gnu | | 1 | 0 | traductions | +------------------------+------------------------------+-----------------------+ 17 rows in set (0.026 sec) select user_subscriber,bounce_score_subscriber,list_subscriber from subscriber_table where user_subscriber like "%@openmailbox.org"; +-------------------------------------+-------------------------+-----------------------+ | user_subscriber | bounce_score_subscriber | list_subscriber | +-------------------------------------+-------------------------+-----------------------+ ... 37 rows in set (0.023 sec)
Related issues
History
Updated by François Poulain over 2 years ago
Fait.
MariaDB [sympa]> delete from subscriber_table where user_subscriber like "%@openmailbox.org"; Query OK, 37 rows affected (0.042 sec)
Updated by François Poulain over 2 years ago
- Status changed from Nouveau to Résolu
- Assignee set to François Poulain
En fait sympa est censé faire ce job mais il limite la durée de rétention des erreurs à 90j par défaut. Donc sur des listes où le trafic est faible, il oublie les erreurs trop vite pour accumuler un score de désabonnement.
Updated by François Poulain over 2 years ago
Y en a aussi une paire via dtc.
MariaDB [gdtc]> select name,email from person where email like '%openmailbox.org'; +---------------------+--------------------------------------+ | name | email | +---------------------+--------------------------------------+ ... +---------------------+--------------------------------------+ 13 rows in set (0.017 sec) MariaDB [gdtc]> select name,email from entity where email like '%openmailbox.org'; +---------------------------------------------------+-----------------------------------+ | name | email | +---------------------------------------------------+-----------------------------------+ ... +---------------------------------------------------+-----------------------------------+ 1 row in set (0.000 sec)
Je propose de le updater à "" vu que ce champ a l'air possiblement vide.
Updated by François Poulain over 2 years ago
Fait.
MariaDB [gdtc]> update person set email = "" where email like '%@openmailbox.org'; Query OK, 13 rows affected (0.065 sec) Rows matched: 13 Changed: 13 Warnings: 0 MariaDB [gdtc]> update entity set email = "" where email like '%@openmailbox.org'; Query OK, 1 row affected (0.032 sec) Rows matched: 1 Changed: 1 Warnings: 0
Updated by François Poulain over 2 years ago
- Related to Demande #5301: Nettoyer les abonnements des domaines HS added