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@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@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