Trouble with bayes sql

[Jason Ede]

> -----Original Message-----
> From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-
> bounces at lists.mailscanner.info] On Behalf Of Kate Kleinschafer
> Sent: 21 October 2008 02:43
> To: MailScanner discussion
> Subject: Trouble with bayes sql
>
> Hi all,
>
> With the latest MailScanner and spamassassin do you have to set up a
> symlink in /etc/mail/spamassassin to mailscanner.cf in order for the
> bayes to be used?
> Also do I need to make root the bayes_sql_override_username or should
> it
> be postfix?
>
> I have bayes setup as a mysql database - setttings are in
> spamassassin.prefs.conf (as per the wiki instructions for MailScanner)
>
> The reason I ask is because none of the bayes rules are being hit at
> all.
> This is the settings in spamassassin.prefs.conf
> bayes_store_module           Mail::SpamAssassin::BayesStore::SQL
> bayes_sql_dsn                DBI:mysql:sa_bayes:box.forspam.co.nz
> bayes_sql_username           username (not used anywhere else)
> bayes_sql_password           thepassword
> bayes_sql_override_username  root
>
> I run spamassassin as user postfix
>
> Thanks
> Kate

What does the end of the output  (all the lines mentioning bayes) of
sa-learn --rebuild -D -p /etc/MailScanner/spam.assassin.prefs.conf

show?