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 > DBmail@dbmail.org > 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 DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
