Bug 8236 - mail/spamassassin Bug in bayes updating txtrep
Summary: mail/spamassassin Bug in bayes updating txtrep
Status: NEW
Alias: None
Product: Spamassassin
Classification: Unclassified
Component: spamassassin (show other bugs)
Version: 4.0.1
Hardware: PC FreeBSD
: P2 normal
Target Milestone: Undefined
Assignee: SpamAssassin Developer Mailing List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-14 13:47 UTC by Cy Schubert
Modified: 2024-04-14 13:47 UTC (History)
0 users



Attachment Type Modified Status Actions Submitter/CLA Status

Note You need to log in before you can comment on or make changes to this bug.
Description Cy Schubert 2024-04-14 13:47:38 UTC
Hi,

I am a FreeBSD committer and maintainer of the mail/spamassassin group of packages. One of my users is complaining about the following. I've pasted his email to me below:

Starting with spamassassin-4.0.1, which I build with poudriere on April 
1, it seems to update the txrep table (mariadb) in a wrong way...

If there already was an entry in column email (meaning a real 
email@addr.ess), the msgcount column is set to 1 in stead of adding 1 to 
the value already there!
This does not apply to other entrees like IP's and such.

Started with 4.0.1, same in 4.0.1_1
Mariadb106, but used p5-DBD-mysql in both!

== EXAMPLE==
The orders@ email address should have multiple hits in msgcount

| username| email                       | ip   | msgcount | totscore  | signedby
+---------+-----------------------------+------+----------+-----------+---------------
| luser   | _192.168.2.44_              | none |      203 |  -224.509 | helo
| luser   |orders@CLIENT_MAIL.it        | none |        1 |  -172.713 | CLIENT_MAIL.it
| luser   | e059b4~~eb05ec@sa_generated | none |        1 | -0.847882 | 1713003188
| luser   | CLIENT_MAIL.it              | none |      150 |  -216.981 | CLIENT_MAIL.it
| luser   | 123.4.56.789                | none |      308 |   -388.25 |