More information about - Dovecot 2.2.x quota mysql and dict
Simon
semfly at gmail.com
Sat Oct 17 10:29:28 UTC 2015
Thanks for your answer, Timo! :)
I send to you my configoration for reproducing.
Please, follow the link, because configuration is a very big, there will be
more easy to read and understand
My configuration Dovecot 2.2.19 <http://www.heypasteit.com/clip/28CW>
Below the same my configuration Dovecot 2.2.19 here.
BEGIN of configuration
---------------------
# doveconf -n
# 2.2.19: /usr/local/etc/dovecot/dovecot.conf
# OS: FreeBSD 10.2-RELEASE amd64 ufs
auth_debug = yes
auth_debug_passwords = yes
auth_mechanisms = plain login cram-md5
auth_verbose = yes
base_dir = /var/run/dovecot/
first_valid_gid = 1983
first_valid_uid = 1983
listen = *
log_path = /var/log/dovecot.log
mail_debug = yes
mail_gid = virtual
mail_location = maildir:/var/spool/mail/%d/%u
mail_uid = virtual
passdb {
args = /usr/local/etc/dovecot/dovecot-sql.conf
driver = sql
}
dict {
sqluserquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-user.conf
sqldomainquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-domain.conf
}
plugin {
quota = dict:domain_quota:%d:proxy::sqldomainquota
quota2 = dict:user_quota::proxy::sqluserquota
quota2_rule2 = Trash:storage=+20%%
quota2_rule3 = Junk:storage=+20%%
quota2_grace = 10%%
quota2_warning = storage=100%% quota-exceeded 100 %u
quota2_warning2 = storage=95%% quota-warning 95 %u
quota2_warning3 = storage=90%% quota-warning 90 %u
quota2_warning4 = storage=75%% quota-warning 75 %u
}
service quota-warning {
executable = script /usr/local/etc/dovecot/quota_warning.sh
unix_listener quota-warning {
mode = 0660
user = virtual
}
}
protocols = imap pop3
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
}
unix_listener auth-master {
group = virtual
mode = 0660
user = virtual
}
unix_listener auth-userdb {
group = virtual
mode = 0660
user = virtual
}
}
service dict {
unix_listener dict {
mode = 0660
user = virtual
}
}
service imap-login {
client_limit = 256
inet_listener imap {
address = *
port = 143
}
inet_listener imaps {
address = *
port = 993
}
process_limit = 64
process_min_avail = 8
service_count = 1
}
service pop3-login {
inet_listener pop3 {
address = *
port = 110
}
inet_listener pop3s {
address = *
port = 995
}
}
ssl_cert = </usr/local/etc/postfix/cert.pem
ssl_key = </usr/local/etc/postfix/key.pem
ssl_parameters_regenerate = 1 hours
ssl_require_crl = no
userdb {
args = /usr/local/etc/dovecot/dovecot-sql.conf
driver = sql
}
verbose_proctitle = yes
verbose_ssl = yes
protocol imap {
imap_client_workarounds = delay-newmail tb-lsub-flags tb-extra-mailbox-sep
imap_idle_notify_interval = 2 mins
mail_max_userip_connections = 10
mail_plugin_dir = /usr/local/lib/dovecot
mail_plugins = " quota imap_quota"
quota_full_tempfail = yes
}
protocol pop3 {
pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
pop3_uidl_format = %08Xu%08Xv
}
protocol lda {
auth_socket_path = /var/run/dovecot/auth-master
hostname = mydomain.lan
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
lda_original_recipient_header =
mail_plugins = " quota"
postmaster_address = postmaster at mydomain.lan
}
--------------------------
-= END of dovecot.conf =-
-------------------------------------------------------------------------
# cat dovecot-sql.conf | grep -v ^# | grep -v ^$
driver = mysql
connect = host=localhost dbname=postfix user=postfix password=mypassword
default_pass_scheme = CRAM-MD5
password_query = SELECT username, domain, password \
FROM mailbox WHERE username = '%u' and domain = '%d' and active='1' \
user_query = SELECT '/var/spool/mail/%d/%u' AS home, \
'maildir:/var/spool/mail/%d/%u' AS mail, 1983 AS uid, 1983 AS gid, \
CONCAT('*:bytes=', domain.maxquota*1048576) AS quota_rule, \
CONCAT('*:bytes=', mailbox.quota) AS quota2_rule \
FROM mailbox, domain WHERE username = '%u' AND mailbox.active = '1' \
AND domain.domain = '%d' AND domain.active = '1'
-------------------------------------------------------------------------
# cat dovecot-dict-sql-domain.conf
connect = host=localhost dbname=postfix user=postfix password=mypassword
map {
pattern = priv/quota/storage
table = domain
username_field = domain
value_field = quota
}
map {
pattern = priv/quota/messages
table = quota2
username_field = username
value_field = messages
}
-------------------------------------------------------------------------
# cat dovecot-dict-sql-user.conf
connect = host=localhost dbname=postfix user=postfix password=mypassword
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
}
-------------------------
-= END of configuration =-
-------------------------
If need anymore about configuration, please write me.
Today I can respond quickly.
--
View this message in context: http://dovecot.2317879.n4.nabble.com/More-information-about-Dovecot-2-2-x-quota-mysql-and-dict-tp54077p54189.html
Sent from the Dovecot mailing list archive at Nabble.com.
More information about the dovecot
mailing list