Re: [RoundCube Users] Quota problem

Hi,

It depends on how you deliver emails to your account. I use maildrop.... maildrop checks if the quota is correct, generates maildirsize, etc.

Kind regards, Aury

Mykeul wrote:

I just saw that the just released beta does not include your patch. I made some test on an old mail box, and you are right. It works, but only if I use maildirmake -q ... so what is the interest of the "quota" field in mysql ? I'd rather use this field, it is easier to administrate.

On 2/20/06, *Mykeul* <myk3ul@gmail.com mailto:myk3ul@gmail.com> wrote:

Hi,

Thanks for your awnser.
I dont understand everything. I saw in READEME.maildirquota that I
have to create maildirs with "maildirmake -q

10000000S /backup/mail/boxes/test/Maildir. And it creates a
maildir with a 'maildirsize' file into it.
I made the test before posting, and it does not change anything,
which is logical for me because I dont know what

(courier ? exim ? rc ?) has to change this maildirsize file.
My mailboxes are already existing, so I dont know if I can apply
maildirmake -q to them without crushing what is

inside.
Exim is not configured to use quotas (because I dont know howto),
but courier is.

Mykeul


On 2/20/06, *Aury Fink Filho* < lista@aury.com.br
<mailto: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>
    >     <mailto: 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> <mailto:
    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
    >