<div dir="ltr"><div>Hi Users, </div><div><br></div><div>I have set up amavisd ( amavis-2.12.1-5.el8.noarch ) on ALmaLinux 8 with mariadb 10.11.</div><div><br></div><div>I have referred to the below url.  </div><div><br></div><div><a href="http://gogs.info/books/debian-mail/chunked/antispam.amavis.html" target="_blank">http://gogs.info/books/debian-mail/chunked/antispam.amavis.html</a><br></div><div><br></div><div>I have used below lines in <span class="gmail-file-title-name gmail-mr-1 gmail-js-blob-header-filepath" style="box-sizing:border-box;font-variant-ligatures:none;color:rgb(51,50,56);font-family:"GitLab Sans",-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,"Noto Sans",Ubuntu,Cantarell,"Helvetica Neue",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:14px;background-color:rgb(251,250,253);margin-right:0.25rem">amavisd-new-schema.sql</span><span style="font-family:inherit">file. </span></div><div><br></div><div><pre class="gmail-code gmail-highlight" lang="sql"><span id="gmail-LC174" lang="sql" class="gmail-line"><span class="gmail-hljs-keyword">INSERT</span><span class="gmail-"> </span><span class="gmail-hljs-keyword">INTO</span><span class="gmail-"> policy (id, policy_name,</span></span>
<span id="gmail-LC175" lang="sql" class="gmail-line"><span class="gmail-">  virus_lover, spam_lover, banned_files_lover, bad_header_lover,</span></span>
<span id="gmail-LC176" lang="sql" class="gmail-line"><span class="gmail-">  bypass_virus_checks, bypass_spam_checks,</span></span>
<span id="gmail-LC177" lang="sql" class="gmail-line"><span class="gmail-">  bypass_banned_checks, bypass_header_checks, spam_modifies_subj,</span></span>
<span id="gmail-LC178" lang="sql" class="gmail-line"><span class="gmail-">  spam_tag_level, spam_tag2_level, spam_kill_level) </span><span class="gmail-hljs-keyword">VALUES</span><span class="gmail-"></span></span>
<span id="gmail-LC179" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">1</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Non-paying'</span><span class="gmail-">,    </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">3.0</span><span class="gmail-">,   </span><span class="gmail-hljs-number">7</span><span class="gmail-">, </span><span class="gmail-hljs-number">10</span><span class="gmail-">),</span></span>
<span id="gmail-LC180" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">2</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Uncensored'</span><span class="gmail-">,    </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-number">3.0</span><span class="gmail-">, </span><span class="gmail-hljs-number">999</span><span class="gmail-">, </span><span class="gmail-hljs-number">999</span><span class="gmail-">),</span></span>
<span id="gmail-LC181" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">3</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Wants all spam'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">3.0</span><span class="gmail-">, </span><span class="gmail-hljs-number">999</span><span class="gmail-">, </span><span class="gmail-hljs-number">999</span><span class="gmail-">),</span></span>
<span id="gmail-LC182" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">4</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Wants viruses'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">3.0</span><span class="gmail-">, </span><span class="gmail-hljs-number">6.9</span><span class="gmail-">, </span><span class="gmail-hljs-number">6.9</span><span class="gmail-">),</span></span>
<span id="gmail-LC183" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">5</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Normal'</span><span class="gmail-">,        </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">-999</span><span class="gmail-">, </span><span class="gmail-hljs-number">6.2</span><span class="gmail-">, </span><span class="gmail-hljs-number">6.6</span><span class="gmail-">),</span></span>
<span id="gmail-LC184" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">6</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Trigger happy'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">3.0</span><span class="gmail-">,   </span><span class="gmail-hljs-number">5</span><span class="gmail-">, </span><span class="gmail-hljs-number">5</span><span class="gmail-">),</span></span>
<span id="gmail-LC185" lang="sql" class="gmail-line"><span class="gmail-">  (</span><span class="gmail-hljs-number">7</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Permissive'</span><span class="gmail-">,    </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">3.0</span><span class="gmail-">,  </span><span class="gmail-hljs-number">10</span><span class="gmail-">, </span><span class="gmail-hljs-number">20</span><span class="gmail-">);</span></span>
<span id="gmail-LC186" lang="sql" class="gmail-line"></span>
</pre></div><div><div>Please pay attention to this line.</div><div><pre class="gmail-code gmail-highlight" lang="sql"><span id="gmail-LC183" lang="sql" class="gmail-line"><span class="gmail-">(</span><span class="gmail-hljs-number">5</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Normal'</span><span class="gmail-">,        </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">,</span><span class="gmail-hljs-string">'N'</span><span class="gmail-">, </span><span class="gmail-hljs-string">'Y'</span><span class="gmail-">, </span><span class="gmail-hljs-number">-999</span><span class="gmail-">, </span><span class="gmail-hljs-number">6.2</span><span class="gmail-">, </span><span class="gmail-hljs-number">6.6</span><span class="gmail-">),</span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><br></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><font face="arial, sans-serif">I have added the below line as well.</font></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><code>INSERT INTO users VALUES ( NULL, 5, 5, '@</code></span></span><a href="mailto:no-reply@mydomain.net" target="_blank" style="font-family:Arial,Helvetica,sans-serif;white-space:normal">mydomain.net</a>',      NULL, 'Y');</pre><pre class="gmail-code gmail-highlight" lang="sql"><br></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><font face="arial, sans-serif">According to this, spam kill level is 6.6. But, When I send mails, they will be quarantined whenever it gets "HITS" with a PLUS score.  </font></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><font face="arial, sans-serif">Please see the log below</font>. <font face="arial, sans-serif">this has </font></span></span><font face="arial, sans-serif">Hits: 2.144 ( i.e  - it is a PLUS Score )</font></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><span style="font-family:Arial,Helvetica,sans-serif;white-space:normal">Sep 25 07:33:12 mailgw amavis[60390]: (60390-07) Blocked SPAM {DiscardedInbound,Quarantined}</span><span style="font-family:Arial,Helvetica,sans-serif;white-space:normal">, [127.0.0.1] /ESMTP <</span><a href="mailto:no-reply@mydomain.net" target="_blank" style="font-family:Arial,Helvetica,sans-serif;white-space:normal">no-reply@mydomain.net</a><span style="font-family:Arial,Helvetica,sans-serif;white-space:normal">> -> <</span><a href="mailto:admin@mydomain.net" target="_blank" style="font-family:Arial,Helvetica,sans-serif;white-space:normal">admin@mydomain.net</a><span style="font-family:Arial,Helvetica,sans-serif;white-space:normal">>, </span><span style="font-family:Arial,Helvetica,sans-serif;white-space:normal">(), quarantine: KHruPy38ggLj, Message-ID: <</span><a href="mailto:20230925053311.2A54812@mailgw.mydomain.net" target="_blank" style="font-family:Arial,Helvetica,sans-serif;white-space:normal">20230925053311.2A54812@mailgw.mydomain.net</a><span style="font-family:Arial,Helvetica,sans-serif;white-space:normal">>, mail_id: KHruPy38ggLj, b: _cfhJXAG_, Hits: 2.144, size: 862,</span></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span style="font-family:Arial,Helvetica,sans-serif"><br></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span style="font-family:Arial,Helvetica,sans-serif">Note:  Anyway I have used the same settings on CentOS 7 with </span><font face="arial, sans-serif">amavis-2.12.0-10.el7.noarch rpm where MariaDB-server-10.4.17-1.el7.centos.x86_64 rpm is installed.</font></pre><pre class="gmail-code gmail-highlight" lang="sql"><font face="arial, sans-serif">It works fine there. </font></pre><pre class="gmail-code gmail-highlight" lang="sql"><font face="arial, sans-serif">Could you please come up with your ideas? </font></pre><pre class="gmail-code gmail-highlight" lang="sql"><br></pre><pre class="gmail-code gmail-highlight" lang="sql"><br></pre><pre class="gmail-code gmail-highlight" lang="sql"><br></pre><pre class="gmail-code gmail-highlight" lang="sql"><br></pre><pre class="gmail-code gmail-highlight" lang="sql">  </pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><br></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><br></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><br></span></span></pre><pre class="gmail-code gmail-highlight" lang="sql"><span lang="sql" class="gmail-line"><span class="gmail-"><br></span></span></pre></div></div><div><br></div><div><br></div><div>Sep 25 07:33:12 mailgw amavis[60390]: (60390-07) Blocked SPAM {DiscardedInbound,Quarantined}, [127.0.0.1] /ESMTP <<a href="mailto:no-reply@mydomain.net" target="_blank">no-reply@mydomain.net</a>> -> <<a href="mailto:admin@mydomain.net" target="_blank">admin@mydomain.net</a>>,<br>(), quarantine: KHruPy38ggLj, Message-ID: <<a href="mailto:20230925053311.2A54812@mailgw.mydomain.net" target="_blank">20230925053311.2A54812@mailgw.mydomain.net</a>>, mail_id: KHruPy38ggLj, b: _cfhJXAG_, Hits: 2.144, size: 862,<br></div><div><br></div><div><br></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr">cat /etc/motd<br><br>Thank you<br>Indunil Jayasooriya <br><a href="http://www.theravadanet.net/" target="_blank">http://www.theravadanet.net/</a><br><br></div></div></div></div></div>