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