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'
On 16.02.2011 02:42, 邓卫华 wrote:
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".
This is probably a server issue. Enable imap_debug in Roundcube and check quota responses from server.
Hi,
the following is logging of imap debug, imap can get right quota.
[16-Feb-2011 16:02:18 +0800]: S: A0001 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS QUOTA] Logged in [16-Feb-2011 16:02:18 +0800]: C: A0002 LIST (SUBSCRIBED) "" "*" [16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Sent" [16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Drafts" [16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Trash" [16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Junk" [16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "&W1hoY5CuTvY-" [16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "&kBp35ZAaVEo-" [16-Feb-2011 16:02:18 +0800]: S: A0002 OK List completed. [16-Feb-2011 16:02:18 +0800]: C: A0003 GETQUOTAROOT INBOX [16-Feb-2011 16:02:18 +0800]: S: * QUOTAROOT "INBOX" "storage=115343360S" [16-FEB-2011 16:02:18 +0800]: S: * QUOTA "STORAGE=115343360S" (STORAGE 100146 204800) [16-Feb-2011 16:02:18 +0800]: S: A0003 OK Getquotaroot completed. [16-Feb-2011 16:02:18 +0800]: C: A0004 LOGOUT [16-Feb-2011 16:02:18 +0800]: S: * BYE Logging out [16-Feb-2011 16:02:18 +0800]: S: A0004 OK Logout completed.
On Wed, 16 Feb 2011 08:50:30 +0100, A.L.E.C wrote:
On 16.02.2011 02:42,
邓卫华 wrote:
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".
This is probably a server
issue. Enable imap_debug in Roundcube and check quota responses from server. -- Aleksander 'A.L.E.C' Machniak LAN Management System Developer [http://lms.org.pl [1]] Roundcube Webmail Developer [http://roundcube.net [2]] --------------------------------------------------- PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl [3]
Dear,
thanks for your reply, i have reslove that when im change the line in user_query
change:
CONCAT('maildir:storage=',quota) as quota
to:
CONCAT('*:storage=',floor(quota /1024)) as quota_rule
On Wed, 16 Feb 2011 16:14:27 +0800, 邓卫华 wrote:
Hi,
the
following is logging of imap debug, imap can get right quota.
[16-Feb-2011 16:02:18 +0800]: S: A0001 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS QUOTA] Logged in
[16-Feb-2011 16:02:18 +0800]: C: A0002 LIST (SUBSCRIBED) "" "*"
[16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Sent"
[16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Drafts"
[16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Trash"
[16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "Junk"
[16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed) "." "&W1hoY5CuTvY-"
[16-Feb-2011 16:02:18 +0800]: S: * LIST (Subscribed)
"." "&kBp35ZAaVEo-"
[16-Feb-2011 16:02:18 +0800]: S: A0002 OK List
completed.
[16-Feb-2011 16:02:18 +0800]: C: A0003 GETQUOTAROOT INBOX
[16-Feb-2011 16:02:18 +0800]: S: * QUOTAROOT "INBOX" "storage=115343360S"
[16-FEB-2011 16:02:18 +0800]: S: * QUOTA
"STORAGE=115343360S" (STORAGE 100146 204800)
[16-Feb-2011 16:02:18
+0800]: S: A0003 OK Getquotaroot completed.
[16-Feb-2011 16:02:18
+0800]: C: A0004 LOGOUT
[16-Feb-2011 16:02:18 +0800]: S: * BYE Logging
out
[16-Feb-2011 16:02:18 +0800]: S: A0004 OK Logout completed.
On Wed, 16 Feb 2011 08:50:30 +0100, A.L.E.C wrote:
On 16.02.2011
02:42, 邓卫华 wrote:
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".
This is probably a
server issue. Enable imap_debug in Roundcube and check quota responses from server. -- Aleksander 'A.L.E.C' Machniak LAN Management System Developer [http://lms.org.pl [1]] Roundcube Webmail Developer [http://roundcube.net [2]] --------------------------------------------------- PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec..pl [3]
-- Best Cheer (XiaMen) Stone
Works CO.,LTP.
Phone: 0592-7221600