[Dovecot] how to make quota per user ??

[Andreas Meyer]

ihab <ihab_mishriki at hotmail.com> wrote:

> I use dovecot version 1.2.15 and i put quota for all users , now i want to

upgrade to at least 2.1.17, it's a painless process.

> give more size for some emails , i already added the  quota to user database
> , and i added the queries from http://wiki.dovecot.org/Quota/1.1
> MySQL:
> user_query = select uid, gid, home, \
>   concat('*:bytes=', quota_bytes) as quota_rule \
>   from users where userid = '%u'

We use with v 2.1.17
user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbox WHERE username = '%u'

> 
> # MySQL with userdb prefetch: Remember to prefix quota_rule with userdb_
> # (just like all other userdb extra fields):
> password_query = select userid as user, password, \
>   uid as userdb_uid, gid as userdb_gid, \
>   concat('*:bytes=', quota_bytes) as userdb_quota_rule \
>   from users where userid = '%u'

  Andreas