Problem with SA/spamass-milter/MySQL/bayes.

["Steven W. Orr" <st...@syslang.net>]

Since I switched over to using MySQL to hold the userprefs, awl and bayes, 
I see that the bayes processing no longer functions.

Here's the relevant bayes debug output for a message that comes in 
addresed to me (steveo@syslang.net):

debug: bayes: Using username: root
debug: bayes: Database connection established
debug: bayes: found bayes db version 3
debug: bayes: Using userid: 1
debug: bayes: Not available for scanning, only 191 spam(s) in Bayes DB < 200
debug: Score set 1 chosen.
logmsg: processing message <x4...@footbone.schlitt.net> for root:0.
debug: bayes: Database connection established
debug: bayes: found bayes db version 3
debug: bayes: Using userid: 1
debug: bayes: Not available for scanning, only 191 spam(s) in Bayes DB < 200

The problem is that it is selecting root as the user for everything, i.e., 
userprefs and bayes. I think it's using root for awl as well.

The options for spamass-milter are
 	-m -u steveo

The options for spamd are
 	-d -x -q -m 5

What do I do? :-(

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

Re: Problem with SA/spamass-milter/MySQL/bayes.

["Steven W. Orr" <st...@syslang.net>]

On Monday, May 9th 2005 at 12:11 -0500, quoth Dan Nelson:

=>In the last episode (May 08), Steven W. Orr said:
=>> Since I switched over to using MySQL to hold the userprefs, awl and bayes, 
=>> I see that the bayes processing no longer functions.
=>> 
=>> Here's the relevant bayes debug output for a message that comes in 
=>> addresed to me (steveo@syslang.net):
=>> 
=>> debug: bayes: Using username: root
=>> debug: bayes: Database connection established
=>> debug: bayes: found bayes db version 3
=>> debug: bayes: Using userid: 1
=>> debug: bayes: Not available for scanning, only 191 spam(s) in Bayes DB < 200
=>
=>Just let it run a little longer; it won't score messages until it has
=>trained itself on 200 high and low-scoring messsages.  Not sure why
=>it's saying "root" though.  To see the bayes usage per user, do a
=>"select * from bayes_vars" query.  Are there any non-root lines at all?
=>
=>-- 
=>	Dan Nelson
=>	dnelson@allantgroup.com
=>

The message I provided debug data for was addressed to me (steveo). When I 
did the select statment above I see that the steveo account has 3381 spam 
messages and 279619 ham messages. The problem is that the messages sent to 
steveo are connecting to MySQL and thinking to look in the root row 
instead of in the steveo row.

-- 
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