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(idchar(128) NOT NULL default '',cryptchar(128) NOT NULL default '',clearchar(128) NOT NULL default '',namechar(128) NOT NULL default '',uidint(10) unsigned NOT NULL default '65534',gidint(10) unsigned NOT NULL default '65534',homechar(255) NOT NULL default '',maildirchar(255) NOT NULL default '',quotachar(255) NOT NULL default '', KEYid(id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO
usersVALUES ('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 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
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
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> 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
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 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> 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
Hi there,
Sorry to bust in on this little problem, but what about us users that don't have/use quota support in their mail setup? Is there any way of either removing the displayed text alltogether, or changing it so it only displays current diskusage? As it is now, the line which states 0.00/0.00 MB used is pretty useless, and generating questions from my userbase...
Thanks,
Michiel
On Mon, 20 Feb 2006 17:56:55 +0100, Mykeul myk3ul@gmail.com 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 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> 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 findanything
relevant about this problem. Could you help me ? Thanks, Mykeul
Michiel Oosterling wrote:
Hi there,
Sorry to bust in on this little problem, but what about us users that don't have/use quota support in their mail setup? Is there any way of either removing the displayed text alltogether, or changing it so it only displays current diskusage? As it is now, the line which states 0.00/0.00 MB used is pretty useless, and generating questions from my userbase...
Sorry for that. It's hard to create an application that does right to everybody... Just open skins/default/templates/mail.html and remove the line that contains <roundcube:object name="quotaDisplay" />
Thanks,
Michiel
Thomas
On Mon, 20 Feb 2006 17:56:55 +0100, Mykeul myk3ul@gmail.com 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 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> 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 findanything
relevant about this problem. Could you help me ? Thanks, Mykeul
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 >
-
Aury Fink Filho -
Michiel Oosterling -
Mykeul -
Thomas Bruederli