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