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@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@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