Andrew wrote: > > > Is this normal behaviour even when using an SQL database to store the > AWL? No, but you're not using a SQL database for the AWL, read on. > > Here are the relevant parameters from my local.cf file. > > user_awl_dsn DBI:mysql:saawl:localhost:3306 > user_awl_sql_username sa > user_awl_sql_password <password> > user_awl_sql_table awl
Where's your auto_whitelist_factory statement? You can't just enable SQL by setting those parameters. You have to tell SA to stop using DB files as a storage method and use SQL instead. Try adding this to your config file: auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList And be sure to read this document: http://spamassassin.apache.org/full/3.1.x/dist/sql/README.awl