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.
PGP.sig
Description: This is a digitally signed message part
