> On Fri, 2004-08-27 at 11:23, Michael Parker wrote: > > On Fri, Aug 27, 2004 at 11:05:56AM -0500, Nick Bright wrote: > > > > <log trimmed for brevity>
Yeah, opps, I kept it around in case I needed to look at it again and forgot to remove it before sending, sorry all for the wasted bandwidth. > > > > Are you sure you ran sa-learn as the same user who is receiving the > > mail? What user does userid 4 correspond to in your bayes_vars table? > > > I ran sa-learn as root. . . userid 4 corrisponds to the user I'm > submitting the test mail as, I see some other things in the table too. > In specific, I see root with the spam_count and ham_count I expected to > see. > > I assume, then, that I am doing something wrong WRT bayes. I want all > bayes information to be global, for all users. Can this be accomplished? > I can't just have it always use the same username to run under, as I am > also doing user_prefs. . . > You want to use bayes_sql_override_username for global bayes, you can read more about it in sql/README.bayes and the Conf documentation. Bayes SQL will store the data as whatever user you ran sa-learn as, unless you have bayes_sql_override_username set. /me goes off and starts the Bayes SQL wiki page with all of these useful tips > > Did you set: > > auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList > > ? > > No as a matter of fact, I did not. I put that in my local.cf, and AWL in > SQL is now working. Perhaps that should be in the sql/README.awl file? > You mean this part right at the top? "In order to activate the SQL based auto-whitelist you have to configure spamassassin and spamd to use a different whitelist factory. This is done with the auto_whitelist_factory config variable, like so: auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList " > > I noticed that if you go up one level, there is a much more recent > version of the php-sa-mysql available, but I don't see one for pgsql > still. > > However, now that I know how to put the prefs into the DB, I should be > able to write my own php-sa-pgsql application, or beg someone I know to > do it for me :) > I guess I assumed it would be trivial to adapt for postgres. I've been contemplating writing a cgi application to handle user_prefs/bayes/awl SQL data that would hopefully eventually make it's way into the distribution (ie officially supported) maybe I'll work it up and present it at ApacheCon. Michael
