[NTLUG:Discuss] Relaydelay delight

[David Stanaway]

Not syre about the answer to you question.
You will need a
DELETE FROM ,,,, WHERE ...; type statement.

I am using postgrey and that is cutting a significant amount of my junk,
mostly what I get now are pump and dumps, the image kind. They seem to
defeat my rbl, postgrey, spamassassin and icedove junk filter (Debadged
thunderbird).

Anyone have any ideas on how to get rid of these pesky junk stock scams?

. Daniel wrote:
> Working my way through the completion of a spam-free weekend, I check my 
> email and that's all I see!  My email!  Nothing extra.  Nothing I didn't 
> ask for or ask to cease.
> 
> My database tables, I fear, will be filling as are my logs.  I have 
> installed a log rotater, but I'm unsure about purging the expired records 
> in my "relaytofrom" table.  What would be the query to clear them out?  I'm 
> not an SQL person at all.  I just barely understand what it is.
> 
> So my burning question is:
> 
> How do I set up a routine to purge the expired entries from the tables?  I 
> know it'll be a cron job.  I'm pretty sure some perl script will be the 
> delivery system.  And I'm certain it will be the execution of one, maybe 
> two queries to MySQL.  The problem is I don't know how to make those happen 
> in detail.  I know what, but not how.
> 
> I use webmin's MySQL module as the means to examine the tables' contents.  
> It really tickles me inside to see all the junk being turned away and all 
> the good stuff being allowed through.  I understand the logic and it just 
> seems too simple to work, and yet it does and it's ever so effective.  
> Concisely put:
> 
> "The REAL Postman knocks twice." (The spammer does not)
> 
> It's a beautiful thing.
> 
> _________________________________________________________________
> 節約のアイディア300例。お金の悩みは、MSN マネーで自己解決 
> http://plan.money.jp.msn.com/saving/index.html 
> 
> 
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss
>