Ok i’m close to what I want but postfix lacks in providing what it does in other lookups (so this isn’t a dbmail problem but maybe someone could help).
I’m currently using this mydestination = $myhostname, localhost, mysql:/etc/postfix/mydestination.mysql alias_maps = mysql:/etc/postfix/alias_maps.mysql local_recipient_maps = mysql:/etc/postfix/local_recipient_maps.mysql mailbox_transport_maps = mysql:/etc/postfix/mailbox_transport_maps.mysql the mailbox_transport_map can deliver mail based on the user account. Now my problem is that i’m trying to see about using dbmail at it’s full potential buy making it host multiple domains and across multiple sites. To eliminate the John Doe in 2 domains, I used [email protected] and [email protected] as login accounts (dbmail_users). 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 So i have no clean way to map email address for a domain to multiple lmtp servers for domains that run in multiple locations/servers. Anyone implement a similar setup? George Vieira. From: [email protected] [mailto:[email protected]] On Behalf Of George Vieira Sent: Saturday, 29 August 2009 10:16 PM To: '[email protected]' Subject: [Dbmail] recipient redirect Hi all, I tried searching but couldn’t find anything close to what i’m looking for so if it was mentioned before, sorry. I’ve been wanting to try and build a mail system where there can be 2 mail store and/or 2 server, eg domain.tld in Melbourne and Sydney. Each has a list of the total user list but with a transport for the users in the other network. I thought using dbmail-lmtp and point a users mail to the opposite server would be the trick but i can’t see how i can implement this, only domains can be done on the postfix level so i’m resorting to dbmail lmtp. I was hoping for basically some sort of recipient transport map. Can this be done for multisite servers? George.
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
