<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Hi,</div><div id="AppleMailSignature"><br></div><div id="AppleMailSignature">führ dsync so aus: <span style="background-color: rgba(255, 255, 255, 0);">dsync <span class="pre" style="box-sizing: border-box;">-o</span> plugin/quota=</span></div><div id="AppleMailSignature"><br><div style="direction: inherit;">Beste Grüße </div><div style="direction: inherit;">André </div></div><div><br>Am 08.04.2017 um 07:53 schrieb Klaus Tachtler <<a href="mailto:klaus@tachtler.net">klaus@tachtler.net</a>>:<br><br></div><blockquote type="cite"><div><span>Hallo Liste,</span><br><span></span><br><span>ich habe im Dovecot konfiguriert, dass dieser die Quota-Berechnung in eine SQL-Datenbank schreibt, was auch alles wunderbar funktioniert!</span><br><span></span><br><span>Wie ich das gemacht habe, siehe hier in meinem DokuWiki, welches ich für mich erstellt habe:</span><br><span>---> <a href="https://dokuwiki.tachtler.net/doku.php?id=tachtler:dovecot_quotas_-_sql-backend">https://dokuwiki.tachtler.net/doku.php?id=tachtler:dovecot_quotas_-_sql-backend</a></span><br><span></span><br><span>+--------------------+</span><br><span>| Jetzt zum PROBLEM: | ---></span><br><span>+--------------------+</span><br><span></span><br><span>Als ich mich heute morgen in meinem E-Mail Programm (MUA) angemeldet habe, sah ich, dass der Speicherverbrauch bei 18% lag - doppelt so viel wie gestern Abend, wo es nur 9% waren.</span><br><span></span><br><span># doveadm quota get -u <a href="mailto:klaus@tachtler.net">klaus@tachtler.net</a></span><br><span>Quota name Type Value Limit %</span><br><span>User Quota STORAGE 181898 1000000 18</span><br><span>User Quota MESSAGE 5270 - 0</span><br><span></span><br><span>Nach einer erzwungenen Neuberechnung mit:</span><br><span></span><br><span># doveadm quota recalc -u <a href="mailto:klaus@tachtler.net">klaus@tachtler.net</a></span><br><span></span><br><span>bekam ich dann wieder mein "erwartetes" Ergebnis:</span><br><span></span><br><span># doveadm quota get -u <a href="mailto:klaus@tachtler.net">klaus@tachtler.net</a></span><br><span>Quota name Type Value Limit %</span><br><span>User Quota STORAGE 91357 1000000 9</span><br><span>User Quota MESSAGE 2639 - 0</span><br><span></span><br><span>Hat jemand eine Idee, oder einen Tipp, was da beim dovecot passiert sein könnte?</span><br><span></span><br><span>Evtl. hat es eine Auswirkung, das ich in der Nacht eine Sicherung aller Postfächer, wie hier nachfolgend beschrieben</span><br><span>---> <a href="https://dokuwiki.tachtler.net/doku.php?id=tachtler:dovecot_backup_-_skript">https://dokuwiki.tachtler.net/doku.php?id=tachtler:dovecot_backup_-_skript</a></span><br><span>bzw.</span><br><span>---> <a href="https://github.com/tachtler/dovecot-backup">https://github.com/tachtler/dovecot-backup</a></span><br><span>durchführe?</span><br><span></span><br><span>Vielen Dank für einen Tipp bzw. Eure Hilfe schon in Voraus!</span><br><span></span><br><span></span><br><span>Grüße</span><br><span>Klaus.</span><br><span></span><br><span>Anbei noch: doveconf -n</span><br><span>=======================</span><br><span></span><br><span># doveconf -n</span><br><span># 2.2.28 (bed8434): /etc/dovecot/dovecot.conf</span><br><span># Pigeonhole version 0.4.17 (e179378)</span><br><span># OS: Linux 3.10.0-514.10.2.el7.x86_64 x86_64 CentOS Linux release 7.3.1611 (Core)</span><br><span>auth_master_user_separator = *</span><br><span>auth_mechanisms = plain digest-md5 cram-md5 login</span><br><span>auth_verbose = yes</span><br><span>dict {</span><br><span> sqldomainquota = mysql:/etc/dovecot/dovecot-sql-domain.conf.ext</span><br><span> sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext</span><br><span>}</span><br><span>hostname = <a href="http://imap-server.tachtler.net">imap-server.tachtler.net</a></span><br><span>listen = *</span><br><span>mail_location = maildir:~/Maildir</span><br><span>mail_plugins = " quota acl zlib mail_log notify"</span><br><span>managesieve_notify_capability = mailto</span><br><span>managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext</span><br><span>mbox_write_locks = fcntl</span><br><span>namespace {</span><br><span> list = children</span><br><span> location = maildir:%%h/Maildir:INDEX=%h/shared/%%u:CONTROL=%h/shared/%%u</span><br><span> prefix = shared/%%u/</span><br><span> separator = /</span><br><span> subscriptions = yes</span><br><span> type = shared</span><br><span>}</span><br><span>namespace inbox {</span><br><span> inbox = yes</span><br><span> location =</span><br><span> mailbox Drafts {</span><br><span> auto = subscribe</span><br><span> special_use = \Drafts</span><br><span> }</span><br><span> mailbox Junk {</span><br><span> auto = subscribe</span><br><span> special_use = \Junk</span><br><span> }</span><br><span> mailbox Sent {</span><br><span> auto = subscribe</span><br><span> special_use = \Sent</span><br><span> }</span><br><span> mailbox "Sent Messages" {</span><br><span> special_use = \Sent</span><br><span> }</span><br><span> mailbox Trash {</span><br><span> auto = subscribe</span><br><span> special_use = \Trash</span><br><span> }</span><br><span> prefix = INBOX/</span><br><span> separator = /</span><br><span>}</span><br><span>passdb {</span><br><span> args = /etc/dovecot/master-users</span><br><span> driver = passwd-file</span><br><span> master = yes</span><br><span> pass = yes</span><br><span>}</span><br><span>passdb {</span><br><span> args = /etc/dovecot/dovecot-sql.conf.ext</span><br><span> driver = sql</span><br><span>}</span><br><span>plugin {</span><br><span> acl = vfile</span><br><span> acl_shared_dict = file:/var/lib/dovecot/db/shared-mailboxes.db</span><br><span> mail_log_fields = uid box msgid size from</span><br><span> quota = dict:User Quota::proxy::sqluserquota</span><br><span> quota2_rule = Trash:storage=+10%%</span><br><span> quota_grace = 10%%</span><br><span> quota_rule = *:storage=1G</span><br><span> quota_rule2 = INBOX/Trash:storage=+100M</span><br><span> quota_status_nouser = DUNNO</span><br><span> quota_status_overquota = 552 5.2.2 Mailbox is over quota</span><br><span> quota_status_success = DUNNO</span><br><span> quota_warning = storage=95%% quota-warning 95 %u</span><br><span> quota_warning2 = storage=80%% quota-warning 80 %u</span><br><span> sieve = file:~/sieve;active=~/.dovecot.sieve</span><br><span> zlib_save = gz</span><br><span> zlib_save_level = 6</span><br><span>}</span><br><span>postmaster_address = <a href="mailto:postmaster@tachtler.net">postmaster@tachtler.net</a></span><br><span>protocols = imap lmtp sieve</span><br><span>service auth {</span><br><span> unix_listener auth-userdb {</span><br><span> group = vmail</span><br><span> user = vmail</span><br><span> }</span><br><span>}</span><br><span>service dict {</span><br><span> unix_listener dict {</span><br><span> group = vmail</span><br><span> mode = 0660</span><br><span> user = vmail</span><br><span> }</span><br><span>}</span><br><span>service imap-login {</span><br><span> process_min_avail = 1</span><br><span> service_count = 0</span><br><span>}</span><br><span>service lmtp {</span><br><span> inet_listener lmtp {</span><br><span> address = 192.168.0.80</span><br><span> port = 24</span><br><span> }</span><br><span>}</span><br><span>service managesieve-login {</span><br><span> inet_listener sieve {</span><br><span> address = 192.168.0.80</span><br><span> port = 4190</span><br><span> }</span><br><span>}</span><br><span>service quota-status {</span><br><span> client_limit = 1</span><br><span> executable = quota-status -p postfix</span><br><span> inet_listener {</span><br><span> address = 192.168.0.80</span><br><span> port = 12340</span><br><span> }</span><br><span>}</span><br><span>service quota-warning {</span><br><span> executable = script /usr/local/bin/quota-warning.sh</span><br><span> unix_listener quota-warning {</span><br><span> user = vmail</span><br><span> }</span><br><span> user = vmail</span><br><span>}</span><br><span>ssl = required</span><br><span>ssl_cert = </etc/pki/dovecot/certs/cert_all_in_one.crt</span><br><span>ssl_cipher_list = ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA</span><br><span>ssl_dh_parameters_length = 2048</span><br><span>ssl_key = # hidden, use -P to show it</span><br><span>ssl_prefer_server_ciphers = yes</span><br><span>ssl_protocols = !SSLv2 !SSLv3</span><br><span>userdb {</span><br><span> driver = prefetch</span><br><span>}</span><br><span>userdb {</span><br><span> args = /etc/dovecot/dovecot-sql.conf.ext</span><br><span> driver = sql</span><br><span>}</span><br><span>verbose_proctitle = yes</span><br><span>protocol lmtp {</span><br><span> mail_plugins = " quota acl zlib mail_log notify sieve"</span><br><span>}</span><br><span>protocol imap {</span><br><span> mail_max_userip_connections = 50</span><br><span> mail_plugins = " quota acl zlib mail_log notify imap_quota imap_acl imap_zlib"</span><br><span>}</span><br><span>protocol sieve {</span><br><span> mail_max_userip_connections = 50</span><br><span>}</span><br><span></span><br></div></blockquote><blockquote type="cite"><div><mime-attachment></div></blockquote></body></html>