

![]() | Start a set with this search |
![]() | Include this search in one of my sets |
![]() | Exclude this search from one of my sets |
![]() | Permalink to these results Paste this link in email or IM: |
| Atom feed for tracking future search results Paste this URL into your reader: |
9 messages in net.sourceforge.lists.courier-maildropRe: [maildropl] converting from maild...| From | Sent On | Attachments |
|---|---|---|
| Heiko | Aug 19, 2008 12:03 am | |
| Heiko | Aug 19, 2008 12:09 am | |
| Sam Varshavchik | Aug 19, 2008 4:02 am | |
| Heiko | Aug 19, 2008 4:18 am | |
| Heiko | Aug 19, 2008 4:54 am | |
| Sam Varshavchik | Aug 19, 2008 3:25 pm | |
| Sam Varshavchik | Aug 19, 2008 3:26 pm | |
| Heiko | Aug 20, 2008 12:53 am | |
| Sam Varshavchik | Aug 20, 2008 4:09 am |

![]() | Permalink for this message Paste this link in email or IM: |
![]() | Permalink for this thread 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 quota | Actions... |
|---|---|---|
| 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.







