bayes on MySQL problem

[Kosta Lekas]

I moved my local bayes to a remote mysql. When I lint the rule set as
root on my MS gateway everything is good (output below):

spamassassin -D -p /etc/MailScanner/spam.assassin.prefs.conf --lint

[11229] dbg: bayes: using username: root

[11229] dbg: bayes: database connection established

[11229] dbg: bayes: found bayes db version 3

[11229] dbg: bayes: Using userid: 1

[11229] dbg: bayes: corpus size: nspam = 2042, nham = 1857

[11229] dbg: bayes: tok_get_all: token count: 20

[11229] dbg: bayes: cannot use bayes on this message; not enough usable
tokens found

[11229] dbg: bayes: not scoring message, returning undef

 

 

But with MailScanner debug on I see problems when running as postfix:

[11285] dbg: bayes: database connection established

[11285] dbg: bayes: found bayes db version 3

[11285] dbg: bayes: unable to initialize database for postfix user,
aborting!

[11285] dbg: bayes: not scoring message, returning undef

[11285] dbg: bayes: opportunistic call attempt failed, DB not readable

 

I followed the wiki
http://www.sng.ecs.soton.ac.uk/mailscanner/serve/cache/390.html

 

I have set in my spam.assassin .prefs.conf:

bayes_store_module      Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn           DBI:mysql:sa_bayes:remoteMysqlBox
bayes_sql_username      sa_user
bayes_sql_password      sa_password

 

Can someone please tell me what I am doing wrong. 

 

 

 

Kosta Lekas

FREXE

630.482.7142 - office

630.885.9355 - mobile

630.232.6074 - fax

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20060324/c4a87946/attachment.html