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