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

[Steven W. Orr]

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 (address@hidden):

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 <address@hidden> 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