Re: Txrep problem

[Jari Fredriksson]

> Reindl Harald  kirjoitti 2.12.2018 kello 21.40:
> 
> 
> honestly - what about "waste" 5 seconds of your own time verify what you
> link and get a proper operating system other than a Mac?
> 

Good point. But

- I use proper operating systems on my servers. I also have a Linux Desktop but 
not (yet) on this Mac.
- I just happen to be drunk at moment.

Done with this. At least the database collects data now.

Br. Jarif

Re: Txrep problem

[Jari Fredriksson]

Current DB says:

MariaDB [spamassassin]> select * from txrep order by last_hit;
+--+---++---+--++-+
| username | email | ip | 
count | totscore | signedby   | last_hit|
+--+---++---+--++-+
| spam | re...@coindesk-email.com  | none   |   
  1 |1.261 || 2018-12-02 18:42:45 |
| spam | coindesk-email.com| none   |   
  1 |1.261 || 2018-12-02 18:42:45 |
| spam | 645bde2ec5270a8ec9430d5a4c0fcca894df8f1b@sa_generated | none   |   
  1 |1.261 | 1543512668 | 2018-12-02 18:42:46 |
| spam | 50.115.211.72 | none   |   
  1 |  -20 || 2018-12-02 19:00:44 |
| spam | r.groupon.com | 50.115 |   
  1 |  -20 || 2018-12-02 19:00:44 |
| spam | nore...@r.groupon.com | none   |   
  1 |  -20 || 2018-12-02 19:00:44 |
| spam | nore...@r.groupon.com | 50.115 |   
  1 |  -20 || 2018-12-02 19:00:44 |
| spam | mta372s1.r.groupon.com| none   |   
  1 |  -20 | helo   | 2018-12-02 19:00:44 |
| spam | 08fd4ef0412aa133fb4aaced8a13ef6a63ba7744@sa_generated | none   |   
  2 |  -40 | 1543774964 | 2018-12-02 19:00:45 |
| spam | fer...@bonhard.uklinux.net| none   |   
  1 |   -3.052 | sourceware.org | 2018-12-02 19:37:41 |
| spam | desktop1qekdec| none   |   
  1 |   -3.052 | helo   | 2018-12-02 19:37:42 |
| spam | bc3d496dc47fc7b853f559f87efc21d014bd3e09@sa_generated | none   |   
  1 |   -3.052 | 1543779452 | 2018-12-02 19:37:42 |
| spam | 86.26.26.218  | none   |   
  1 |   -3.052 || 2018-12-02 19:37:42 |
| spam | sourceware.org| none   |   
  1 |   -3.052 | sourceware.org | 2018-12-02 19:37:42 |
+--+---++---+--++-+
14 rows in set (0.00 sec)

Br. jarif

Re: Txrep problem

[Jari Fredriksson]

> Jari Fredriksson  kirjoitti 2.12.2018 kello 21.22:
> 
> 
> Final paste once more: https://pastebin.com/kvTK0NPe 
> 
> 
> Mac copy paste was odd.
> 

.. aand that was bad too. I pasted the debug of previous debug.log :D

Here it is. https://pastebin.com/Ujr1ebST 

And this has still TXREP as 8.1 points!

Br. jarif

Re: Txrep problem

[Jari Fredriksson]

Final paste once more: https://pastebin.com/kvTK0NPe 


Mac copy paste was odd.

Re: Txrep problem

[Jari Fredriksson]

> Giovanni Bechis  kirjoitti 2.12.2018 kello 11.13:
> 
> Can you try to run spamassassin -D  to have a look at what's going on ?
> Thanks
>  Giovanni
> 
> On 11/30/18 6:46 PM, Jari Fredriksson wrote:
>> Hello all!
>> 
>> I have tried to implement TxRep into my system.
>> 
>> My configuration for it is
>> 
>> # Enable awl
>> user_awl_dsnDBI:mysql:spamassassin:spamassassin
>> user_awl_sql_usernamespamassassin
>> user_awl_sql_passwordamazing
>> 
>> use_txrep 1
>> 
>> 
>> My v341.pre says
>> 
>> # TxRep - Reputation database that replaces AWL
>> loadplugin Mail::SpamAssassin::Plugin::TxRep
>> 
>> Spamassassin -D —lint tells no problems.
>> 
>> I have a database in MySQL named as ”spamassassin” and there I have table 
>> txrep as
>> 
>>+--+--+--+-+-+---+
>>| Field| Type | Null | Key | Default | Extra |
>>+--+--+--+-+-+---+
>>| username | varchar(100) | NO   | PRI | |   |
>>| email| varchar(255) | NO   | PRI | |   |
>>| ip   | varchar(40)  | NO   | PRI | |   |
>>| count| int(11)  | NO   | | 0   |   |
>>| totscore | float| NO   | | 0   |   |
>>| signedby | varchar(255) | NO   | PRI | |   |
>>+--+--+--+-+-+---+
>>6 rows in set (0.00 sec)
>> 
>> 
>> The table is empty!
>> 
>> And in addition to that I today saw a spam that was pretty hammy, but had a 
>> score from TxRep as 8 points and It was marked as spam. What gave that score 
>> and why I do not get anything into table txrep?
>> 
>> The table txrep is the only table in MariaDB database spamassassin, as my 
>> bayes is in Redis.
>> 
>> Thanks,  jarif  
> 

