[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