On Jul 8, 2008, at 12:42 PM, Adam Harrison wrote:
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 [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?
What about the above messages makes you think its writing to a local
disk file?
Connection is root is because on init the code runs a sample message
through to load all the libraries and its running as the root user.
Its not trying to connect as root.
Michael
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
