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

Reply via email to