[Dovecot] postfix/dovecot/mysql quotas not working, default dovecot.conf does.

[Timo Sirainen]

On Wed, 2008-10-08 at 16:52 -0400, dovecot at corwyn.net wrote:
> 'maildir:/var/spool/mail/example.com/test111/Maildir' as mail, 
> concat('maildir:storage=', quota) as quota, concat('*:storage=', 
> quota, '') as quota_rule, FROM mailbox WHERE username = 

You've a comma between quota_rule and FROM.

> sql(test111 at example.com,127.0.0.1): User query failed: You have an 
> error in your SQL syntax; check the manual that corresponds to your 
> MySQL server version for the right syntax to use near 'FROM mailbox 
> WHERE username = 'test111 at example.com' AND domain = 'exampl' at line 1
> Oct  8 16:44:55 webmail dovecot: auth(default): master out: 
> USER^I28^Itest111 at example.com

Since the primary userdb failed, Dovecot continued by trying the second
one which is static userdb. It's not really a very safe secondary
choice, since this can happen any time the SQL server is down..

(plus see my other mail I replied to privately)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20081009/77086a0d/attachment-0001.bin