On Wed, 2008-10-08 at 16:52 -0400, dovecot@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@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@example.com' AND domain = 'exampl' at line 1 Oct 8 16:44:55 webmail dovecot: auth(default): master out: USER^I28^Itest111@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)