On Mon, 9 May 2011 08:51:02 -0700
Todd Lyons <[email protected]> wrote:
Hello Todd,
> > Routers section:
> > ----------------
> > virtual_vacation:
> > driver = accept
> > condition = ${if and{ \
> > {!match {$h_precedence:}{(?i)junk|bulk|list}} \
> > {eq {${lookup mysql{select users.on_vacation from
> > users,domains \
> > where localpart = '${quote_mysql:$local_part}' \
> > and domain = '${quote_mysql:$domain}' \
> > and users.on_vacation = '1' \
> > and users.domain_id=domains.domain_id}}}{1}} \
>
> So you check if a particular user is in the database (a local user)
> and then you do send a vacation message if they are found. Off the
> cuff it seems like you're missing a not in front of that eq{}
> function.
Actually that condition is only for querying if the user set his/her autoreply
function and I still think it is OK.
(If the "on_vacation" field equals 1, we have to handle autoreplies, otherwise
we step to the next router.)
I'd like to catch those addresses after the condition, with "senders":
senders = !${lookup mysql{select vn.address from users u,domains d,noautoreply
vn \
where u.localpart = '${quote_mysql:$local_part}' \
and d.domain = '${quote_mysql:$domain}' \
and u.domain_id=d.domain_id \
and vn.user_id = u.user_id}{$value}}
(If the user set any addresses to the noautoreply table, I don't want to
deliver autoreply to these.)
The problem must be here, during the expansion of mysql query. I'd like to
create this expansion in that way the
empty list should work as well as a populated list.
I have seen an following example on the Internet:
# Create an addresslist from file
addresslist noautoreply_senders = /var/mail/autoreply.noanswer
# This is the routers section
uservacation:
driver = accept
domains = +local_domains
condition = ${if and{ \
(blah blah...)
# Expand and negate the addresslist in the senders conditional
senders = !+noautoreply_senders
and finally the /var/mail/autoreply.noanswer file can contain the addresses:
[email protected]
[email protected]
^postmaster@.*
...
Now I'd like to do the same concept but I want it to use per-user settings from
MySQL.
> > (By the way, I have another little problem; I set the "log" in the
>> transport section but the file is never created and I couldn't find any
>> particular reason for this.)
>
> You don't specify any user or group for exim to deliver as. If the
> user's maildir is not the same user that exim is running as, then it
> can't create the file(s).
Ah, this must be the solution. I'll try it as soon as possible. Thank you!
Regards,
Imre
--
## 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/
