I guess my best response to this is ..... so do you have a real point? It does work and very well. I am now using spamassassin with mysql user preferences for 10000 users in a cluster across 7 servers with native mysql replication on qmail/vpopmail+mysql and have not had it fail yet?
My users are happier than they have ever been at what we can do especially with the sql support in the exellent interface webuserprefs David Rodgers ----- Original Message ----- From: "Arlo Gilbert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 6:11 PM Subject: [SAtalk] Perl & MySQL - Spamassassin doesn't use mysql based user prefs > Well no thanks to any of the documentation or this list for that > matter, but it appears that the implementation of SA's > mail::spamassassin module is not all it says in the docs when using > mysql based user prefs. > > Spamassassin.pm has a non public sub called init that is called > internally from the "check" sub. init checks to see if the config files > have been loaded yet. If they have been loaded it then proceeds on to > screen the message for spam. If a config file has not been loaded, it > loads it and overwrites any custom mail::spamassassin::conf variables > with the defaults and the values from the config file. Thus the > following code is ineffective. > > my $spamtest = Mail::SpamAssassin->new(); > $spamtest->load_scoreonly_sql($username); > my $status = $spamtest->check($msg); > $status->rewrite_mail(); > $status->finish (); > > > by manually calling the non public "init" function via > $spamtest->init(1); as show below, one forces spamassassin to load the > config file and all defaults, then the load_scoreonly_sql function > loads the appropriate rules and user prefs that are stored in the > database. failure to do init(1) prior to load_scoreonly_sql results in > mysql data being overridden by defaults and config file data. > > my $spamtest = Mail::SpamAssassin->new(); > $spamtest->init(1); > $spamtest->load_scoreonly_sql($username); > my $status = $spamtest->check_message_text($msg); > $status->rewrite_mail(); > $status->finish (); > > > If this is anywhere in the manual i'd be thrilled to see it, but given > that init is not even mentioned as a method, i'd assume it's not. > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > SourceForge.net hosts over 70,000 Open Source Projects. > See the people who have HELPED US provide better services: > Click here: http://sourceforge.net/supporters.php > _______________________________________________ > Spamassassin-talk mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/spamassassin-talk > > ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
