{"id":6405,"date":"2023-01-06T16:50:38","date_gmt":"2023-01-06T07:50:38","guid":{"rendered":"https:\/\/www.lancard.com\/blog\/?p=6405"},"modified":"2025-03-12T11:25:24","modified_gmt":"2025-03-12T02:25:24","slug":"dovecot-quota-sql","status":"publish","type":"post","link":"https:\/\/www.lancard.com\/blog\/2023\/01\/06\/dovecot-quota-sql\/","title":{"rendered":"Dovecot\u306eQuota\u3092SQL\u3067\u500b\u5225\u306b\u8a2d\u5b9a"},"content":{"rendered":"\n<a href=\"https:\/\/www.lancard.com\/blog\/2023\/01\/04\/sql-dovecot-postfix\/\" data-type=\"URL\" data-id=\"https:\/\/www.lancard.com\/blog\/2023\/01\/04\/sql-dovecot-postfix\/\">\u524d\u56de\u306e\u6295\u7a3f <\/a> \u306b\u30af\u30a9\u30fc\u30bf\u3092\u52a0\u3048\u3066\u3001\u500b\u4eba\u5225\u306b\u5bb9\u91cf\u3092\u5236\u9650\u51fa\u6765\u308b\u3088\u3046\u306b\u3057\u3066\u307f\u307e\u3059\u3002\n\n\n\n<!--more-->\n\n\n\n\u203b\u4f7f\u7528\u3057\u305fDovecot\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f2.3.16\u3067\u3057\u305f\u30022.2.19\u4ee5\u964d\u3067\u3042\u308c\u3070\u6050\u3089\u304f\u8a2d\u5b9a\u3092\u305d\u306e\u307e\u307e\u4f7f\u3048\u308b\u3068\u601d\u3044\u307e\u3059\u3002\n\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n\n\n\n\n\n\u307e\u305a\u306f\u3001\u5168\u54e1\u5171\u901a\u306e\u8a2d\u5b9a\u304c\u51fa\u6765\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\n\n\n\n\n<h2 class=\"wp-block-heading\">Dovecot\u8a2d\u5b9a<\/h2>\n\n\n\n\n\n<ul class=\"wp-block-list\">\n<li>\/etc\/dovecot\/conf.d\/10-mail.conf<\/li>\n<\/ul>\n\n\n\n\n\n<pre class=\"wp-block-code\"><code>mail_plugins = $mail_plugins quota<\/code><\/pre>\n\n\n\n\n\n<ul class=\"wp-block-list\">\n<li>\/etc\/dovecot\/conf.d\/20-imap.conf<\/li>\n<\/ul>\n\n\n\n\n\n<pre class=\"wp-block-code\"><code>protocol imap{\n   mail_plugins = $mail_plugins imap_quota\n   # ...\n}<\/code><\/pre>\n\n\n\n\n\n<ul class=\"wp-block-list\">\n<li>\/etc\/dovecot\/conf.d\/90-quota.conf<\/li>\n<\/ul>\n\n\n\n\n\n<pre class=\"wp-block-code\"><code>plugin {\n  quota_rule = *:storage=100M\n  # res postfix\n  quota_status_success = DUNNO\n  quota_status_nouser = DUNNO\n  quota_status_overquota = \"552 5.2.2 Mailbox is full\"\n}\n\n# ...\n\n# backend\nplugin{\n  quota_vsizes = yes\n  quota = count:User quota\n}\n# for postfix\nservice quota-status {\n  executable = quota-status -p postfix\n  inet_listener {\n    port = 12340\n    # You can choose any port you want\n  }\n  client_limit = 1\n}<\/code><\/pre>\n\n\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\nquota_status_*\u3068service quota-status\u306fPostfix\u7528\u306e\u8a2d\u5b9a\u3067\u3001Dovecot 2.2\u304b\u3089\u306fPostfix\u7528\u30dd\u30ea\u30b7\u30fc\u30b5\u30fc\u30d3\u30b9\u3092\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u3001Postfix\u306fDovecot\u306bquota\u306e\u304a\u4f3a\u3044\u3092\u7acb\u3066\u308b\u3060\u3051\u3067\u826f\u3044\u3088\u3046\u3067\u3059\u3002\n\n\n\n<a href=\"https:\/\/blog.sys4.de\/postfix-dovecot-mailbox-quota-en.html\">https:\/\/blog.sys4.de\/postfix-dovecot-mailbox-quota-en.html<\/a>\n<\/div>\n<\/div>\n\n\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u306b\u306f2.2.19\u304b\u3089count\u304c\u8ffd\u52a0\u3055\u308c\u3001\u65b0\u898f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u306fcount\u3092\u4f7f\u3046\u4e8b\u3092\u63a8\u5968\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u306e\u3067count\u3092\u4f7f\u3044\u307e\u3059\u3002<br><a href=\"https:\/\/doc.dovecot.org\/configuration_manual\/quota_plugin\/\">https:\/\/doc.dovecot.org\/configuration_manual\/quota_plugin\/<\/a>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Postfix\u8a2d\u5b9a<\/h2>\n\n\n\n\n\n<ul class=\"wp-block-list\">\n<li>\/etc\/postfix\/main.cf<\/li>\n<\/ul>\n\n\n\n\n\n<pre class=\"wp-block-code\"><code>smtpd_recipient_restrictions = check_policy_service inet:127.0.0.1:12340<\/code><\/pre>\n\n\n\n\n\u3053\u308c\u3067Postfix\u306f\u9001\u4fe1\u524d\u306bDovecot\u3078\u304a\u4f3a\u3044\u3092\u7acb\u3066\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\n\n\n\n\u3053\u3053\u307e\u3067\u306e\u8a2d\u5b9a\u3067\u3001\u5168\u54e1\u304c100MB\u306e\u5bb9\u91cf\u5236\u9650\u3092\u8a2d\u5b9a\u3055\u308c\u307e\u3057\u305f\u3002\n\n\n\nDovecot\u3068Postfix\u3092\u30ea\u30ed\u30fc\u30c9\u3057\u3066RoundCube\u3067\u898b\u308b\u3068\u3001\u78ba\u304b\u306b100MB\u306e\u5236\u9650\u304c\u5165\u3063\u3066\u3044\u307e\u3059\u3002\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.lancard.com\/blog\/wp-content\/uploads\/2023\/01\/c1264e036d4214689a739c1d2298a0ea.png\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"88\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/uploads\/2023\/01\/c1264e036d4214689a739c1d2298a0ea.png\" alt=\"\" class=\"wp-image-6426\"\/><\/a><\/figure>\n\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n\n\u6b21\u306f\u500b\u4eba\u3054\u3068\u306e\u8a2d\u5b9a\u3067\u3059\u3002\n\n\n\n\n<h2 class=\"wp-block-heading\">PostgreSQL<\/h2>\n\n\n\n\npsql\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067\u30af\u30a9\u30fc\u30bf\u7528\u30ab\u30e9\u30e0\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\n\n\n\n\u53d6\u308a\u5408\u3048\u305a\u7d30\u304b\u3044\u5bb9\u91cf\u8a2d\u5b9a\u306f\u5fc5\u8981\u7121\u3044\u306e\u3067quota_mb\u3068\u3057\u3066\u3001MB\u5358\u4f4d\u3067\u306e\u5165\u529b\u306b\u3057\u3066\u304a\u304d\u307e\u3059\u3002\n\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE mail_users ADD quota_mb integer DEFAULT 100;\nDROP VIEW user_view;\nCREATE VIEW user_view AS SELECT *,\n    name||'@'||domain AS mail,\n    '\/var\/mail\/vhosts\/'||domain||'\/'||name AS dovecot_home,\n    domain||'\/'||name||'\/Maildir\/' AS maildir,\n    '*:storage='||quota_mb||'M' AS quota_rule\n    FROM mail_users;<\/code><\/pre>\n\n\n\n\nuser_view\u306bquota_rule\u3092\u8ffd\u52a0\u3059\u308b\u4e8b\u3067\u3001\u524d\u56de\u306edovecot-sql.conf.ext\u306a\u3089quota_rule\u3092\u500b\u5225\u306b\u9069\u7528\u3057\u3066\u304f\u308c\u307e\u3059\u3002\n\n\n\nDovecot\u3092\u30ea\u30ed\u30fc\u30c9\u3057\u3066quota_mb\u306e\u5024\u309210\u306bUPDATE\u3057\u3066\u307f\u308b\u3068\u3001RoundCube\u308210MB\u306b\u66f4\u65b0\u3055\u308c\u3066\u3044\u307e\u3059\uff08UPDATE\u3059\u308b\u305f\u3073\u306b\u5024\u304c\u5909\u308f\u308b\u306e\u3067\u3001\u7d50\u69cb\u697d\u3057\u3044\u3067\u3059\uff09\u3002\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.lancard.com\/blog\/wp-content\/uploads\/2023\/01\/d40b7791f7b035957b1b6cb2df213e87.png\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"101\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/uploads\/2023\/01\/d40b7791f7b035957b1b6cb2df213e87.png\" alt=\"\" class=\"wp-image-6427\"\/><\/a><\/figure>\n\n\n\ndoveadm user\u3067\u308210MB\u306b\u306a\u3063\u3066\u3044\u308b\u4e8b\u304c\u78ba\u8a8d\u51fa\u6765\u307e\u3059\u3002\n\n\n\n\u3053\u3053\u3067\u81ea\u5206\u5b9b\u306b\u9001\u3063\u306610MB\u5bb9\u91cf\u3044\u3063\u3071\u3044\u306b\u3057\u3066\u304b\u3089\u9001\u4fe1\u3092\u3059\u308b\u3068\u3001\u9001\u4fe1\u6642\u306b\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u3001\u9001\u4fe1\u51fa\u6765\u306a\u3044\u4e8b\u304c\u78ba\u8a8d\u51fa\u6765\u307e\u3057\u305f\u3002\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.lancard.com\/blog\/wp-content\/uploads\/2023\/01\/6e24b9bac51c7f1cd873622eb4b1392c.png\"><img loading=\"lazy\" decoding=\"async\" width=\"326\" height=\"133\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/uploads\/2023\/01\/6e24b9bac51c7f1cd873622eb4b1392c.png\" alt=\"\" class=\"wp-image-6428\"\/><\/a><\/figure>\n\n\n\n\u3053\u308c\u3067\u5168\u4f53\u306e100MB\u3067\u306a\u304f\u3001\u3061\u3083\u3093\u3068\u500b\u5225\u306e10MB\u3067\u5236\u9650\u3055\u308c\u3066\u3044\u308b\u4e8b\u304c\u78ba\u8a8d\u51fa\u6765\u307e\u3057\u305f\u3002\n\n\n\n\n\n\n\n\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-facebook nolightbox\" data-provider=\"facebook\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6405&#038;t=Dovecot%E3%81%AEQuota%E3%82%92SQL%E3%81%A7%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%AD%E5%AE%9A&#038;s=100&#038;p&#091;url&#093;=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6405&#038;p&#091;images&#093;&#091;0&#093;=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-content%2Fuploads%2F2023%2F01%2Fc1264e036d4214689a739c1d2298a0ea.png&#038;p&#091;title&#093;=Dovecot%E3%81%AEQuota%E3%82%92SQL%E3%81%A7%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%AD%E5%AE%9A\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"Facebook\" title=\"Share on Facebook\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/facebook.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"http:\/\/twitter.com\/share?url=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6405&#038;text=Dovecot%E3%81%AEQuota%E3%82%92SQL%E3%81%A7%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%AD%E5%AE%9A\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6405&#038;title=Dovecot%E3%81%AEQuota%E3%82%92SQL%E3%81%A7%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%AD%E5%AE%9A\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-tumblr nolightbox\" data-provider=\"tumblr\" target=\"_blank\" rel=\"nofollow\" title=\"Share on tumblr\" href=\"https:\/\/tumblr.com\/share?s=&#038;v=3&#038;t=Dovecot%E3%81%AEQuota%E3%82%92SQL%E3%81%A7%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%AD%E5%AE%9A&#038;u=https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6405\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"tumblr\" title=\"Share on tumblr\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/tumblr.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Dovecot%E3%81%AEQuota%E3%82%92SQL%E3%81%A7%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%AD%E5%AE%9A&#038;body=%E3%82%B7%E3%82%A7%E3%82%A2%E3%81%99%E3%82%8B%EF%BC%9A:%20https%3A%2F%2Fwww.lancard.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6405\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.lancard.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>\u524d\u56de\u306e\u6295\u7a3f \u306b\u30af\u30a9\u30fc\u30bf\u3092\u52a0\u3048\u3066\u3001\u500b\u4eba\u5225\u306b\u5bb9\u91cf\u3092\u5236\u9650\u51fa\u6765\u308b\u3088\u3046\u306b\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[210,211,212],"class_list":["post-6405","post","type-post","status-publish","format-standard","hentry","category-1","tag-dovecot","tag-postfix","tag-quota"],"_links":{"self":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts\/6405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/comments?post=6405"}],"version-history":[{"count":21,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts\/6405\/revisions"}],"predecessor-version":[{"id":6448,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/posts\/6405\/revisions\/6448"}],"wp:attachment":[{"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/media?parent=6405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/categories?post=6405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lancard.com\/blog\/wp-json\/wp\/v2\/tags?post=6405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}