Hi,
using postfix 2.1.4 w/dict_mysql I tried that one
(looks like it works):
INSERT INTO dbmail_aliases (alias, deliver_to) VALUES
('[EMAIL PROTECTED]','10'); (10 is a valid user_idnr from the
dbmail_users table)
INSERT INTO dbmail_aliases (alias, deliver_to) VALUES
('[EMAIL PROTECTED]','[EMAIL PROTECTED]');
In Postfix main.cf:
local_recipient_maps =
proxy:mysql:/usr/local/etc/postfix/dbmail_local_rcpts.sql
virtual_alias_maps =
proxy:mysql:/usr/local/etc/postfix/dbmail_remote_rcpts.sql
In dbmail_local_rcpts.sql:
user = <dbuser>
password = <dbpass>
dbname = <dbname>
table = dbmail_aliases LEFT JOIN dbmail_users ON dbmail_aliases.deliver_to =
dbmail_users.user_idnr
select_field = alias
where_field = alias
additional_conditions = AND dbmail_users.user_idnr IS NOT NULL
hosts = inet:<dbhostname>:3306
In dbmail_remote_rcpts.sql:
user = <dbuser>
password = <dbpass>
dbname = <dbname>
table = dbmail_aliases LEFT JOIN dbmail_users ON dbmail_aliases.deliver_to =
dbmail_users.user_idnr
select_field = alias
where_field = alias
additional_conditions = AND dbmail_users.user_idnr IS NULL
hosts = inet:<dbhostname>:3306
--
Wolfram
>
> Is there is a way make the MTA doit the same way as DBMail does know.
>
> e.g:
> have an alias that forwards to an external address and to a
> local address.
>
> Hmm, I'm sure there's a way to do that.. Can you give an example of
> how to configure Postfix to do this?
>
> Ilja
