[Dovecot] Dict quota negative values in MySql table?

michael at lattari.pl michael at lattari.pl
Sat Jan 24 14:00:36 EET 2009


Hi!

I have a question about the dictionary quota :storage and :messages
values in MySql quota table.
How to interpret the following values? Why some values are negative? Are
the values relative to something? 
I would like to write a simple php application to check the user quota
but I don't know how to interpret this:

mysql> select * from quota;
+------------------------+----------------+-------------+
| username               | path           | current     |
+------------------------+----------------+-------------+
| mlattari               | quota/storage  |       -6976 | 
| mlattari               | quota/messages |          -3 | 
| llattari               | quota/storage  | -2147483648 | 
| llattari               | quota/messages |        -874 | 
| mlattari_archivum_imap | quota/storage  |      282475 | 
| mlattari_archivum_imap | quota/messages |           5 | 
+------------------------+----------------+-------------+
6 rows in set (0.00 sec)

pls help :-)

dovecot -n
# 1.1.8: /etc/dovecot/etc/dovecot.conf
# OS: Linux 2.6.22.14-72.fc6 x86_64 Fedora Core release 6 (Zod) ext3
base_dir: /etc/dovecot/var/run/dovecot/
log_path: /etc/dovecot/var/log/dovecot_log
info_log_path: /etc/dovecot/var/log/dovecot_log
protocols: imaps
ssl_cert_file: /etc/pki/dovecot/server.crt
ssl_key_file: /etc/pki/dovecot/server.key
ssl_cipher_list: ALL:!ADH!LOW:!SSLv2:!EXP:+HIGH:+MEDIUM
verbose_ssl: yes
login_dir: /etc/dovecot/var/run/dovecot/login
login_executable: /etc/dovecot/libexec/dovecot/imap-login
login_user: dovecot_login
mail_privileged_group: mail
mail_uid: 507
mail_gid: 507
mail_location: mbox:/home/%u/mail:INBOX=/home/spool/mail/%u
mail_plugins: expire quota imap_quota trash
auth default:
  mechanisms: plain login
  debug: yes
  passdb:
    driver: passwd-file
    args: /etc/dovecot/etc/passwd.dovecot
  socket:
    type: listen
    master:
      path: /etc/dovecot/var/run/dovecot/auth-master
      mode: 384
      user: mail
plugin:
  quota: dict:user::proxy::quotadict
  quota_rule: *:storage=5G:messages=2000
  quota_rule2: Trash:storage=1G:messages=1000
  trash: /etc/dovecot/etc/dovecot-trash.conf
  expire: Trash 7 Spam 7 INBOX 180 Sent 180
  auth_socket_path: /etc/dovecot/var/run/dovecot/auth-master
  expire_dict: proxy::expire
dict:
  quotadict: mysql:/etc/dovecot/etc/dovecot-dict-quota.conf
  expire: mysql:/etc/dovecot/etc/dovecot-dict-expire.conf



Best regards

michael



More information about the dovecot mailing list