we are using "mydestination", "local_recipient_maps" and dbmail-lmtpd for years and my webinterface is simply maintaining a domain/transport list in a table based on dbmail_aliases triggered in a php-function after changes
in other words: i see no reason for virtual_* at all the transport table is much flexibler because you can define external transports and with some lines of code prefer them even if dbmail is pre-configured for a domain while you relay messages to the old server until all users are configured for the new one (domain-transfers and so) mydestination = proxy:mysql:/etc/postfix/mysql-mydestination.cf [root@srv-rhsoft:~]$ cat /etc/postfix/mysql-mydestination.cf user = dbmail password = **************** dbname = dbmail hosts = unix:/var/lib/mysql/mysql.sock inet:127.0.0.1:3307 query = select transport from dbma_mta where mydestination='%s'; mysql> select * from dbma_mta where mydestination like '%rhsoft%'; +-----------------------+--------------------------+ | mydestination | transport | +-----------------------+--------------------------+ | arrakisvm.rhsoft.net | dbmail-lmtp:127.0.0.1:24 | | local.rhsoft.net | dbmail-lmtp:127.0.0.1:24 | | notebook.rhsoft.net | dbmail-lmtp:127.0.0.1:24 | | rhsoft.net | dbmail-lmtp:127.0.0.1:24 | | srv-rhsoft.rhsoft.net | dbmail-lmtp:127.0.0.1:24 | | testserver.rhsoft.net | dbmail-lmtp:127.0.0.1:24 | +-----------------------+--------------------------+ 6 rows in set (0.00 sec) Am 23.03.2012 16:49, schrieb Claas Kähler: > Your are right! But that isn't the problem. Postfix only checks if there is a > result or not. Take a look at: > > http://dbmail.org/dokuwiki/doku.php/setup_postfix > > They used the same query. > > Am 23.03.2012 16:45, schrieb Reindl Harald: >> what the hell should "SELECT DISTINCT 1" do? >> this will result in "1" and never in any list >> >> mysql> SELECT DISTINCT 1 FROM dbmail_aliases; >> +---+ >> | 1 | >> +---+ >> | 1 | >> +---+ >> 1 row in set (0.00 sec) >> >> >> Am 23.03.2012 16:39, schrieb Claas Kähler: >>> root@(none):/etc/postfix# grep virtual /etc/postfix/main.cf >>> virtual_mailbox_domains = mysql:/etc/postfix/sql-virtual_mailbox_domains.cf >>> >>> root@(none):/etc/postfix# cat /etc/postfix/sql-virtual_mailbox_domains.cf >>> user = dbmail >>> password = changeMe >>> hosts = 127.0.0.1 >>> dbname = dbmail >>> query = SELECT DISTINCT 1 FROM dbmail_aliases WHERE SUBSTRING_INDEX(alias, >>> '@', -1) = '%s'; >>> >>> Am 23.03.2012 16:29, schrieb Paul J Stevens: >>>> On 03/23/2012 04:22 PM, Claas Kähler wrote: >>>>> Okay i've got the following in my mail.log when my trying to sent a >>>>> Email to an account: >>>>> >>>>> Mar 23 16:19:34 (none) postfix/virtual[8591]: fatal: bad string length 0 >>>>> < 1: virtual_mailbox_base >>>>> Mar 23 16:19:35 (none) postfix/master[2737]: warning: process >>>>> /usr/lib/postfix/virtual pid 8591 exi status 1 >>>>> Mar 23 16:19:35 (none) postfix/master[2737]: warning: >>>>> /usr/lib/postfix/virtual: bad command startup-- throttling >>>> That's not SASL related at all! >>>> >>>> what does >>>> >>>> grep virtual /etc/postfix/main.cf >>>> >>>> have to say? >>>> >>>> >>> _______________________________________________ >>> 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 > > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
