hi all :
mysql mailbox below :
CREATE TABLE `mailbox` (
`username` varchar(255) NOT NULL DEFAULT '',
`uid` varchar(255) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`clearpwd` varchar(128) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`mailhost` varchar(255) NOT NULL DEFAULT '',
`maildir` varchar(255) NOT NULL DEFAULT '',
`homedir` varchar(255) NOT NULL DEFAULT '',
`quota` varchar(16) NOT NULL DEFAULT '0',
`netdiskquota` varchar(16) NOT NULL DEFAULT '0',
`domain` varchar(255) NOT NULL DEFAULT '',
`uidnumber` int(6) NOT NULL DEFAULT '1000',
`gidnumber` int(6) NOT NULL DEFAULT '1000',
`createdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`expiredate` date NOT NULL DEFAULT '0000-00-00',
`active` smallint(1) NOT NULL DEFAULT '1',
`disablepwdchange` smallint(1) DEFAULT NULL,
`disablesmtpd` smallint(1) DEFAULT NULL,
`disablesmtp` smallint(1) DEFAULT NULL,
`disablewebmail` smallint(1) DEFAULT NULL,
`disablenetdisk` smallint(1) DEFAULT NULL,
`disableimap` smallint(1) DEFAULT NULL,
`disablepop3` smallint(1) DEFAULT NULL,
`question` text NOT NULL,
`answer` text NOT NULL,
PRIMARY KEY (`username`),
KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ExtMail - Virtual
Mailboxes'
dovecot config below :
root at mail:/etc/dovecot# dovecot -n
# 1.2.15: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-5-686 i686 Debian 6.0.5 ext3
log_path: /var/log/dovecot.log
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imap imaps pop3 pop3s managesieve
listen(default): *
listen(imap): *
listen(pop3): *
listen(managesieve): *:2000
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
login_executable(managesieve): /usr/lib/dovecot/managesieve-login
mail_privileged_group: mail
mail_uid: vuser
mail_gid: vgroup
mail_location: maildir:/home/data/domains/%d/%n/Maildir
mail_debug: yes
mbox_write_locks: fcntl dotlock
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_executable(managesieve): /usr/lib/dovecot/managesieve
mail_plugins(default): quota
mail_plugins(imap): quota
mail_plugins(pop3): quota
mail_plugins(managesieve):
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve
managesieve_logout_format(default): bytes=%i/%o
managesieve_logout_format(imap): bytes=%i/%o
managesieve_logout_format(pop3): bytes=%i/%o
managesieve_logout_format(managesieve): bytes(in=%i/out=%o)
lda:
postmaster_address: fy at 5dshu.com
mail_plugins: sieve quota
mail_plugin_dir: /usr/lib/dovecot/modules/lda
auth_socket_path: /var/run/dovecot/auth-master
auth default:
mechanisms: plain login
verbose: yes
debug: yes
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
socket:
type: listen
client:
path: /var/spool/postfix/private/auth
mode: 384
user: postfix
group: postfix
master:
path: /var/run/dovecot/auth-master
mode: 384
user: vuser
group: vgroup
plugin:
quota: dict:user::proxy::quota
sieve_dir: /home/data/domains/%d/%n/sieve
sieve: /home/data/domains/%d/%n/.dovecot.sieve
dict:
quota: mysql:/etc/dovecot/dovecot-dict-sql.conf
/etc/dovecot/dovecot-dict-sql.conf file :
connect = host=localhost dbname=extmail user=root password=bamwei
map {
pattern = priv/quota/storage
table = mailbox
username_field = username
value_field =quota
}
map {
pattern = priv/quota/messages
table = mailbox
username_field = username
value_field = uid
}
in the dovecot-sql.conf:
user_query= SELECT homedir AS home, maildir, uidnumber AS uid, gidnumber AS gid
,CONCAT( '*:storage=', quota, 'B' ) AS quota_rule FROM mailbox
WHERE username ='%u'
password_query= SELECT username,domain,password,homedir AS home, maildir,
uidnumber AS uid, gidnumber AS gid, CONCAT( '*:storage=', quota,
'B' ) AS userdb_quota_rule FROM mailbox WHERE username ='%u'
when is seting quota_rule=*:storage=10M:messages=1000 in plugin quote, all user
get 10MB quota.
when i comment it .quota no enable .
i see the http://wiki1.dovecot.org/Quota/Dict ,but unknow to get Correct
setup...thanks !
fy
