While it's definitely annoying, that's one thing I love about dbmail: It's an indexed SQL lookup, rather than a mbox-style trudge-through-a-10Mb-file-to-fine-there-is-no-new-mail approach.
With enough memory, and especially with the MySQL 4.0 query-cache; it barely causes a performance hit. /Mark > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Beaudoin > Sent: Thursday, 11 March 2004 3:16 p.m. > To: [email protected] > Subject: [Dbmail] What to do with POP3 spammers > > I have my dbmail+postfix+amavis_new+fprot server running > and im blocking 7000 spams+virus a day (2,555,000 per year !outch!). > > Well so much for spams comming from the internet. > > Yesterday i made a small script using a mysql querry > and the linux sort program to get a cumulative > readout of there last_login. > > And via cron i executed that script at every minutes > for 3 hours to get a summary for the 3 hours. > > Well i have more then 400 POP3 spammers (teachers with phd). > > Some have setup there pc to check for mail every minutes > others at every 2 minutes and others at every 5 minutes even > if they where ask not to do that. > > I plan to make a other script to send a automatic email to all > the pop3 spammers. > > Does anybody have a other solution ? > > 1 - Have dbmail 2.0 refuse rapid pop3 queries > but what the heck there getting to dbmail anyway > 2 - Quick there derriere > 3 - Fire them > 4 - Send them back to school so they no 60 x 24 = 1440 pop3 > querys a day > 5 - Send them back to school so they can help me write scripts > 6 - > 7 - > 8 - > 9 - > 10- > > > Jacques Beaudoin > Responsable des accès internet / Internet security manager > Commission scolaire de la Pointe de l'Ile / School board > Montréal, Québec, Canada > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
