bayes: cannot open bayes databases

I have moved my Ispconfig 2 setup to a new server.
Then I get errors in mail.warn but it lokks as it works any way, both I and oter accounts get their mail.
The errors is like this:
spamd[6520]: bayes: cannot open bayes databases /var/www/web6/.spamassassin/bayes_* R/O: tie failed:
spamd[6520]: bayes: bayes db version 0 is not able to be used, aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/DBM.pm line 196.
spamd[2657]: auto-whitelist: open of auto-whitelist file failed: auto-whitelist: cannot open auto_whitelist_path /var/www/web50/user/web50_****/.spamassassin/auto-whitelist: No such file or directory

The files is there and it is the same user as at the old server.
One thing I suspect is the DB_version.

When i run:
spamassassin 2>&1 -D --lint | less
The old server has: DB_File, version 1.814
And the new server has: DB_File, version 1.82

Is there some solution to this?

 

Which distributions do you use on the old and the new server?

 

Hi.

I use Ubuntu 8.04 and Ispconfig 2.2.37.
The same on both the old and new server.

 

What's the output of

Code:

ls -la /var/www/web6/.spamassassin/

?

 

On the new server:
-rw------- 1 web6_tevensso web6 335872 2010-12-01 01:01 auto-whitelist
-rw------- 1 web6_tevensso web6 32688 2010-01-08 14:31 bayes_journal
-rw------- 1 web6_tevensso web6 1318912 2010-01-08 13:56 bayes_seen
-rw------- 1 web6_tevensso web6 5234688 2010-01-08 13:56 bayes_toks
lrwxrwxrwx 1 root root 44 2010-11-25 21:41 user_prefs -> /var/www/web6/user/web6_tevensso/.user_prefs

On the old server:
-rw------- 1 web6_tevensso web6 335872 2010-01-08 14:31 auto-whitelist
-rw------- 1 web6_tevensso web6 32688 2010-01-08 14:31 bayes_journal
-rw------- 1 web6_tevensso web6 1318912 2010-01-08 13:56 bayes_seen
-rw------- 1 web6_tevensso web6 5234688 2010-01-08 13:56 bayes_toks
lrwxrwxrwx 1 root root 44 2009-08-19 15:58 user_prefs -> /var/www/web6/user/web6_tevensso/.user_prefs

 

The permissions are identical. Maybe the different versions of DB_File are really the problem...

 

I have follwed the same Perfect setup guide on both servers.
Is there a way to update the files to the same version?

 

Maybe you can find the .deb package of DB_File in /var/cache/apt/archives on the old server and install it on the new one.

 

I tryed to run apt-get update, apt-get upgrade on the old server to se if the DB-files would be updated but the DB_file version is still 1.814.
I thougt that it could be that mistake I did before changen to a new server.

In the new server there is a folder:
/root/.cpan/build/DB_File-1.820
But that folder does not exist on the old server.

The new server also has these folders there:
Digest-SHA1-2.13
Digest-SHA-5.48
HTML-Parser-3.68
Net-DNS-0.66

The old server only has this folder:
NetAddr-IP-4.030

Isn't that somethin that ISPconfig creates during setup?
Both servers has ispconfig ver 2.2.37

 

I am looking at the guide for perfect setup of ubuntu 8.04 and the guide Here:

http://www.ispconfig.org/ispconfig-2/installation-instructions-for-ispconfig-2/

And then I found the difference.
At the old server there was no problems when I tested:
/home/admispconfig/ispconfig/tools/spamassassin/usr/bin/spamassassin

But when I set up the new server there was some error so I had to install the Perl modules discribed there.

I have done the same thing at the old server now and then I got DB_File, version 1.82 at that now.

But I dont know if the userfiles are updated and how can I copy all the userfiles from the old server to the new?
Is it possible?

 

What userfiles?

To copy content from one server to the other, you can use rsync: http://www.howtoforge.com/mirroring_with_rsync

 

Now that I have set up the Perl modules on the old server then the users spamassasin files maby is correkt so the files that the new server is complaining about could be replased by them.

The files is:
auto-whitelist
bayes_journal
bayes_seen
bayes_toks

Can I then copy only them by using:
/var/www/web*/user/web*/.spamassassin/b*
and
/var/www/web*/user/web*/.spamassassin/a*

Maby by using this command:
tar -pczf spamfiles.tar.gz /var/www/web*/user/web*/.spamassassin/b*
And:
tar xvfz spamfiles.tar.gz

Or will this destroy everything on the new server?

 

That should work.

 

Now I think I have found the problem with Spamassasin.
On this new server I can se in my mails that it is this version:
SpamAssassin 3.2.4 (2008-01-01)
Isn't Spamassasin installed by Ispconfig?
On another server with simular setup I have:
SpamAssassin 3.3.1 (2010-03-16)

And it is ISPconfig 2.2.37 on both servers.

 

I think an apt-get upgrade solved the problem.
Now I have spamassassin (3.2.4-1ubuntu1.3)

I thought I upgraded the server but maby not.

 

But, Spamassasin is still the same version eaven after a restart of ISPconfig.
Must I restart the whole server to get it to use the new version?

 

ISPConfig 2 comes with its own SpamAssassin (version 3.2.4 in /home/admispconfig/ispconfig/tools/spamassassin).