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