On 2/20/06, Aury Fink Filho < lista@aury.com.br> wrote:

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
>