On 01/31/2014 07:16 AM, [email protected] 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.
