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