dovecot - May 2008 - Fwd: Re: [SOLVED] Configuring Quota on Dovecot 1.0.13-1~bpo40+1

Thank you Tomasz!

The quota per user worked fine now...

The problem was that in dovecot.conf I had these lines:

userdb static {
   args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes
}

And I just changed to:

userdb sql {
  args = /etc/dovecot/dovecot-sql.conf
}

Now it's working...

bye!

On Wed, 28 May 2008 21:08:51 +0200, Tomasz Suchodolski
<suchodolski.tomasz at gmail.com> wrote:
>>  Hi all!
>>  I have just updated my dovecot 1.0.rc15 to 1.0.13-1~bpo40+1
>
>>  I have a mysql table with this structure:
>
>>  +----------+--------------+------+-----+---------+-------+
>>  | Field    | Type         | Null | Key | Default | Extra |
>>  +----------+--------------+------+-----+---------+-------+
>>  | email    | varchar(91)  | YES  |     | NULL    |       |
>>  | password | varchar(32)  | NO   |     |         |       |
>>  | quota    | bigint(20)   | NO   |     |         |       |
>>  | home     | varchar(255) | NO   |     |         |       |
>>  +----------+--------------+------+-----+---------+-------+
>
>>  email returns email at domain.com
>
>>  password returns the pass in mysql-crypt format
>
>>  quota returns the quota in bytes(like 100000000)
>
>>  home returns the path to the user home(like
>> /home/vmail/domain.com/email/)
>
>>  the mail user and group id are 5000.
>
>>  Now the question: How can I configure the quotas by user using
>> mysql... in dovecot 1.0.rc15 didn't work...
>>  Thanks for your
>> help!
>
> http://wiki.dovecot.org/Quota/1.0
> Set global quota and see examples for sql queries. Also try with
> kilobytes.
>
> Ps. 1.0.rc15 - quota per user(with mysql) works - I have tested it.
>
> Regards