Re: [RoundCube Users] Quota problem

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 ('test@test.local
<mailto:test@test.local>', '', '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 test@test.local <mailto:test@test.local> 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