9 messages in net.sourceforge.lists.courier-maildrop[maildropl] converting from maildropr...
FromSent OnAttachments
HeikoAug 19, 2008 12:03 am 
HeikoAug 19, 2008 12:09 am 
Sam VarshavchikAug 19, 2008 4:02 am 
HeikoAug 19, 2008 4:18 am 
HeikoAug 19, 2008 4:54 am 
Sam VarshavchikAug 19, 2008 3:25 pm 
Sam VarshavchikAug 19, 2008 3:26 pm 
HeikoAug 20, 2008 12:53 am 
Sam VarshavchikAug 20, 2008 4:09 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] converting from maildroprc quota to mysql quotaActions...
From:Heiko (rupe@gmail.com)
Date:Aug 19, 2008 12:03:40 am
List:net.sourceforge.lists.courier-maildrop

Hello,

i have a 2 machine courier cluster which served only one domain in the past, but now we have a second domain, up to now we used quota for the maildir that was definded in the /etc/maildroprc ( `echo 52428800S >> $VHOME/$USERDOMAIN/$ACCOUNT/maildirsize`). now we would like to set the quota inside the DB, which is already used for postfix/courier authentification, and there is also already a quota field:

+-------------------------+----------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+----------------------------------+------+-----+---------+-------+ | email | varchar(255) | NO | PRI | NULL | | | domain | varchar(255) | NO | MUL | NULL | | | firstname | varchar(50) | YES | | NULL | | | fullname | varchar(100) | YES | | NULL | | | mailboxtype | enum('person','group','service') | NO | | NULL | | | password_encrypt | char(13) | NO | | NULL | | | password_sha1 | char(40) | NO | | NULL | | | quota_byte | int(10) unsigned | NO | | NULL | | | use_imap | enum('true','false') | NO | | true | | | use_directsmtp | enum('true','false') | NO | | true | | | mailhost | varchar(100) | NO | MUL | NULL | | | lastchanged_timestamp | timestamp | YES | | NULL | | | deleterequest_timestamp | timestamp | YES | | NULL | | +-------------------------+----------------------------------+------+-----+---------+-------+

what is the easiest way to use this quota field instead of the maildroprc?

thx

Rupert