<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>It should work, I have to check why it's not working.<br>
</p>
<p>Aki<br>
</p>
<p>On 16.11.2018 11.47, <a class="moz-txt-link-abbreviated" href="mailto:SUnsin@gv-bayern.de">SUnsin@gv-bayern.de</a> wrote:</p>
<blockquote type="cite"
cite="mid:OF54B71221.877886F8-ONC1258347.00348878-C1258347.0035CE12@LocalDomain">
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
<p><font size="2" face="Arial">With quota count and quota_clone it
works, but can I use noenforcing with quota count?</font><br>
<br>
<font size="2" face="Arial">quota = count:User quota:noenforcing</font><br>
<br>
<font size="2" face="Arial">When I test this config, I receive
no quota-warning E-Mail:</font><br>
<br>
<font size="2" face="Arial">service quota-warning {</font><br>
<font size="2" face="Arial"> executable = script
/usr/local/bin/quota-warning.sh</font><br>
<font size="2" face="Arial"># user = dovecot</font><br>
<font size="2" face="Arial"> user = vmail</font><br>
<font size="2" face="Arial"> unix_listener quota-warning {</font><br>
<font size="2" face="Arial"> user = vmail</font><br>
<font size="2" face="Arial"> group = vmail</font><br>
<font size="2" face="Arial"> mode = 0660</font><br>
<font size="2" face="Arial"> }</font><br>
<font size="2" face="Arial">}</font><br>
<font size="2" face="Arial">plugin {</font><br>
<font size="2" face="Arial"> quota_warning = storage=95%%
quota-warning 95 %u</font><br>
<font size="2" face="Arial"> quota_warning2 = storage=80%%
quota-warning 80 %u</font><br>
<font size="2" face="Arial">}</font><br>
<br>
<font size="2" face="Arial">I wouldn´t like reject an E-Mail
although des quota ist over the limit.</font><br>
<br>
</p>
<ul style="padding-left: 0pt">
<font size="2" face="Arial">Stephan</font>
</ul>
<br>
<img src="cid:part1.DE929651.F1DE01A3@open-xchange.com"
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" class="" width="16" height="16"
border="0"><font size="2" face="sans-serif" color="#424282">"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><br>
<br>
<font size="1" face="sans-serif" color="#5F5F5F">Von: </font><font
size="1" face="sans-serif">"Aki Tuomi"
<a class="moz-txt-link-rfc2396E" href="mailto:aki.tuomi@open-xchange.com"><aki.tuomi@open-xchange.com></a></font><br>
<font size="1" face="sans-serif" color="#5F5F5F">An: </font><font
size="1" face="sans-serif">"Dovecot Mailing List"
<a class="moz-txt-link-rfc2396E" href="mailto:dovecot@dovecot.org"><dovecot@dovecot.org></a>, <a class="moz-txt-link-abbreviated" href="mailto:SUnsin@gv-bayern.de">SUnsin@gv-bayern.de</a></font><br>
<font size="1" face="sans-serif" color="#5F5F5F">Datum: </font><font
size="1" face="sans-serif">15.11.2018 20:15</font><br>
<font size="1" face="sans-serif" color="#5F5F5F">Betreff: </font><font
size="1" face="sans-serif">Re: Quota in MySql Dict not
recalculate automatic</font><br>
<hr style="color:#8091A5; " width="100%" size="2"
noshade="noshade" align="left"><br>
<br>
<br>
<tt><font size="2">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 <a class="moz-txt-link-abbreviated" href="mailto:SUnsin@gv-bayern.de">SUnsin@gv-bayern.de</a> 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: <a class="moz-txt-link-abbreviated" href="mailto:SUnsin@gv-bayern.de">SUnsin@gv-bayern.de</a><br>
> Notes-E-Mail: Stephan Unsin@GVB<br>
> <br>
> </font></tt><tt><font size="2"><a
href="http://www.gv-bayern.de" moz-do-not-send="true">http://www.gv-bayern.de</a></font></tt><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.<br>
</font></tt><br>
<br>
<br>
<br>
</blockquote>
</body>
</html>