Projet

Général

Profil

Demande #5278

Mis à jour par François Poulain il y a plus de 3 ans

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. 

 <pre> 
 MariaDB [sympa]> select count(user_subscriber),sum(bounce_score_subscriber),list_subscriber count(user_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 (0.018 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) 
 </pre>

Retour