You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "Steven W. Orr" <st...@syslang.net> on 2012/09/17 04:59:44 UTC

Problems with AWL not working.

Back at Xmas, I went from Fedora 10 to Fedora 15. Since then I never noticed 
that my MySQL AWL table has no entries. Here's what I have:

* spamassassin-3.3.2-7.fc15.x86_64

* In mysql
CREATE TABLE `awl` (
   `username` varchar(100) NOT NULL DEFAULT '',
   `email` varchar(200) NOT NULL DEFAULT '',
   `ip` varchar(10) NOT NULL DEFAULT '',
   `count` int(11) DEFAULT '0',
   `totscore` float DEFAULT '0',
   `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
CURRENT_TIMESTAMP,
   PRIMARY KEY (`username`,`email`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

* In local.cf

use_auto_whitelist           1
#auto_whitelist_factory       Mail::SpamAssassin::SQLBasedAddrList
user_awl_sql_table           awl
user_awl_dsn                 DBI:mysql:spamassassin:localhost
user_awl_sql_username        guess
user_awl_sql_password        again

* select count(*) from awl;
Tells me there are zero rows.

* Sep 16 22:30:37.850 [3196] dbg: plugin: loading 
Mail::SpamAssassin::Plugin::AWL from @INC

Can someone tell me what I'm doing wrong?

TIA

-- 
Time flies like the wind. Fruit flies like a banana. Stranger things have  .0.
happened but none stranger than this. Does your driver's license say Organ ..0
Donor?Black holes are where God divided by zero. Listen to me! We are all- 000
individuals! What if this weren't a hypothetical question?
steveo at syslang.net