> -----Original Message-----
> From: exim-users-bounces@???
> [mailto:exim-users-bounces@exim.org] On Behalf Of Mike Cardwell
> Sent: Friday, January 26, 2007 10:43 AM
> To: exim-users@???
> Subject: Re: [exim] Auto-whitelist
>
> * on the Fri, Jan 26, 2007 at 04:34:18PM +0000, Mike Cardwell wrote:
>
> >>> We use exim 4.62 with mysql. I'd like to set up whitelist that is
> >>> automatically updated with $recipients value when a user in our
> >>> domain sends out an email. The $recipients is a comma
> delimited list
> >>> of the recipients available during data acl. I see that it can be
> >>> done using the Perl but I was hoping not to have to use Perl for
> >>> performance reasons. Has anyone done this without using Perl?
> >> I have done something similiar without using embedded Perl while
> >> setting up greylisting. The sender and recipients of
> every outbound
> >> mail are stored in a DBM file. With the help of exim acl,
> >> recipients' reply would skip the greylisting automatically. It
> >> greatly reduces the number of ham mail deferred by greylisting.
> >> The way I do it is very simple:
> > I have a couple of more complicated, but cleaner methods(imo):
> >
> > 1.) I use MySQL. I wrote a mysql stored function that takes
> the value
> > of $recipients, and processes each address in a loop.
> >
> > 2.) Use a recursive ACL to separate the contents of
> $recipients and do
> > a db call for each recipient, eg below:
>
> <snip example>
>
> set acl_m0 = ${sg{$acl_m0}{\N^[^,]+,?(.*?)$\N}{\$2}}
>
> Should probably be:
>
> set acl_m0 = ${sg{$acl_m0}{\N^[^,]+,?(.*?)$\N}{\$1}}
>
> Oh. And I just thought of a gotcha when using a recursive acl
> for this purpose. If the number of recipients is greater than
> whatever exim uses as the maximum recusion depth, it'll
> break. You're better off using a stored function with a loop
> if you're using an sql db.
>
> Mike
>
We do send to large lists that would break the acl recursion. I like the
stored procedure idea, but we're still at Mysql 4.1. Thanks.
