[Dovecot] strange quota behaviour with dovecot 1.1.7

[Timo Sirainen]

On Tue, 2009-06-23 at 16:42 +0200, listacc at gmx.de wrote:
>   passdb:
>     driver: pam
>   passdb:
>     driver: sql
>     args: /etc/dovecot/dovecot-sql.conf

Do you really want to have system users too? You anyway should put pam
after the sql, because now all SQL user logins are probably delayed by a
few seconds because of the PAM delay.

>   userdb:
>     driver: passwd
>   userdb:
>     driver: sql
>     args: /etc/dovecot/dovecot-sql.conf
..
> password_query = SELECT username AS user, password, '/drbd/mail/vmail/%d/%n' AS userdb_home, 'maildir:/drbd/mail/vmail/%d/%n' AS userdb_mail, 5001 AS userdb_uid, 5001 AS userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'

You're also not using userdb prefetch, so all these usedb_* fields are
ignored here.

> (...)
> user_query = SELECT '/drbd/mail/vmail/%d/%n' AS home, 'maildir:/drbd/mail/vmail/%d/%n' AS mail, 5001 AS uid, 5001 AS gid, concat('*:storage=', quota, 'B') AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1'

This looks correct.

Looks like you already have mail_debug=yes and auth_debug=yes. What does
Dovecot log when user logs in and sees wrong quota?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20090627/85042b1f/attachment.bin