Hello list,

After an upgrade to SA-4.0.0 I decided to give TxRep a try after using AWL since it was introduced. I set up TxRep accordingly to SA’s documentation with a mysql-5.7.40 server, give it a first try by sending an email to the box where SA is running and saw TxRep just has recorded unreliably onto the sql table:

#v+
root@localhost [spamassassin]> describe txrep;
+----------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+-------------------+-----------------------------+
| username | varchar(100) | NO | PRI | | | | email | varchar(255) | NO | PRI | | | | ip | varchar(40) | NO | PRI | | | | msgcount | int(11) | NO | | 0 | | | totscore | float | NO | | 0 | | | signedby | varchar(255) | NO | PRI | | | | last_hit | timestamp | NO | MUL | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+----------+--------------+------+-----+-------------------+-----------------------------+
7 rows in set (0,00 sec)

root@localhost [spamassassin]> select * from txrep;
+----------+-------------------------------------------------------+------+----------+----------+------------+---------------------+
| username | email | ip | msgcount | totscore | signedby | last_hit |
+----------+-------------------------------------------------------+------+----------+----------+------------+---------------------+
| vscan | 209.85.218.51 | none | 1 | -0.217 | | 2023-01-09 01:25:46 | | vscan | aac3c57398484c78fd317abe6061e81c4b9296f2@sa_generated | none | 1 | -0.217 | 1673223945 | 2023-01-09 01:25:46 | | vscan | gmail.com | none | 1 | -0.217 | gmail.com | 2023-01-09 01:25:46 | | vscan | mail-ej1-f51.google.com | none | 1 | -0.217 | helo | 2023-01-09 01:25:46 | | vscan | u...@gmail.com | none | 1 | -0.217 | gmail.com | 2023-01-09 01:25:46 |
+----------+-------------------------------------------------------+------+----------+----------+------------+---------------------+
5 rows in set (0,00 sec)
#v-

Anyone can tell me how the hell it is logging for example: an address in the email column or garbage on the signedby table?

SQL statements used to create txrep table is the one supplied by SA-4.0.0 (beside table’s name, this is the same as ones AWL need).

The following TxRep settings were been used in the global local.cf:

#v+
use_txrep 1
txrep_ipv4_mask_len 32
txrep_ipv6_mask_len 128
auto_welcomelist_distinguish_signed 1
txrep_spf 1
#v-

Cheers,

--
matt [at] lv223.org
GPG key ID: 7D91A8CA

Reply via email to