我试图configurationdovecot来处理配额限制。
我遵循指南并configuration了正确的步骤。 我甚至比较他们与我们目前的邮件服务器。
问题是，Dovecot不写入数据库中的quota2表。 我已经检查了两个mysql日志和maillog文件（dovecot日志位置），但是我没有看到有关配额的任何错误。 所有其他查询工作完美。 用户表中的配额也被提取。
有人有线索吗？ 我错过了什么？
Dovecot -n输出：
# 2.0.9: /etc/dovecot/dovecot.conf # OS: Linux 3.14.35-28.38.amzn1.x86_64 x86_64 ext4 auth_mechanisms = plain login dict { quotadict = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } mail_location = maildir:/var/spool/mail/virtual/%d/%n mail_plugins = quota mail_privileged_group = mail mbox_write_locks = fcntl passdb { args = /etc/dovecot/conf.d/dovecot-sql.conf.ext driver = sql } plugin { quota = dict:user::proxy::quotadict } service auth-worker { user = vmail } service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0666 user = postfix } unix_listener auth-userdb { mode = 0600 user = vmail } user = dovecot } service imap-login { inet_listener imap { port = 143 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } } ssl_ca = </root/ssl/root-cert.pem ssl_cert = </root/ssl/private-cert.pem ssl_key = </root/ssl/private-key.pem userdb { args = /etc/dovecot/conf.d/dovecot-sql.conf.ext driver = sql } protocol lda { mail_plugins = quota } protocol imap { mail_plugins = quota imap_quota imap_quota } protocol pop3 { mail_plugins = quota pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } dovecot的-sql.conf.ext：
password_query = SELECT email as user, password FROM users WHERE email='%u'; user_query = \ SELECT CONCAT('/var/spool/mail/virtual/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/', \ SUBSTRING_INDEX(email,'@',1))) AS home, \ 5001 AS uid, \ 5001 AS gid, \ CONCAT('maildir:storage=',quota) AS quota \ FROM users WHERE email='%u' \ AND enabled = '1';
的dovecot / dovecot的快译通，sql.conf.ext：
map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages }
更新：
日志文件（不含amavis）
May 8 10:03:47 host dovecot: master: Warning: Killed with signal 15 (by pid=18369 uid=0 code=kill) May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=9721/22462 May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=4471/11038 May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=4663/11356 May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=8663/23549 May 8 10:03:48 host dovecot: master: Dovecot v2.0.9 starting up (core dumps disabled) May 8 10:03:48 host dovecot: ssl-params: Generating SSL parameters May 8 10:03:50 host dovecot: ssl-params: SSL parameters regeneration completed May 8 10:03:55 host dovecot: auth: mysql: Connected to 127.0.0.1 (mail) May 8 10:04:47 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18399, TLS May 8 10:04:47 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:47 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:47 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:47 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:47 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:47 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:47 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:49 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18402, TLS May 8 10:04:49 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:49 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:49 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:49 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:49 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:49 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:49 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:51 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18404, TLS May 8 10:04:51 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:51 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:51 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:51 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:51 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, May 8 10:03:47 host dovecot: master: Warning: Killed with signal 15 (by pid=18369 uid=0 code=kill) May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=9721/22462 May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=4471/11038 May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=4663/11356 May 8 10:03:47 host dovecot: imap: Server shutting down. bytes=8663/23549 May 8 10:03:48 host dovecot: master: Dovecot v2.0.9 starting up (core dumps disabled) May 8 10:03:48 host dovecot: ssl-params: Generating SSL parameters May 8 10:03:50 host dovecot: ssl-params: SSL parameters regeneration completed May 8 10:03:55 host dovecot: auth: mysql: Connected to 127.0.0.1 (mail) May 8 10:04:47 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18399, TLS May 8 10:04:47 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:47 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:47 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:47 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:47 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:47 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:47 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:49 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18402, TLS May 8 10:04:49 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:49 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:49 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:49 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:49 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:49 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:49 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:51 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18404, TLS May 8 10:04:51 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:51 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:51 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:51 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:51 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:51 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:51 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:53 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18406, TLS May 8 10:04:53 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:53 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:53 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:53 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:53 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:53 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:53 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:06:06 host dovecot: lmtp(18427): Debug: none: root=, index=, control=, inbox= May 8 10:06:06 host dovecot: lmtp(18427): Connect from local May 8 10:06:06 host dovecot: lmtp(18427): Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:06:06 host dovecot: lmtp(18427): Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:06:06 host dovecot: lmtp(18427): Debug: auth input: [email protected] home=/var/spool/mail/virtual/jouwweb.email/test uid=5001 gid=5001 quota=maildir:storage=10 May 8 10:06:06 host dovecot: lmtp(18427): Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): 9nRZJ46KTFX7RwAAx8Xrpw: msgid=<[email protected]>: saved mail to INBOX May 8 10:06:06 host dovecot: lmtp(18427): Disconnect from local: Client quit May 8 10:04:51 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:51 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:53 host dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=80.113.202.232, lip=172.31.18.109, mpid=18406, TLS May 8 10:04:53 host dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:04:53 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:04:53 host dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so May 8 10:04:53 host dovecot: imap: Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:04:53 host dovecot: imap([email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:04:53 host dovecot: imap([email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:04:53 host dovecot: imap([email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:06:06 host dovecot: lmtp(18427): Debug: none: root=, index=, control=, inbox= May 8 10:06:06 host dovecot: lmtp(18427): Connect from local May 8 10:06:06 host dovecot: lmtp(18427): Debug: Loading modules from directory: /usr/lib64/dovecot May 8 10:06:06 host dovecot: lmtp(18427): Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so May 8 10:06:06 host dovecot: lmtp(18427): Debug: auth input: [email protected] home=/var/spool/mail/virtual/jouwweb.email/test uid=5001 gid=5001 quota=maildir:storage=10 May 8 10:06:06 host dovecot: lmtp(18427): Debug: Added userdb setting: plugin/quota=maildir:storage=10 May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): Debug: Effective uid=5001, gid=5001, home=/var/spool/mail/virtual/jouwweb.email/test May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): Debug: Quota root: name=storage=10 backend=maildir args= May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): Debug: maildir++: root=/var/spool/mail/virtual/jouwweb.email/test, index=, control=, inbox=/var/spool/mail/virtual/jouwweb.email/test May 8 10:06:06 host dovecot: lmtp(18427, [email protected]): 9nRZJ46KTFX7RwAAx8Xrpw: msgid=<[email protected]>: saved mail to INBOX May 8 10:06:06 host dovecot: lmtp(18427): Disconnect from local: Client quit
如果您对amavis包含的日志感兴趣，请查看下面的要点文件： https : //gist.github.com/jordi12100/f14842f724d62a47c570
更新2（感谢Fox）：配额正在更新。 但是，当我超过我的限制，邮件似乎并没有阻止。 目前的限制是10kb，在我发送了几条消息后我超过了。 缺less任何设置？
基于比较你的configuration和我的一点猜测。
CONCAT('maildir:storage=',quota) AS quota应该是CONCAT('maildir:storage=',quota) AS quota_rule
我想你是从configuration覆盖quota=设置，按用户条目。 （但我不是专家，所以真的只是一个猜测）
不记得为什么，但我的配额查询concat('*:storage=', quota) as quota_rule ，应该以某种方式帮助…
编辑：我认为它被交付，因为你正在使用lmtp，但没有为lmtp启用配额。 你需要像我这样的东西：
protocol lmtp { mail_plugins = quota fts fts_solr sieve }