Re: [exim] Local senders whitelist: practical limits

Greetings Mike & List

Would you be willing to share you config examples and MySQL schema
to save us (me) from re-inventing the wheel?

Regards
m

On 26/01/07, Mike Cardwell <exim-users@???> wrote:
> I'm afraid I'm not going to directly answer either of your queries, but
> offer an alternative solution that I use, and might help instead. You
> can still have your static file whitelists, but on top of that you can
> dynamically generate a whitelist as well. I do this by using an sql
> database. Every time someone from your office sends an email to someone,
> add that destination address to a whitelist table in the db, and accept
> all future emails from that address.
>
> Also, when an email comes into someone at the office, record the sender
> in a separate table with a counter of the number of times that person
> has sent an email. Then you can whitelist addresses that have emailed
> one of your colleagues more than twice for example.
>
> You could populate these tables with historic data by processing your exim
> logs, for an immediate win.
>
> The overhead caused by the SQL queries on my system is more than offset
> by the fact I don't do any spamassassin filtering on whitelisted
> addresses.