I put the following in local.cf (passwords obscured):
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:spamassassin:sa-db.intelius.com:3306 bayes_sql_username readwrite bayes_sql_password ######## auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:spamassassin:sa-db.intelius.com:3306 user_awl_sql_username readwrite user_awl_sql_password ######## The bayes stuff works just fine, but the awl stuff still writes to the local disk instead of mysql. And it looks like it's ttying to connect to the root account in mysql, as the logs say: Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: sql-based connected to DBI:mysql:spamassassin:sa-db.intelius.com:3306 Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: sql-based using username: root Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: sql-based get_addr_entry: no entry found for [EMAIL PROTECTED]|ip=none Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: sql-based [EMAIL PROTECTED]|ip=none scores 0/0 Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: AWL active, pre-score: 2.865, autolearn score: 2.865, mean: undef, IP: undef Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: sql-based finish: disconnected from DBI:mysql:spamassassin:sa-db.intelius.com:3306 Jul 7 15:57:25 smtp5.sea.intelius.com spamd[13024]: auto-whitelist: post auto-whitelist score: 2.865 What am I doing wrong, that SA would still be going to the local disk for the AWL stuff? SpamAssassin is from rpm and is version spamassassin-3.2.4-1.el4.rf. Perl is perl-5.8.8-2.el4s1. MySQL is 5.0.18. And it's running under Red Hat Enterprise Linux AS 4.6. Thanks, -Adam
