[exim] .forward from a database

Góra strony
Delete this message
Reply to this message
Autor: DANIEL DAVID EGLI
Data:  
Dla: exim-users
Temat: [exim] .forward from a database
Greetings fellow Exim users,

I have what seems like a simple issue, but I can't seem to get it quite right. I did look in the manual, but I guess I missed the solution if it's there (and I would not be surprised if that is so), so please bear with me if this is indeed a case of RTFM.

I have a mail server where all the account details will be stored inside a MySQL database. What I want is to place the forward address (if there is one) in the database also, instead of the user's .forward file. This is because this particular server is almost entirely virtual domain users, with almost no-one who actually has shell access, so except for the mail directory, many of the users don't HAVE a home directory to hold a .forward file in the first place. I use the maildir format, so I suppose I could just place the .forward file in the base maildir, level with the cur, new, and tmp directories or something, but I'd really prefer not to do that. I tried what I thought would be indicated by the manual and examples I saw, but they don't seem to be working. The forward is ignored. Here's the table:

EmailAccts (
EmailAddr varchar(90) primary_key not null,
uid int(5) not null default 12,
gid int(5) not null default 8,
ClearPW varchar(60) not null,
Crypted varchar(90) not null default '*LOCKED*',
ForwardTo varchar(150),
HomeDir varchar(60) not null,
MailDir varchar(70) not null
)

If no forward is defined, the ForwardTo field should be null.

And here's the router entry from the exim.conf (forgive the linewrap):

virtual_forwards:
driver = redirect
domains = +local_domains
router_home_directory = ${lookup mysql{ select HomeDir from EmailAccts where EmailAddr = '${quote_mysql:${local_part}}' }}
data = ${lookup mysql = ${lookup mysql{ select ForwardTo from EmailAccts where EmailAddr = '${quote_mysql:${local_part}}' and ForwardTo != null }}
no_verify
no_expn
forbid_filter_existtest
forbid_filter_lookup
check_ancestor
directory_transport = address_directory
reply_transport = address_reply

Any help on this is appreciated. I've looked at a couple examples, but can't seem to find one where the forward address is in the database. Everyone else just uses a .forward file at a set location.

Thanks!
--- Dan Egli