On 08/05/2019 00:39, Mike Tubby via Exim-users wrote:
> user_filter:
> driver = forwardfile
> data = ${lookup mysql{SELECT rule FROM users LEFT JOIN domains \
> ON domains.id=users.domain_id LEFT JOIN filters \
> ON users.id=filters.user_id WHERE
> domains.domain='${quote_mysql:$domain}' \
> AND users.username='${quote_mysql:$local_part}' \
> AND domains.active=1 \
> AND users.active=1 \
> AND filters.active=1}}
> no_verify
> no_expn
> check_ancestor
Where's your rule ordering? And what on earth is "forwardfile" ?
> Am I going to need to arrange for the database result set to start with
> '# Exim Filter' each time or is their a boolean to force this?
>
> If there isn't a boolean to force it, then it would be good to have a
> 'is_filter' boolean ;-)
No, there's not enough call for that; it's your problem :)
It's only a string; just glom it on before the result
of the DB lookup expansion.
> As far as memory utilisation goes, won't Exim discard any memory it
> allocated for the result set at the end of the delivery?
Yes. I wasn't meaning permanent.
--
Cheers,
Jeremy
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
