Hi,

I’m currently try to use the dovecot quota plugin.

I use the maildir plugin ,and use mysql as to get the quota rule.

Question is:

Sometimes dovecot only count in the size of INBOX ,without other (I use imap to create some mailbox),while,sometimes it count in all.

I don’t know if there’s anything wrong with my configure.

Here is the configure of my dovecot.

Thank u!

...

...

...

...

...

>>>>>>>>>>>>>>>--------dovecot setting-------------<<<<<<<<<<<<<<<<<<<<<<<

# 1.1.13: /etc/dovecot.conf

# OS: Linux 2.6.9-67.0.7.EL i686 CentOS release 4.6 (Final) ext3

base_dir: /var/run/dovecot/

log_path: /var/log/dovecot.log

protocols: imap pop3

login_dir: /var/run/dovecot/login

login_executable(default): /usr/libexec/dovecot/imap-login

login_executable(imap): /usr/libexec/dovecot/imap-login

login_executable(pop3): /usr/libexec/dovecot/pop3-login

login_greeting: Dovecot Ready

mail_location: maildir:/home/mail/%u/

mail_executable(default): /usr/libexec/dovecot/imap

mail_executable(imap): /usr/libexec/dovecot/imap

mail_executable(pop3): /usr/libexec/dovecot/pop3

mail_plugins(default): quota imap_quota

mail_plugins(imap): quota imap_quota

mail_plugins(pop3): quota

mail_plugin_dir(default): /usr/lib/dovecot/imap

mail_plugin_dir(imap): /usr/lib/dovecot/imap

mail_plugin_dir(pop3): /usr/lib/dovecot/pop3

auth default:

passdb:

driver: sql

args: /etc/dovecot-mysql.conf

userdb:

driver: sql

args: /etc/dovecot-mysql.conf

socket:

type: listen

client:

  path: /var/run/dovecot/auth-client

  mode: 432

master:

  path: /var/run/dovecot/auth-master

  mode: 438

  user: dovecot

  group: dovecot

plugin:

quota: maildir:User quota

quota_warning: storage=80%% /home/guojinpeng/quota-warning.sh 80

dict:

quota: mysql:/etc/dovecot-dict-quota.conf

...

...

...

...

...

>>>>>>>>>>>>>>>>>>>>>>>>>>>>end<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

# cat /etc/dovecot-mysql.conf

driver = mysql

connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=postfix

default_pass_scheme = CRYPT

#password_query = SELECT password FROM mailbox WHERE username = '%u'

#user_query = SELECT maildir, 506 AS uid, 508 AS gid FROM mailbox WHERE username = '%u'

user_query = select maildir,506 as uid, 508 as gid, \

concat('*:storage=', quota ,'B') as quota_rule \

from mailbox where username = '%u'

password_query = select username as user, password, \

506 as userdb_uid, 508 as userdb_gid, \

concat('*:storage=', quota ,'B') as userdb_quota_rule \

from mailbox where username = '%u'