[Dovecot] quota ignore trash
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: 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.
participants (2)
-
JC
-
Timo Sirainen