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'
