More information about - Dovecot 2.2.x quota mysql and dict

[Simon]

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.