Ok,
I think I have have gotten my head around this now ...
I have a global domain list:
#
# local_domains -> domains that land here
#
domainlist local_domains = ${lookup mysql{SELECT domain FROM domains
WHERE type='local' AND active='1'}{${sg{$value}{\\n}{ : }} }}
which I already use for routing non-local domains to our outgoing relays
(smart hosts). I can reference this in again in each router.
I can re-write each of my routers something like:
#
# Normal local delivery
#
local_delivery:
driver = accept
domains = +local_domains
local_parts = ${lookup mysql{SELECT users.username AS username
FROM \
users LEFT JOIN domains ON users.domain_id=domains.id
WHERE \
users.username='${quote_mysql:$local_part}' AND \
domains.domain='${quote_mysql:$domain}' AND \
users.active=1 AND domains.active=1}}
transport = local_delivery
user = mail
group = mail
... and I don't need a 'condition' since the router will only match and
call the transport if the domains and local_parts are both non-empty. I
just have to remember to do the full cross table query (JOIN) otherwise
I end up with unintended aliasing with the local part existing in every
one of my local domains.
Then my transport can be something like this:
#
# This transport delivers to local users with virtual mailboxes in Maildir
# format into the primary Maildir/virtual INBOX
#
local_delivery:
driver = appendfile
maildir_format = true
directory = /srv/mail/$domain_data/$local_part_data/Maildir
create_directory = true
directory_mode = 0770
mode_fail_narrower = false
message_prefix =
message_suffix =
delivery_date_add
envelope_to_add
return_path_add
user = mail
group = mail
mode = 0660
using the non-tainted $domain_data and $local_part_data as they have
both been set up.
This appears to pass "exim -d -bt [email protected]" at least but I
now think that I have issues with by aliases, vacations and other
special responders to resolve.
Mike
--
## 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/
