Hi everybody, I have a server works good but the quota calculation includes trash, what i have to do in order to ignore trash in quota calculation? My server imap is dovecot 1.0, my smtp server is postfix 2.3.8-2 and my webmail is horde 3.1.3 and imp 4.1.3. my dovecot.conf : base_dir: /var/run/dovecot/ log_path: /var/log/mail.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: pop3 imap disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login login_process_size: 64 login_processes_count: 5 login_max_processes_count: 256 login_max_connections: 512 first_valid_uid: 5000 last_valid_uid: 5000 first_valid_gid: 5000 mail_extra_groups: vmail mail_location: maildir:/home/vmail/%d/%n maildir_copy_with_hardlinks: yes maildir_copy_preserve_filename: yes mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): quota trash imap_quota mail_plugins(imap): quota trash imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): outlook-idle pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xu%08Xv pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh namespace: type: private separator: . prefix: INBOX. inbox: yes auth default: mechanisms: plain login user: vmail passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: vmail master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: vmail plugin: quota: maildir:storage=10240:messages=1000:ignore=Trash trash: /etc/dovecot/dovecot-trash.conf my dovecot-sql.conf : 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' 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'
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: prefetchYour 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. -------------- next part -------------- A non-text attachment was scrubbed... Name: PGP.sig Type: application/pgp-signature Size: 186 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20070923/27cb0f11/attachment-0002.bin>