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. je...@kci.net _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail