RE: TXREP dont work

[Rick Cooper <rc...@dwford.com>]

RW wrote:
> On Fri, 30 Sep 2016 08:43:18 +0000
> Nicola Piazzi wrote:
> 
>> After a new box instalation I found that txrep doesnt work
>> 
>> The table is empty
>> mysql> select * from txrep;
>> Empty set (0.00 sec)
>> 
>> Obviously I disabled AWL and Load TxRep il v341.pre
> 
> Did you set
> 
> use_txrep 1

I am in the same boat and yes use_txrep is set to 1.
There is not a single item in the table after a week.
But when I do a test with a known spam mail I get a line like
This:

0.1 TXREP                  TXREP: Score normalizing based on sender's
reputation

When run in debug mode it appears that it is using
~/.spamassassin/tx-reputation
Instead of the mysql DB.

Oct  6 22:46:39.479 [13510] dbg: locker: mode is 384
Oct  6 22:46:39.479 [13510] dbg: locker: safe_lock: created
/home/exim/.spamassassin/tx-reputation.mutex
Oct  6 22:46:39.479 [13510] dbg: locker: safe_lock: trying to get lock on
/home/exim/.spamassassin/tx-reputation with 30 timeout
Oct  6 22:46:39.479 [13510] dbg: locker: safe_lock: link to
/home/exim/.spamassassin/tx-reputation.mutex: link ok

So how do I dump the ~/ disk file for the DB . The txrep.cf file :

user_awl_dsn DBI:mysql:SpamAssassin:127.0.0.1
user_awl_sql_username CorrectUser
user_awl_sql_password CorrectPassword
user_awl_sql_table txrep
use_txrep 1
txrep_track_messages 1

Thanks for any help, 

Rick

RE: TXREP dont work

[Rick Cooper <rc...@dwford.com>]

Karol Augustin wrote:
> On 07/10/16 03:51, Rick Cooper wrote:
>> So how do I dump the ~/ disk file for the DB . The txrep.cf file :
>> 
>> user_awl_dsn DBI:mysql:SpamAssassin:127.0.0.1
>> user_awl_sql_username CorrectUser
>> user_awl_sql_password CorrectPassword
>> user_awl_sql_table txrep
>> use_txrep 1
>> txrep_track_messages 1
> You need the line:
> 
> txrep_factory                   Mail::SpamAssassin::SQLBasedAddrList
> 
> It tells SA to use SQL DB factory module.
> 
> 
> Best,
> Karol

Yep, that was it. I did not try that because the documents clearly say:

I misread that and did not see the difference (SQL) over the default at
first.

Thanks for point out my "duhhh" moment.

Rick

Re: TXREP dont work

[Karol Augustin <ka...@augustin.pl>]

On 07/10/16 03:51, Rick Cooper wrote:
> So how do I dump the ~/ disk file for the DB . The txrep.cf file :
>
> user_awl_dsn DBI:mysql:SpamAssassin:127.0.0.1
> user_awl_sql_username CorrectUser
> user_awl_sql_password CorrectPassword
> user_awl_sql_table txrep
> use_txrep 1
> txrep_track_messages 1
You need the line:

txrep_factory                   Mail::SpamAssassin::SQLBasedAddrList

It tells SA to use SQL DB factory module.


Best,
Karol


-- 
Karol Augustin
karol@augustin.pl
http://karolaugustin.pl/
+353 85 775 5312