Hi
A have a problem with quota2 table, working under postfixadmin. When I login into imap server with thunderbird client everything works fine, quota is update when i receive a message, but when I move message to trash or any other folder value for messages field in table quota2 increases +1 instead decreases or have still this same value. Only if I close my imap client value descending -2. I wish to table quota2 will be updated immediately after any operation on inbox. Is there any mistake in my configuration?
Thanks for any advice.
============================================================== dovecot -n print:
# 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-xen-686 i686 Debian 6.0.3 ext3 log_path: /var/log/dovecot/error.log info_log_path: /var/log/dovecot/info.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3 pop3s 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 first_valid_uid: 100 mail_privileged_group: Debian-exim mail_uid: 101 mail_gid: 103 mail_location: maildir:/var/mail/virtual/%d/%n/Maildir mail_cache_min_mail_count: 100 mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/rawlog /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/rawlog /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): autocreate quota imap_quota trash mail_plugins(imap): autocreate quota imap_quota trash 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): tb-extra-mailbox-sep imap_client_workarounds(imap): tb-extra-mailbox-sep imap_client_workarounds(pop3): imap_id_log(default): * imap_id_log(imap): * imap_id_log(pop3): lda: postmaster_address: postmaster@mydomain.com mail_plugins: quota log_path: /var/log/dovecot/lda-errors.log info_log_path: /var/log/dovecot/deliver.log auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen master: path: /var/run/dovecot/auth-master mode: 384 user: Debian-exim plugin: autocreate: INBOX autocreate2: Sent autocreate3: Trash autocreate4: Drafts autocreate5: Junk autocreate6: Spam autosubscribe: INBOX autosubscribe2: Sent autosubscribe3: Trash autosubscribe4: Drafts autosubscribe5: Junk autosubscribe6: Spam quota: dict:user::proxy::quotadict quota_rule: Trash:storage=+20%% quota_rule2: Spam:ignore quota_rule3: Drafts:storage=+5%% quota_rule4: Sent:storage=+15%% quota_rule5: Junk:storage=+10%% quota_warning: storage=100%% quota-exceeded 100 %u quota_warning2: storage=95%% quota-warning 95 %u quota_warning3: storage=90%% quota-warning 90 %u quota_warning4: storage=85%% quota-warning 85 %u quota_warning5: storage=80%% quota-warning 80 %u quota_warning6: storage=75%% quota-warning 75 %u quota_warning7: storage=70%% quota-warning 70 %u quota_warning8: storage=65%% quota-warning 65 %u trash: /etc/dovecot/dovecot-trash.conf mail_log_events: delete undelete expunge copy mailbox_delete mailbox_rename flag_change append mail_log_group_events: no mail_log_fields: uid box msgid size subject from dict: quotadict: mysql:/etc/dovecot/dovecot-dict-quota.conf
============================================= cat /etc/dovecot/dovecot-sql.conf
driver = mysql
connect = host=localhost dbname=eximdb user=eximdbadm password=*************
default_pass_scheme = PLAIN
password_query =
SELECT username as user, domain, password
FROM mailbox WHERE username= '%u' AND active = 1
user_query =
SELECT CONCAT('/var/mail/virtual/', maildir) AS home, 101 AS
uid, 103 AS gid, concat('dict:storage=', CAST(ROUND(quota / 1024) AS
CHAR), '::proxy::quotadict') AS quota, CONCAT('*:storage=', CAST(quota
AS CHAR), 'B') AS quota_rule FROM mailbox WHERE username = '%u' AND
active = '1'
============================================= cat /etc/dovecot/dovecot-dict-quota.conf
connect = host=localhost dbname=eximdb user=eximdbadm password=********* map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages }
============================================== cat /etc/dovecot/dovecot-trash.conf
1 Trash 2 Spam 3 Sent 4 Draft