On 01/31/2014 07:16 AM, drum.lucas@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.