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