Re: [exim] spammers IP ban

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Peter Bowyer
Ημερομηνία:  
Προς: exim users
Αντικείμενο: Re: [exim] spammers IP ban
On 28/02/06, Henry Amrhein <hamrhein@???> wrote:
> On 2/27/06, David Saez Padros <david@???> wrote:
>
> > we are doing a similar thing, but instead of having a log parser we
> > directly insert the ip into a mysql database using exim builtin mysql
> > support, then every 5 minutes the mysql databse is dumped into a faster
> > cdb databse which is used by exim.
>
> I'm curious. Doesn't a few writes to the relational database take
> much longer
> than the time gained by reading from the cdb file? I'm not saying this
> is a bad technique. I'm just curious if I'm thinking correctly.


That would be my worry, too, along with the (certain) delays and
(possible) erroneous results when the MySQL connection isn't
available. Hence my use of the log-scraping technique to take the
database writes out of the critical path.

Peter

--
Peter Bowyer
Email: peter@???
Tel: +44 1296 768003
VoIP: sip:peter@???
VoIP: *5048707000@???
FWD: **275*5048707000
VoipTalk: **473*5048707000