LuKreme wrote:
Is there a write-up/how-to anyone's put together about setting up bayes with MySQL?
Aside from the sparse docs that ship with SA, none I've seen. I'm still fiddling the sitewide database size (number of tokens) a year and a half after the general configuration reached its current state.
Is it possible to migrate existing bayes to MySQL, or do you simply start over?
As mentioned, sa-learn's backup/restore functionality should work - may be troublesome to script though.
Does using MySQL bayes allow you to fake per-user bayes with MySQL-based users?
Mmm, after rereading this a few times I'm not sure what you're asking. By default it's per-user; each calling user passed by spamc or spamassassin is a "user" in the context of SpamAssassin. There's an "extra" table in the SQL defs (bayes_vars) that maps the calling user to an "id" field in the token table.
We've overridden this with bayes_sql_override_username to make it sitewide, since per-user Bayes tuning is.... not gonna happen in a general ISP environment.
If you're looking to actually use different SQL users for each SA user... don't think that's possible at all with stock SA.
FWIW, I don't think any of these are MySQL-specific, either. -kgd
