On 23.9.2007, at 20.09, JC wrote:
passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch
Your prefetch userdb is after userdb sql, which means that it's never
used.
password_query = SELECT email AS user, password, '/home/vmail/%d/% n' AS userdb_home, 'maildir:/home/vmail/%d/%n' AS userdb_mail, 5000 AS
userdb_uid, 5000 AS userdb_gid FROM users WHERE email = '%u'
So these userdb_* fields here are pointless. If you moved prefetch
before sql, it would be used. But if you do that, you'll have to make
password_query return also userdb_quota field.
user_query = SELECT '/home/vmail/%d/%n' AS home, 'maildir:/home/ vmail/%d/%n' AS mail, 5000 AS uid, 5000 AS gid, CONCAT('maildir:storage=', ROUND (quota/1000) ) AS quota FROM users WHERE email = '%u'
Since you're returning quota here, it overrides completely what you
have in plugin {}. So make the quota field returned by this SQL
lookup include the :ignore=Trash.