Re: Question for reputation stuff

From: Christian Rößner <c_at_roessner-network-solutions.com>
Date: Mon, 8 Sep 2014 10:53:50 +0200

Hi,

sorry if I come back again, but I still have no solution for my problem. Currently I also had private mail conversation with Andreas Schulze (Danke dir noch mal), but the problem still exists.

Am 07.08.2014 um 18:02 schrieb Christian Rößner <c_at_roessner-network-solutions.com>:

> Hi,
>
> I have enabled support for reputation stuff in opendkim. Once per day, I get the following result, which is triggered by a cron job:
>
> opendkim-genrates: started at Wed Aug 6 23:59:01 2014
> opendkim-genrates: using standard score 1.15
> opendkim-genrates: connected to database
> opendkim-genrates: computing low-time threshold
> opendkim-genrates: unable to determine low-time threshold
>
> Is that normal?
>
> I collects stats and graphs, too. You can have a look here:
>
> https://www.roessner-net.de/repute/stats.html
> https://www.roessner-net.de/repute/graphs.html
>
> This is my config:
>
> LogWhy yes
> Syslog yes
> SyslogSuccess yes
> Statistics /var/lib/opendkim/stats-verify
> StatisticsName mx0.roessner-net.de
> ReputationRatios repute:www.roessner-net.de
> ReputationLimits repute:www.roessner-net.de
> ReputationTimeFactor 24
> ReputationMinimum 2
> ReputationSpamCheck /^X-Spam-Status: Yes/
> Socket inet6:8891_at_[::1]
> Background yes
> PidFile /var/run/opendkim/opendkim-verify.pid
> SendReports no
> On-SignatureError accept
> AddAllSignatureResults yes
> AlwaysAddARHeader yes
> Mode v
> AuthservID mx0.roessner-net.de
> DomainKeysCompat true
> TemporaryDirectory /var/lib/opendkim/tmp
> TrustAnchorFile /etc/opendkim/root.key
> UserID milter:milter
> VBR-TrustedCertifiers dwl.spamhaus.org
> SoftwareHeader yes
>
> It’s opendkim version 2.9.2 running on Gentoo (own overlay which enables reputation)
>
> Am I missing something and can someone give me an explanation, what this low-time threshold means?

In the meantime I have renamed the database from odkim->opendkim and also modified user privileges to clarify, if there went something wrong with dbname/dbuser, but this seems not to be the problem.

At this writing, I have nearly 100.000 messages in my database and I think that might be enough content for calculating reputation scores, is it?

How could I debug things? I can see that my both mail servers report stuff every 5 minutes to DB. My web server does a refresh for the web report every 15 minutes (also graphs).

At night, just one of my mail servers does the genrates/modtotals/expire once at midnight (cron job).

OpenDKIM is successfully querying the repute service. I can see this in the logs on my web server and if I cut&past one of the logged GET lines, I can see that the service gives me an answer.

193.239.107.52 - - [08/Sep/2014:09:41:06 +0200] "GET /repute/repute.php?subject=quelleversand.de&application=email-id&assertion=spam&service=www.roessner-net.de HTTP/1.1" 200 243 "-" "OpenDKIM-Filter/2.9.2 libcurl/7.36.0" "-"
193.239.107.52 - - [08/Sep/2014:09:41:06 +0200] "GET /repute/repute.php?subject=LOW-TIME&application=email-id&assertion=spam&service=www.roessner-net.de HTTP/1.1" 200 243 "-" "OpenDKIM-Filter/2.9.2 libcurl/7.36.0" "-"
193.239.107.52 - - [08/Sep/2014:09:41:06 +0200] "GET /repute/repute.php?subject=%2A&application=email-id&assertion=spam&service=www.roessner-net.de HTTP/1.1" 200 243 "-" "OpenDKIM-Filter/2.9.2 libcurl/7.36.0" "-"
193.239.107.52 - - [08/Sep/2014:09:41:08 +0200] "GET /repute/repute.php?subject=UNSIGNED&application=email-id&assertion=spam&service=www.roessner-net.de HTTP/1.1" 200 243 "-" "OpenDKIM-Filter/2.9.2 libcurl/7.36.0" "-"
193.239.107.52 - - [08/Sep/2014:09:41:08 +0200] "GET /repute/repute.php?subject=%2A&application=email-id&assertion=spam&service=www.roessner-net.de HTTP/1.1" 200 243 "-" "OpenDKIM-Filter/2.9.2 libcurl/7.36.0" „-"

Some answer:

No data available

This is on my DB-host:

MariaDB [opendkim]> select * from aggregate;
Empty set (0.00 sec)

MariaDB [opendkim]> select * from predictions;
Empty set (0.00 sec)

It doesn’t matter, if it is MySQL or MariaDB. I switched to MariaDB 2 or 3 days ago and the problem existed with MySQL either. So at least this is not causing any problems.

I am really interested in this topic. I may be that I have done some configuration mistake. But I am not able to detect it, because I do not know where to look at and how to trace the problem, as all I tried seems to be fine so far.

Thanks in advance

Kind regards

Christian
--
Bachelor of Science Informatik
Erlenwiese 14, 36304 Alsfeld
T: +49 6631 78823400, F: +49 6631 78823409, M: +49 171 9905345
USt-IdNr.: DE225643613, http://www.roessner-network-solutions.com



Received on Mon Sep 08 2014 - 08:54:12 PST

This archive was generated by hypermail 2.3.0 : Mon Sep 08 2014 - 09:00:01 PST