Skip to Content.
Sympa Menu

en - cleaning old bouncers

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Fil <address@concealed>
  • To: Sympa-Users <address@concealed>
  • Subject: cleaning old bouncers
  • Date: Thu, 27 Mar 2003 17:53:18 +0100

Hello,

I've just realized that, if I want to celan up my subscribers' list from old
bounces, I just have to check the bounce_subscriber field and lit all users
that have quite many bounces registered with specific boucning codes.

for example :
mysql> select bounce_subscriber from subscriber_table LIMIT 0,100;
+--------------------------------+
| bounce_subscriber |
+--------------------------------+
| 1014137675 1014137675 1 5.0.0 |
| 1028312546 1048200137 18 5.0.0 |
| 1020102361 1048188420 24 |
| NULL |
| 1004445499 1048178458 36 5.1.1 |
| 1016025113 1016025113 1 4.0.0 |
| 1004447676 1037830421 55 |
| 1037135291 1048175076 11 5.0.0 |
| NULL |
.../...


What would you suppress?

This one is fine (1 hit, a long time ago):
| 1016025113 1016025113 1 4.0.0 |

This one is ugly (36 bounces coded 5.1.1):
| 1004445499 1048178458 36 5.1.1 |

I think I'm going to write a statistics and cleaning script. Any help will
be appreciated.


-- Fil




Archive powered by MHonArc 2.6.19+.

Top of Page