On 5.3.2010 17:23, Stephane MAGAND wrote: > Hi > > ok i have put > bayes_sql_override_username > > and now that's work thanks ;=) > > Another small question, after bayes, can i put AWL in MySQL ? >
Yes you can, it's all in the doku or wiki. Anyway: --- local.cf ---------- # Enable awl auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:spamassassin:dbsrv user_awl_sql_username spamassassin user_awl_sql_password amazing -- database --------- CREATE TABLE `awl` ( `username` varchar(100) NOT NULL DEFAULT '', `email` varchar(200) NOT NULL DEFAULT '', `ip` varchar(40) NOT NULL, `count` int(11) DEFAULT '0', `totscore` float DEFAULT '0', `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `signedby` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`username`,`email`,`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ; -- http://www.iki.fi/jarif/
signature.asc
Description: OpenPGP digital signature