Hi,
I'm the quota patch author.
This quota problem happens to me when I have quota set to 0 (unlimited).
I also use courier-imap.
Courier-imap calculates the quota size based in the maildirsize for the
account (probably you don't have a maildirsize yet, e.g., no mails in
this account). MySQL only plays a role when there's no maildirsize, or
when you alter the quota. When you alter the quota, the maildirsize file
is recalculated.
Regards,
Aury
Mykeul wrote:
Hi there,
I use CVS Roundcube, and I try to get the quota working. I check in
the source code, and saw that the "disk usage" in rc is calculated
from the imap command QUOT1 GETQUOTA ROOT "INBOX" (I know QUOT1 is
only the way to recognize response).
The problem is that when I ask this to my courier-imap server, it does
NOT reply something RC expects.
I know it is not a rc problem, but I ask on a courier-imap newsgroup
and nobody awnsers. Could you help me please ? I'm sure it is a simple
problem for someone who knows well imap.
The message I posted on the NG, with technical info is juste below.
Thanks a lot,
Mykeul
I set up a courier-imap server with a mysql authentication. Everything
works well, but the quotas are not.
Here's my authmysqlrc :
MYSQL_SERVER localhost
MYSQL_USERNAME mail
MYSQL_PASSWORD password
MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CLEAR_PWFIELD clear
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD id
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
MYSQL_QUOTA_FIELD quota
and here is my mysql db :
CREATE TABLE `users` (
`id` char(128) NOT NULL default '',
`crypt` char(128) NOT NULL default '',
`clear` char(128) NOT NULL default '',
`name` char(128) NOT NULL default '',
`uid` int(10) unsigned NOT NULL default '65534',
`gid` int(10) unsigned NOT NULL default '65534',
`home` char(255) NOT NULL default '',
`maildir` char(255) NOT NULL default '',
`quota` char(255) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `users` VALUES ('[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>', '', 'test', 'Test', 8,
8, '/backup/mail/boxes/test', '/backup/mail/boxes/test
/Maildir/',
'1000000S');
When I telnet my 143 port and ask for the quota, I get this :
debianetch~ telnet localhost 143
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL
ACL2=UNION]
Courier-IMAP ready. Copyright 1998-2004 Double Precision, Inc. See
COPYING for distribution information.
A login [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> test
A OK LOGIN Ok.
B GETQUOTAROOT "INBOX"
* QUOTAROOT "INBOX" "ROOT"
* QUOTA "ROOT"
B OK GETQUOTAROOT Ok.
The line
* QUOTAROOT "INBOX" "ROOT"
* QUOTA "ROOT"
is not what my webmail expects, it should be something like
* QUOTAROOT INBOX user/test
* QUOTA user/test (STORAGE 654 9765)
I have been browse dozens of Google pages but I dont find anything
relevant about this problem.
Could you help me ?
Thanks,
Mykeul
