[Dovecot] Quota is not working (Debian Squeeze - Dovecot 1.2)

[Timo Sirainen]

On Mon, 2012-01-16 at 11:42 +0100, RaSca wrote:
>   passdb sql {
>     args = /etc/dovecot/dovecot-sql.conf
>   }
>   userdb passwd {
>   }
>   userdb static {
>     args = uid=5000 gid=5000 home=/mail/mailboxes/%d/%n@%d
> allow_all_users=yes
>   }

You're using SQL only for passdb lookup.

> plugin {
>   quota = maildir:/mail/mailboxes/%d/%n@%d

The above path probably doesn't do what you intended. It's only the
user-visible quota root name. It could just as well be "User quota" or
something.

> The db connection works, this is /etc/dovecot/dovecot-sql.conf:
> 
> driver = mysql
> connect = host=<myserver> dbname=mail user=<myuser> password=<mypassword>
> default_pass_scheme = CRYPT
> password_query = SELECT username, password FROM mailbox WHERE username='%u'
> user_query = SELECT username AS user, maildir AS home,
> CONCAT('*:storage=', quota , 'B') AS quota_rule FROM mailbox WHERE
> username = '%u' AND active = '1'

user_query isn't used, because you aren't using userdb sql.