Project

General

Profile

Demande #5278

Nettoyer les abonnements openmailbox

Added by François Poulain 9 months ago. Updated 7 months ago.

Status:
Fermé
Priority:
Normale
Category:
-
Target version:
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

Related to Admins - Demande #5301: Nettoyer les abonnements des domaines HSFermé04/01/2021

Actions

History

#1

Updated by François Poulain 9 months ago

  • Description updated (diff)
#2

Updated by François Poulain 9 months ago

Fait.

MariaDB [sympa]> delete from subscriber_table where user_subscriber like "%@openmailbox.org";
Query OK, 37 rows affected (0.042 sec)
#3

Updated by François Poulain 9 months 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.

#4

Updated by François Poulain 9 months 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.

#5

Updated by François Poulain 9 months 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

#6

Updated by François Poulain 8 months ago

  • Related to Demande #5301: Nettoyer les abonnements des domaines HS added
#7

Updated by Quentin Gibeaux 7 months ago

  • Status changed from Résolu to Fermé

Also available in: Atom PDF