Dear all,
Im using roundcubemail 0.5stable and dovecot2.09. When i change the user quota in mysql, the rcmail show the capacity will not change. i've run "doveadm quota recalc".
the following is user_query in dovecot-sql.conf.ext
user_query = \
SELECT username AS user,uidnumber AS uid, gidnumber AS gid, \
CONCAT('/home/mail/',homedir) AS home, \
CONCAT('maildir:/data/mail/',maildir) AS mail, \
CONCAT('maildir:storage=',quota) as quota \
FROM mailbox WHERE username = '%u' AND active = '1'
--
Best Cheer (XiaMen) Stone Works CO.,LTP.
Phone: 0592-7221600