[Dovecot] Dovecot2 + Quota

[Gedalya]

On 01/31/2014 07:16 AM, drum.lucas at gmail.com wrote:
> dovecot-sql.conf:
> driver = mysql
> connect = host=localhost dbname=mail user=mail password=xxxxxxxxxxxx
> default_pass_scheme = MD5
>
> user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'
> as mail, 150 AS uid, 12 AS gid, CONCAT('dirsize:storage=', ROUND(
> mailbox.quota / 1024 ) ) AS quota FROM mailbox WHERE username = '%u' AND
> active = '1'
>
> password_query = SELECT username as user, password, '/var/vmail/%d/%n' as
> userdb_home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 150 as userdb_uid,
> 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
Your password query returns userdb_ fields, are you using driver = prefetch?
http://wiki2.dovecot.org/UserDatabase says: This assumes that the passdb 
already returned also all the required user database information. Your 
password query does not return the quota size.

Also as Robert said, the field name returned by the query should be 
quota_rule and userdb_quota_rule in the password query, and the value so 
formatted.