I'd like to report some things I noticed while updating from SA 3.4.1 to
SA 3.4.2 on CentOS 7. No serious problems, but I'd like to mention if
someone also tries to update on CentOS 7.
I created the 3.4.2 rpm by downloading the latest Fedora Core 3.4.1 src
rpm. Then I did:
- remove all patches except patch0. The removed patches were backports
that are contained in 3.4.2 or fedora-specific patches.
- remove SOURCE12 from the *.spec. This source deals with the sought
ruleset that doesn't work any more
- replace the 2 main tar.bz2/tar.gz sources (program and rules) and
built the rpm. This was the same way I created a Centos 7 3.4.1 rpm I
used before.
This produces a rpm that can be used to update.
- upon starting spamd, I got this message in the system log:
auto-whitelist: sql-based get_addr_entry
ign...@compiling.spamassassin.taint.org|none: SQL error: Unknown column
'last_hit' in 'order clause'
It seems this column is added for 3.4.2, but it is not documented in the
update notes. It's not even present in the CREATE TABLE statement in
SQLBasedAddrList.pm. Should probably be added. I assume it is a
auto-updating TIMESTAMP column purely for documentation like this:
`last_hit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
- I had to remove 2 update channels (sa-zmi-at and sought), because they
don't provide sha256 or sha512 digests - only sha1, and 3.4.2 sa-update
now completely ignores sha1. The channels were not updated for a long
time, though.
- The system log is spammed with messages like:
dns: new_dns_packet: domain is utf8 flagged: a3.verisigndns.com
This seems a debug or trace message mistakenly sent with info severity.
Alex
