On Fri, 2004-08-27 at 13:06, Michael Parker wrote: > > 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 >
I wondered why there wasn't one already. I figured all of these were probably very common questions, and I did try to find this information on the Wiki rather unsuccessfully. > > > > 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 > " Yes, apparently I'm blind :) > > > > > 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. > I hadn't looked at the source yet, but I'm not much of a programmer anyways. I can make do on this front. Thanks for the help getting my other issues resolved, I appreciate it very much. > Michael -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
