9 messages in net.sourceforge.lists.courier-maildropRe: [maildropl] converting from maild...
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:Re: [maildropl] converting from maildroprc quota to mysql quotaActions...
From:Sam Varshavchik (mrs@courier-mta.com)
Date:Aug 19, 2008 4:02:48 am
List:net.sourceforge.lists.courier-maildrop

Heiko writes:

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?

You'll have to configure courier-authlib to use a custom query. maildrop expects the quota field to be the same as it would appear in maildirsize, such as "52428800S", however you have defined your quota field to be an int. Therefore, you will need to set up a custom query that retrieves this field and appends an "S" to it. See the comments in authmysqlrc for more information.