Re: Question for reputation stuff

From: Christian Rößner <c_at_roessner-network-solutions.com>
Date: Tue, 9 Sep 2014 10:54:57 +0200

Am 09.09.2014 um 07:19 schrieb Murray S. Kucherawy <msk_at_blackops.org>:

> On Mon, 8 Sep 2014, Christian R??ner wrote:
>>> 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?
>
> There's a large SQL command generated at line 373 of opendkim-genrates. It looks as if that query is returning no rows for your database. This is likely because of one of the two constraints in that SELECT. The purpose of that computation is to figure out how long a spammy domain tends to send mail before going away, and a spammy domain is one that sends at least 75% spam before it goes away. Do you have any domains that have sent you 75% spam?
>
> The other constraint in there is to require that any domain considered above also has to have sent you at least two messages. Otherwise a single spammy message means that domain passes the 75% threshold. Is that also the case?
>
> I suspect that query is returning zero rows. You might need to adjust those limits and try it again.

MariaDB [opendkim]> SELECT COUNT(c) AS domains, MIN(l) AS 'min duration', MAX(l) AS 'max duration', AVG(l) AS 'mean duration', STDDEV_POP(l) AS 'duration stddev' FROM (SELECT COUNT(messages.id) AS c, SUM(messages.spam)/COUNT(messages.id) AS r, DATEDIFF(MAX(messages.msgtime), MIN(messages.msgtime)) AS l FROM signatures JOIN messages ON signatures.message = messages.id WHERE messages.id >= 1 AND NOT spam = -1 AND pass = 1 GROUP BY signatures.domain) t1 WHERE r >= 0.5 AND c >= 2;
+---------+--------------+--------------+---------------+-----------------+
| domains | min duration | max duration | mean duration | duration stddev |
+---------+--------------+--------------+---------------+-----------------+
| 4 | 2 | 42 | 15.0000 | 15.9217 |
+---------+--------------+--------------+---------------+-----------------+
1 row in set (0.33 sec)

MariaDB [opendkim]> SELECT COUNT(c) AS domains, MIN(l) AS 'min duration', MAX(l) AS 'max duration', AVG(l) AS 'mean duration', STDDEV_POP(l) AS 'duration stddev' FROM (SELECT COUNT(messages.id) AS c, SUM(messages.spam)/COUNT(messages.id) AS r, DATEDIFF(MAX(messages.msgtime), MIN(messages.msgtime)) AS l FROM signatures JOIN messages ON signatures.message = messages.id WHERE messages.id >= 1 AND NOT spam = -1 AND pass = 1 GROUP BY signatures.domain) t1 WHERE r >= 0.6 AND c >= 2;
+---------+--------------+--------------+---------------+-----------------+
| domains | min duration | max duration | mean duration | duration stddev |
+---------+--------------+--------------+---------------+-----------------+
| 0 | NULL | NULL | NULL | NULL |
+---------+--------------+--------------+---------------+-----------------+
1 row in set (0.34 sec)

Thank you so very much. That explains everything. Fortunately we do not have very much spam here. So I believe that I never reach 75%.

So at least I now know that my setup seems to be correct.

Best wishes

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 Tue Sep 09 2014 - 08:55:21 PST