This doesn't work. As I said, unfortunately in postfix as a normal local user is assumed to be a name and the mailbox_transport_map is passed only the username, so it strips the domain out. http://www.irbs.net/internet/postfix/0602/0122.html
The dead giveaway also is the bounce message below (ie accounts not [email protected]). Sep 1 19:32:16 serapis postfix/local[24480]: 7823E6B57: to=<[email protected]>, relay=local, delay=0.09, delays=0.03/0.04/0/0.03, dsn=5.1..1, status=bounced (unknown user: "accounts") I even thought i'd try virtual, but virtual is worse as it doesn't actually have a virtal_mailbox_transport_map so I'm stuffed either way. I have to either change to using username_domain.tld or using subdomain domain_maps and aliases to redirect them. Ie [email protected] -> [email protected] George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jesse Norell Sent: Tuesday, 1 September 2009 3:58 AM To: DBMail mailinglist Subject: Re: [Dbmail] recipient redirect On Sun, 2009-08-30 at 21:16 +1000, George Vieira wrote: > > This is where I now run into a snag, mailbox_transport_maps only > passes the username part of the email as %s and i cannot get the full > email address on this lookup. > > > > # host and port were added to dbmail_users for the transport > testing... > > query = SELECT CONCAT( "dbmail-lmtp:", u.host, ":", u.port ) FROM > dbmail_aliases AS a, dbmail_users AS u WHERE alias like "%...@%%" AND > deliver_to = u.user_idnr AND active=1 LIMIT 1 Maybe try %...@%d (see http://www.postfix.org/mysql_table.5.html). -- Jesse Norell Kentec Communications, Inc. [email protected] _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
