<html><body bgcolor="#FFFFFF"><p><font size="2" face="Arial">I have tested it on my old Installation with dovecot Version 2.2.22 and it works.</font><br><br><font size="2" face="Arial">When I set</font><font size="2" face="Arial"> </font><font size="2" face="Arial">"quota = count:User quota:noenforcing", I receive E-Mails also over the quota an get the warning E-Mails.</font><br><br><font size="2" face="Arial">When I remove nonenforcing, I get the warning E-Mails and the received E-Mails where bounced/rejected over the quota.</font><br><br><font size="2" face="Arial">It looks like a Bug in the dovecot Version 2.2.33?</font><br>
<ul style="padding-left: 0pt"><font size="2" face="Arial">Stephan</font><br></ul><br><img width="16" height="16" src="cid:1__=4EBB09D9DFAA61F58f9e8a93df9@gv-bayern.de" border="0" alt="Inaktiv: Details verbergen für "Aki Tuomi" ---16.11.2018 11:02:43---It should work, I have to check why it's not working. Aki"><font size="2" color="#424282" face="sans-serif">"Aki Tuomi" ---16.11.2018 11:02:43---It should work, I have to check why it's not working. Aki</font><br><br><font size="1" color="#5F5F5F" face="sans-serif">Von: </font><font size="1" face="sans-serif">"Aki Tuomi" <aki.tuomi@open-xchange.com></font><br><font size="1" color="#5F5F5F" face="sans-serif">An: </font><font size="1" face="sans-serif">"Dovecot Mailing List" <dovecot@dovecot.org>, SUnsin@gv-bayern.de</font><br><font size="1" color="#5F5F5F" face="sans-serif">Datum: </font><font size="1" face="sans-serif">16.11.2018 11:02</font><br><font size="1" color="#5F5F5F" face="sans-serif">Betreff: </font><font size="1" face="sans-serif">Re: Antwort: Re: Quota in MySql Dict not recalculate automatic</font><br><hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br><br><br><font size="3" face="serif">It should work, I have to check why it's not working.</font><p><font size="3" face="serif">Aki</font><p><font size="3" face="serif">On 16.11.2018 11.47, </font><a href="mailto:SUnsin@gv-bayern.de"><font size="3" color="#0000FF" face="serif"><u>SUnsin@gv-bayern.de</u></font></a><font size="3" face="serif"> wrote:</font><ul style="padding-left: 36pt"><br><font size="2" face="Arial">With quota count and quota_clone it works, but can I use noenforcing with quota count?</font><font size="3" face="serif"><br></font><font size="2" face="Arial"><br>quota = count:User quota:noenforcing</font><font size="3" face="serif"><br></font><font size="2" face="Arial"><br>When I test this config, I receive no quota-warning E-Mail:</font><font size="3" face="serif"><br></font><font size="2" face="Arial"><br>service quota-warning {<br> executable = script /usr/local/bin/quota-warning.sh<br># user = dovecot<br> user = vmail<br> unix_listener quota-warning {<br> user = vmail<br> group = vmail<br> mode = 0660<br> }<br>}<br>plugin {<br>quota_warning = storage=95%% quota-warning 95 %u<br>quota_warning2 = storage=80%% quota-warning 80 %u<br>}</font><font size="3" face="serif"><br></font><font size="2" face="Arial"><br>I wouldn´t like reject an E-Mail although des quota ist over the limit.</font><font size="3" face="serif"><br></font><ul style="padding-left: 36pt"><br><font size="2" face="Arial">Stephan</font><font size="3" face="serif"> </font></ul><font size="3" face="serif"><br></font><img src="cid:1__=4EBB09D9DFAA61F58f9e8a93df9@gv-bayern.de" width="16" height="16" alt="Inaktiv: Details verbergen für "Aki Tuomi"
---15.11.2018 20:15:48---dict quota is known to have this
problem that it is not alw"><font size="2" color="#424282" face="sans-serif">"Aki Tuomi" ---15.11.2018 20:15:48---dict quota is known to have this problem that it is not always updated on time. You should use quota</font><font size="3" face="serif"><br></font><font size="1" color="#5F5F5F" face="sans-serif"><br>Von: </font><font size="1" face="sans-serif">"Aki Tuomi" </font><a href="mailto:aki.tuomi@open-xchange.com"><font size="1" color="#0000FF" face="sans-serif"><u><aki.tuomi@open-xchange.com></u></font></a><font size="1" color="#5F5F5F" face="sans-serif"><br>An: </font><font size="1" face="sans-serif">"Dovecot Mailing List" </font><a href="mailto:dovecot@dovecot.org"><font size="1" color="#0000FF" face="sans-serif"><u><dovecot@dovecot.org></u></font></a><font size="1" face="sans-serif">, </font><a href="mailto:SUnsin@gv-bayern.de"><font size="1" color="#0000FF" face="sans-serif"><u>SUnsin@gv-bayern.de</u></font></a><font size="1" color="#5F5F5F" face="sans-serif"><br>Datum: </font><font size="1" face="sans-serif">15.11.2018 20:15</font><font size="1" color="#5F5F5F" face="sans-serif"><br>Betreff: </font><font size="1" face="sans-serif">Re: Quota in MySql Dict not recalculate automatic</font><font size="3" face="serif"><br></font><hr width="100%" size="2" align="left" noshade><font size="3" face="serif"><br><br></font><tt><font size="2"><br>dict quota is known to have this problem that it is not always updated on time. You should use quota count with quota_clone plugin instead (might require upgrade).<br><br>Please remember to change password for mysql user pfadmin, as you accidentically sent it to the list.<br><br>Aki<br><br>> On 15 November 2018 at 20:52 </font></tt><a href="mailto:SUnsin@gv-bayern.de"><tt><font size="2" color="#0000FF"><u>SUnsin@gv-bayern.de</u></font></tt></a><tt><font size="2"> wrote:<br>> <br>> <br>> <br>> <br>> Hi,<br>> <br>> I have a working Installation with:<br>> Ubuntu 16.04 LTS<br>> Dovecot 2.2.22<br>> MySql 5.7.24<br>> Postfixadmin 3.2<br>> Apache 2.4.18<br>> Rainloop 1.12.1<br>> <br>> I manage the E-Mail Accounts with postfixadmin in a MySql-DB.<br>> Also I use quotas with Quota Backend postfixadmin-DB (dict).<br>> Everything works fine.<br>> <br>> Now I installed a new Server with the following Versions and<br>> migrate the Configs to the new System.<br>> Ubuntu 18.04 LTS<br>> Doveot 2.2.33<br>> MySQL 5.7.24<br>> Postfixadmin 3.2<br>> Apache 2.4.18<br>> Rainloop 1.12.1<br>> <br>> The Problem is now: When I receive a E-Mail, the quota will not<br>> Update (recalculate) automatical in the MySql-DB from Dovecot.<br>> <br>> In the old System there execute the SQL Statement after receiving a E-Mail,<br>> for example:<br>> UPDATE quota2 SET bytes=bytes+3076,messages=messages+1 WHERE username =<br>> <E-Mail Address><br>> <br>> On the new System with the newer Dovecot Version, the Statement never comes<br>> after<br>> receive an E-Mail.<br>> <br>> With Dovecot Version 2.3 on the old System with Ubuntu 16.04, everything<br>> works fine<br>> with the same config.<br>> <br>> Is a BUG in the Dovecot Version 2.2.33 possible?<br>> Can everbody help me?<br>> <br>> Kind regards<br>> Stephan<br>> <br>> <br>> dovecot -n<br>> # 2.2.33.2 (d6601f4ec): /etc/dovecot/dovecot.conf<br>> # Pigeonhole version 0.4.21 (92477967)<br>> # OS: Linux 4.15.0-39-generic x86_64 Ubuntu 18.04.1 LTS<br>> auth_debug = yes<br>> auth_debug_passwords = yes<br>> auth_master_user_separator = *<br>> auth_mechanisms = plain login<br>> auth_verbose_passwords = yes<br>> dict {<br>> sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext<br>> sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext<br>> }<br>> disable_plaintext_auth = no<br>> login_greeting = Dovecot ready.<br>> mail_debug = yes<br>> mail_location = maildir:~/Maildir<br>> mail_plugins = " quota"<br>> managesieve_notify_capability = mailto<br>> managesieve_sieve_capability = fileinto reject envelope encoded-character<br>> vacation subaddress comparator-i;ascii-numeric relational regex imap4flags<br>> copy include variables body enotify environment mailbox date index ihave<br>> duplicate mime foreverypart extracttext<br>> namespace inbox {<br>> inbox = yes<br>> location =<br>> mailbox Drafts {<br>> special_use = \Drafts<br>> }<br>> mailbox Junk {<br>> special_use = \Junk<br>> }<br>> mailbox Sent {<br>> special_use = \Sent<br>> }<br>> mailbox "Sent Messages" {<br>> special_use = \Sent<br>> }<br>> mailbox Trash {<br>> special_use = \Trash<br>> }<br>> prefix =<br>> separator = /<br>> }<br>> passdb {<br>> args = /etc/dovecot/master-users<br>> driver = passwd-file<br>> master = yes<br>> pass = yes<br>> }<br>> passdb {<br>> args = /etc/dovecot/dovecot-sql.conf.ext<br>> driver = sql<br>> }<br>> plugin {<br>> quota = dict:User Quota::noenforcing:proxy::sqluserquota<br>> quota_grace = 10%%<br>> quota_status_nouser = DUNNO<br>> quota_status_overquota = 552 5.2.2 Mailbox is over quota / Mailbox ist<br>> voll<br>> quota_status_success = DUNNO<br>> quota_warning = storage=95%% quota-warning 95 %u<br>> quota_warning2 = storage=80%% quota-warning 80 %u<br>> }<br>> postmaster_address = postmaster@xxx<br>> protocols = " imap lmtp sieve pop3 sieve"<br>> service auth {<br>> unix_listener /var/spool/postfix/private/auth {<br>> group = postfix<br>> mode = 0666<br>> user = postfix<br>> }<br>> }<br>> service dict {<br>> unix_listener dict {<br>> group = vmail<br>> mode = 0660<br>> user = vmail<br>> }<br>> }<br>> service lmtp {<br>> inet_listener lmtp {<br>> address = localhost<br>> port = 24<br>> }<br>> }<br>> service managesieve-login {<br>> inet_listener sieve {<br>> port = 4190<br>> }<br>> }<br>> service quota-status {<br>> client_limit = 1<br>> executable = quota-status -p postfix<br>> inet_listener {<br>> port = 12340<br>> }<br>> }<br>> service quota-warning {<br>> executable = script /usr/local/bin/quota-warning.sh<br>> unix_listener quota-warning {<br>> group = vmail<br>> mode = 0660<br>> user = vmail<br>> }<br>> user = vmail<br>> }<br>> ssl_cert = xxx<br>> ssl_key = # hidden, use -P to show it<br>> userdb {<br>> driver = prefetch<br>> }<br>> userdb {<br>> args = /etc/dovecot/dovecot-sql.conf.ext<br>> driver = sql<br>> }<br>> protocol lmtp {<br>> mail_plugins = " quota"<br>> }<br>> protocol imap {<br>> mail_max_userip_connections = 10<br>> mail_plugins = " quota imap_quota"<br>> }<br>> <br>> <br>> <br>> <br>> grep -v '^ *\(#.*\)\?$' dovecot-sql.conf :<br>> <br>> driver = mysql<br>> connect = host=localhost dbname=postfixadmin user=pfadmin<br>> password=xxx<br>> default_pass_scheme = SHA512-CRYPT<br>> password_query = \<br>> SELECT username as user, password, '/var/vmail/%Ld/%Ln' as userdb_home, \<br>> 'maildir:/var/vmail/%Ld/%Ln' as userdb_mail, 5000 as userdb_uid, 5000 as<br>> userdb_gid \<br>> FROM mailbox WHERE username = '%Lu' AND active = '1'<br>> user_query = \<br>> SELECT '/var/vmail/%Ld/%Ln' as home, \<br>> 'maildir:/var/vmail/%Ld/%Ln' as mail, \<br>> 5000 AS uid, \<br>> 5000 AS gid, \<br>> concat('*:bytes=', \<br>> if(mailbox.quota = 0, domain.maxquota*1024000, mailbox.quota)) \<br>> as quota_rule \<br>> FROM mailbox, domain \<br>> WHERE username = '%Lu' AND mailbox.active = '1' AND \<br>> domain.domain = '%d' AND domain.active = '1'<br>> iterate_query = SELECT username as user FROM mailbox WHERE active = '1'<br>> <br>> Ref. Systeme / Bereich Digitalisierung und Informationstechnik (IT)<br>> Telefon: 089 2868-3280<br>> Telefax: 089 2868-3275<br>> Internet-E-Mail: </font></tt><a href="mailto:SUnsin@gv-bayern.de"><tt><font size="2" color="#0000FF"><u>SUnsin@gv-bayern.de</u></font></tt></a><tt><font size="2"><br>> Notes-E-Mail: Stephan Unsin@GVB<br>> <br>> </font></tt><a href="http://www.gv-bayern.de/"><tt><font size="2" color="#0000FF"><u>http://www.gv-bayern.de</u></font></tt></a><tt><font size="2"><br>> <br>> Genossenschaftsverband Bayern e.V.<br>> Türkenstrasse 22-24, 80333 München<br>> <br>> Es gelten die jeweils aktuellen Allgemeinen Auftragsbedingungen des<br>> Genossenschaftsverbands Bayern e.V.</font></tt><font size="3" face="serif"><br><br><br><br></font><br><br></ul><BR>
<BR>
</body></html>