Because /var/spool/MIMEDefang/.spamassassin/auto-whitelist is still being updated, but if I go into mysql and do a count on the AWL entries it comes up zero:
mysql> select count(*) from awl; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) -Adam -----Original Message----- From: Michael Parker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 11:22 AM To: Adam Harrison Cc: users@spamassassin.apache.org Subject: Re: mysql AWL issue.... 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