Ok, after deleting my bayes db from the following location, it still hasn't been recreated and I know I'm missing something. I've removed and reinstalled spamassassin, psa-spamassassin, qmail-scanner. I have rules_du_Jour installed. I've looked all over for what should be in the local.cf file and I'm stuck. Reason I did this is this message:

[root@gz .spamassassin]# sa-learn --dump magic -C /var/qmail/.spamassassin/
ERROR: Bayes dump returned an error, please re-run with -D for more information
[root@gz .spamassassin]#

Was told to delete the bayes in /var/qmail/.spamassasin to fix this problem...

[root@gz .spamassassin]# pwd
/var/qmail/.spamassassin
[root@gz .spamassassin]#

Here is my local.cf:

[root@gz sbin]# more /etc/mail/spamassassin/local.cf
user_scores_dsn DBI:mysql:horde:localhost
user_scores_sql_username XXXXXXXXXX
user_scores_sql_table userpref
user_scores_sql_password XXXXXXXXXX
bayes_auto_learn 1
bayes_auto_learn_threshold_nonspam 0.1
bayes_auto_learn_threshold_spam 12.0

I added the bayes part..

what should be in this file or what should it look like please.

Err ... did you set a bayes_path?

You might wanna take a look at http://forum.ev1servers.net/showthread.php?t=50247 for setting it up in SQL --- much faster.

Used ART's rpms on this.. where would the bayes path be set? I've got

/var/qmail/mailnames/domainname/mailname/.spamassassin/bayes_toks
/var/qmail/mailnames/domainname/mailname/.spamassassin/bayes_seen

paths, and I had the bayes in the /var/qmail/.spamassassin dir.. so I'm not sure on this..

I'll check on ART's site because I read something that said he configures spamassassin in mysql also.. so want to be sure I'm not crossing myself up.

Thanks for the post.

Well, you'll have those files for each and every user on your box that SA runs as. It's kind of nasty --- so, yeah, /home/dir/.spamassassin is the default (been a while since I've used it).

As far as that goes --- do a `spamassassin --lint -D` ... it's gonna dump out a lot more information about what exactly isn't right. If it's not recreating the files, it could be a permissions problem on the .spamassasin dir, so the debug should fill you in.

Here are the excerpts from my spamassassin --lint -D log that produced errors:

[1305] dbg: replacetags: replacing tags
[1305] dbg: replacetags: done replacing tags
[1305] dbg: bayes: using username: root
[1305] dbg: bayes: database connection established
[1305] dbg: bayes: found bayes db version 3
[1305] dbg: bayes: unable to initialize database for root user, aborting!

[1157] warn: lint: 1 issues detected, please rerun with debug enabled for more information
[root@gz spamassassin]#


Catalyst, did you get this working with PSA 7.5 ?

Thanks.

The Bayes thing is independent of the control panel -- you're just changing the storage method from slow file-based to fast SQL based.

But at the same time ... I'm not a Plesk guru, nor do I claim to be. So long as you edit the local.cf that Plesk uses, you should be fine.

BTW ... Whatever is happening, SA doesn't have the permissions necessary to create the Bayes Store. In the last example and log entry you gave, the bayes_user is root, and it can't create the /root/.spamassassin/bayes_* files it needs for Bayes.

so, where is the bayes user set?