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
