[rt-users] Recovering from spam, clean up DB?

[Odhiambo Washington]

* Rich Lafferty <rich+rt at lafferty.ca> [20020729 18:25]: wrote:
> On Mon, Jul 29, 2002 at 10:08:20AM -0400, Michael Marziani <michaelm at kw.com> wrote:
> > Over the weekend a misconfigured autoresponder deluged our RT system
> > with around 10,000 tickets.  I've blocked the user at the sendmail
> > level, but now I need a way to clean up my database (mysql).  Has anyone
> > dealt with this before?
> 
> We had a 5000 ticket flood a few weeks ago -- I just marked the
> tickets as dead and was done with it.


Hello Rich,

Excuse me for jumping in but what gave you the "flood"? While it maybe
unrelated, there is a time I had a situation almost similar. Some clown
was going on leave and had their admin setup an autoreponder. This clown
sent mail to hundreds of addresses (I'm surprised she had such a big contact
list), one of which was my rt address. So rt got the mail, responded to the
clown's address, mail was picked by the clown's bot, responded to rt, rt got
it, responded again - the cycle was so vicious I has to shutdown that queue.

I'm wondering if there is a way to protect rt against such a situation.



        cheers
       - wash 
----------------------------------+-----------------------------------------
 Odhiambo Washington, wash at wananchi.com	. WANANCHI ONLINE LTD (Nairobi, KE)
 http://ns2.wananchi.com/~wash/		. 1ere Etage, Loita Hse, Loita St.,
 GSM: (254) 722 743 223			. # 10286, 00100 NAIROBI
----------------------------------+-----------------------------------------
"Oh My God! They killed init! You Bastards!"  
						 --from a /. post