Re: [Dovecot] Quota won't work

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.