New paste: https://pastebin.com/sX0RCGYt 

The previous spamassasin -D was run on a bad machine, it did not have up to 
date SpamAssassin installed and configured.

Br. Jarif

Re: Txrep problem

[Jari Fredriksson]

> Giovanni Bechis  kirjoitti 2.12.2018 kello 11.13:
> 
> Can you try to run spamassassin -D  to have a look at what's going on ?
> Thanks
>  Giovanni
> 

The paste is https://pastebin.com/iHV8GUe7 

I made the changes to local.cf as suggested and the message does not any more 
trigger 8.1 points!

But the paste can be seen if there is something…

Also the table has now data and it seems to be working correctly!

MariaDB [spamassassin]> select * from txrep;
+--+---+--+---+--++-+
| username | email | ip   | 
count | totscore | signedby   | last_hit|
+--+---+--+---+--++-+
| spam | 645bde2ec5270a8ec9430d5a4c0fcca894df8f1b@sa_generated | none | 
1 |1.261 | 1543512668 | 2018-12-02 18:42:46 |
| spam | coindesk-email.com| none | 
1 |1.261 || 2018-12-02 18:42:45 |
| spam | re...@coindesk-email.com  | none | 
1 |1.261 || 2018-12-02 18:42:45 |
+--+---+--+---+--++-+
3 rows in set (0.03 sec)


Br. Jarif

Re: Txrep problem

[Jari Fredriksson]

> John Capo  kirjoitti 1.12.2018 kello 18.08:
> 
> ALTER TABLE `txrep` ADD last_hit timestamp NOT NULL default CURRENT_TIMESTAMP 
> ON UPDATE CURRENT_TIMESTAMP ;

@John: I added these, remains to be seen.

Now I try the suggestion @Giovanni suggested.

Br. jarif

Re: Txrep problem

[Giovanni Bechis]

Can you try to run spamassassin -D  Hello all!
> 
> I have tried to implement TxRep into my system.
> 
> My configuration for it is
> 
> # Enable awl
> user_awl_dsnDBI:mysql:spamassassin:spamassassin
> user_awl_sql_usernamespamassassin
> user_awl_sql_passwordamazing
> 
> use_txrep 1
> 
> 
> My v341.pre says
> 
> # TxRep - Reputation database that replaces AWL
> loadplugin Mail::SpamAssassin::Plugin::TxRep
> 
> Spamassassin -D —lint tells no problems.
> 
> I have a database in MySQL named as ”spamassassin” and there I have table 
> txrep as
> 
> +--+--+--+-+-+---+
> | Field    | Type         | Null | Key | Default | Extra |
> +--+--+--+-+-+---+
> | username | varchar(100) | NO   | PRI |         |       |
> | email    | varchar(255) | NO   | PRI |         |       |
> | ip       | varchar(40)  | NO   | PRI |         |       |
> | count    | int(11)      | NO   |     | 0       |       |
> | totscore | float        | NO   |     | 0       |       |
> | signedby | varchar(255) | NO   | PRI |         |       |
> +--+--+--+-+-+---+
> 6 rows in set (0.00 sec)
> 
> 
> The table is empty!
> 
> And in addition to that I today saw a spam that was pretty hammy, but had a 
> score from TxRep as 8 points and It was marked as spam. What gave that score 
> and why I do not get anything into table txrep?
> 
> The table txrep is the only table in MariaDB database spamassassin, as my 
> bayes is in Redis.
> 
> Thanks,  jarif