OK, this looks really good. I'll have a try at it myself. Does it also work if there are several different deliver_to's for an alias?
Ilja On Tue, 14 Sep 2004 20:57:02 +0200, Wolfram A. Kraushaar <[EMAIL PROTECTED]> wrote: > Oops, > > a little typo in > "dbmail_remote_rcpts.sql" > "select_field" should be set to "deliver_to" > > :) > > -- > Wolfram > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Wolfram > > A. Kraushaar > > Sent: Dienstag, 14. September 2004 20:35 > > To: 'DBMAIL Developers Mailinglist' > > Subject: RE: [Dbmail-dev] Aliases Expansion, is dbmail the > > correct place? > > > > 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 > > > > _______________________________________________ > > Dbmail-dev mailing list > > Dbmail-dev@dbmail.org > > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >
