Problem:

info: auto-whitelist: sql-based get_addr_entry xxxxxx: SQL error: Unknown column 'last_hit' in 'order clause'

Solution:

Configure reputation database (read /usr/share/doc/spamassassin/sql/README.txrep) for mysql, execute /usr/share/doc/spamassassin/sql/txrep_mysql.sql

Problem:

  pts rule name              description
 ---- ---------------------- --------------------------------------------------
  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was
                             blocked.  See
                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block
                              for more information.
                             [URIs: grinn-global.com]

There are lots of queries to google dns 8.8.8.8, but google responds with NXDomain or ServFail. The same single query works. Probably google blocks bursts of this kind of requests.

Solution:

local.cf

dns_server 127.0.0.1