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