MailScanner + Bayes on SQL

[Dhawal Doshy]

Kai Schaetzl wrote:
> Is this at all possible with MailScanner? I followed the instructions on 
> the spamassassin wiki and migrated a Bayes database to MySQL. When I test 
> via spamassassin --lint I get this output:

> [12153] dbg: bayes: using username: root
> [12153] dbg: bayes: database connection established
> [12153] dbg: bayes: found bayes db version 3
> [12153] dbg: bayes: unable to initialize database for root user, aborting!
> 
> This doesn't happen with the system wide setting of bayes_path, the user 
> doesn't matter in this case. How can I do this when using MailScanner?
> Is it that configuration variable?
> 
> bayes_sql_override_username        someusername

precisely.. See, 
http://wiki.mailscanner.info/doku.php?id=documentation:anti_spam:spamassassin:bayes:sql

>>From the description I'm not 100% sure.
> http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadme
> 
> Also, if that is the correct way to do it, what username do I use?

mysql> SELECT id, username, spam_count, ham_count, token_count FROM 
bayes_vars;

- dhawal

> Kai