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....

[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.

Scott, I read someplace that you set some configurations in the mySql db.. where would those be set please..

Using your latest spamassassin rpm's.

Check out the spamassassin site (used to be called readme.mysql I think), or if you use the squirrelmail rpm it will create the mysql tables and settings for you.

Will these instructions work for your RPM's?

http://forum.ev1servers.net/showthread.php?t=50247

I installed the squirrelmail rpm from you but not sure if it created these two tables, sa_conf and sa_list.

I'm also looking at the spamassassin site..

I'm trying to setup the MySQL connection and this is what I got from: http://spamassassin.apache.org/doc.html about setting up the db. :

In order for SpamAssassin to work with your SQL database, you must have the perl DBI module installed, AS WELL AS the DBD driver/module for your specific database. For example, if using MySQL as your RDBMS, you must have the Msql-Mysql module installed. Check CPAN for the latest versions of DBI and your database driver/module.

We are currently using:

DBI-1.20
Msql-Mysql-modules-1.2219
perl v5.6.1

the site says to get the Msql-Mysql-modules from cpan but I've read that your rpms are not compatible with cpan? I might be confused here.

This is the error message I'm getting which prompted me to look at the msql-mysql-modules ...

[29375] dbg: replacetags: replacing tags
[29375] dbg: replacetags: done replacing tags
[29375] dbg: bayes: using username: root
[29375] dbg: bayes: database connection established
[29375] dbg: bayes: found bayes db version 3
[29375] dbg: bayes: unable to initialize database for root user, aborting!
[29375] dbg: config: score set 1 chosen.
[29375] dbg: bayes: database connection established
[29375] dbg: bayes: found bayes db version 3
[29375] dbg: bayes: unable to initialize database for root user, aborting!
ERROR: Bayes dump returned an error, please re-run with -D for more information
[root@gz spamassassin]# cd /

This is my MySQL install:

[root@gz spamassassin]# rpm -qa |grep Mysql
[root@gz spamassassin]# rpm -qa |grep mysql
mysql-server-(none)-4.1.14-1.rhel3.art
mysql-debuginfo-(none)-4.0.20-art.2
mysql-devel-(none)-4.1.14-1.rhel3.art
php-mysql-(none)-4.4.0-3.rhel3.art
libdbi-dbd-mysql-(none)-0.6.5-5
mysql-(none)-4.1.14-1.rhel3.art
mysql-compat-(none)-4.1.14-1.rhel3.art
[root@gz spamassassin]#


any help would be appreciated,
Thanks.

I am also getting this error msg when I do a spamassassin --lint -D

[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!

Are you trying to store Bayes in mysql or in the file system? The way I debug things is to run spamd in the foreground so I can see the raw debug messages (-D). The squirrelmail package doesnt set up the bayes or awl mysql DB's. Or at least I think so, I haven't looked at it in over a year.

I was trying to setup Bayes/spamassassin to use a mysql spamassassin db. The reason I did this, is because I thought I read that you recommended that kind of a setup. So.. After reading the spamassassin site and someone at ev1 forums saying why don't you set it up this way.. I endevored to do that. Still being a novice I try and read as much and google as much as I can for self help. However this one is stumping me.

System is PSA 7.5, RHE3, latest spamassassin rpm from you with qmail-scanner and clamd.

I setup the DB and when I look at bayes_vars table, I'm seeing it get populated with each mail user on the server and the spam_count / ham_count's going up. I just want to be sure everything is working as it should.

So, how do I run spamd in the forground? Do I just issue the spamd -D and let it run? should it take me back to a prompt?

Thanks.

yep exactly, run spamd -D <whatever other options you'd use>.

Also keep in mind that bayes wont kick in until you've got 200 spam/200 ham messages for the user its looking at.

Ok, getting this atm:


Killed the spamd -D and just started spamasssin service, then did:


Should I pass to spamd these switchs also? -d -u qmailq -q -x -c -H /var/qmail/ ?

Yep, except replace -d with -D

Ok, thanks for that claification. I was running both -d and -D on that last command.. now I'm at the [2121] info: prefork: child states: II and it is waiting for something now I guess. When I ran both it took me back to a command prompt.

Humm, gettting this again..

I dont suppose you've got any file systems out of drive space do you? If you're on a 1and1 box they have this annoying habit of sticking /var on its own partition.

Device Boot Start End Blocks Id System
/dev/hda1 * 1 13 104391 83 Linux
/dev/hda2 14 270 2064352+ 82 Linux swap
/dev/hda3 271 9729 75979417+ 83 Linux

EV1 server...

contents of fstab:

/dev/hda3 / ext3 defaults,usrquota 1 1
/dev/hda1 /boot ext3 defaults 1 2
/dev/hda2 swap swap defaults 0 0
none /proc proc defaults 0 0
none /dev/shm tmpfs defaults 0 0
none /dev/pts devpts gid=5,mode=620 0 0

[root@gz /]# df var
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda3 74786624 16341532 54646124 24% /
[root@gz /]#