[Dovecot] Quota won't work

Timo Sirainen tss at iki.fi
Wed Jan 18 23:07:42 EET 2012


On 18.1.2012, at 22.41, Markus Fritz wrote:

>  passdb:
>    driver: sql
>    args: /etc/dovecot/dovecot-sql.conf
>  userdb:
>    driver: static
>    args: uid=5000 gid=5000 home=/var/vmail/%d/%n/Maildir allow_all_users=yes

You use sql as passdb, static as userdb.

> password_query = SELECT email as user, password FROM virtual_users WHERE email='%u';

passdb sql executes password_query.

> user_query = SELECT CONCAT('/var/mail/', maildir) AS home, CONCAT('*:bytes=', quota) AS quota_rule \
> FROM virtual_users WHERE email='%u'

userdb sql executes user_query. But you're not using userdb sql, you're using userdb static. This query never gets executed.

Also you don't have plugin { quota } setting.




More information about the dovecot mailing list