3 messages in net.sourceforge.lists.courier-maildrop[maildropl] Courier + Maildrop + mysq...
FromSent OnAttachments
Marcio MerloneMay 12, 2003 7:26 am 
Devin RubiaMay 12, 2003 7:54 am 
Marcio MerloneMay 12, 2003 8:43 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[maildropl] Courier + Maildrop + mysql - odd behavior changing soft quotaActions...
From:Marcio Merlone (mm@surf.com.br)
Date:May 12, 2003 7:26:49 am
List:net.sourceforge.lists.courier-maildrop

Hello all,

I have a mailserver using maildrop as MDA and Courier-IMAP both compiled with mysql support. No other software accesses the maildir than those softwares.

I have a user on mysql like:

mysql> SELECT address, quota FROM users WHERE address = "mm@puma.dialdata.com.br"; +-------------------------+---------------+ | address | quota | +-------------------------+---------------+ | mm@puma.dialdata.com.br | 104857600S,0C | +-------------------------+---------------+ 1 row in set (0.01 sec)

mysql>

A step ahead: mm@surf.com.br is aliased to mm@puma.dialdata.com.br...

This user used to have 30MB as maildir quota, then I updated to 100MB on mysql. Also, I did maildirmake -q 104857600S,0C on the maildir and correctly created a new maildirsize with the contents:

104857600S 16734874 186

So, everything is fine until it receives a new message, when it gets back to the old quota. Full transcription:

[root@koala bin]# cat /data/mail/puma.dialdata.com.br/mm/maildirsize 104857600S 16734874 186 [root@koala bin]# mail mm@surf.com.br Subject: g g . EOT [root@koala bin]# cat /data/mail/puma.dialdata.com.br/mm/maildirsize 31457280S 16734874 186 997 1 [root@koala bin]# mysql -p -e "use maildb; select quota from users where address = 'mm@puma.dialdata.com.br';" Enter password: +---------------+ | quota | +---------------+ | 104857600S,0C | +---------------+ [root@koala bin]#

I have greped everything on maildir to find where it gets the old quota info, and I have no more ideas on how to make this quota change!

Is it a bug or have I missed something? Both maildrop and courier reads the same field on the same table on the same server.

While accessing the account from the webmail (squirrelmail with quota plugins) it reports the correct quota info until a message delivery changes it back to 30MB, so it is a maildrop issue.

Thanks for any help. Please tell me if you need more info.

Regards,