RE: Bayes SQL Errors

2006-08-21 Thread Ryan Kather
Michael, Thanks for the help, but it didn't seem to make a difference. Though I have noticed some strange things.. See steps taken and responses inline. I have dropped the database completely, commented out the local.cf bayes_sql and bayes_store settings, and performed an sa-learn --sync.

FW: Bayes SQL Errors

2006-08-21 Thread Michael Grey
Ryan, I just did this myself the first time in the last week; Be sure that all your operations on the DB are done as the user who is going to be accessing it; ie: Spamassassin spamuser etc. Not knowing the history of your install; In your Spamassassin local.cf file you should have these line

Re: Bayes SQL Errors

2006-08-21 Thread Ryan Kather
Interesting.. if I try to import my old Berkely DB it fails right out. If I process a message auto learn complains about the duplicate key again, but it actually learns the tokens and I can see them with sa-learn --dump magic. What key is duplicate? I'm still unclear on how to resolve this?

Bayes SQL Errors

2006-08-21 Thread Ryan Kather
I am having a few problems converting from Berkely DB to MySQL w/ InnoDB. I have created the DB, Tables, and updated the local.cf. Everything appears ok, but when I attempt to restore my Berkely DB backup with sa-learn --restore filename. I get the following errors. [21508] dbg: bayes: usi