bayes: cannot open bayes databases

Discussion in 'General' started by newfield_no1, Nov 30, 2010.

  1. newfield_no1

    newfield_no1 New Member

    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?
     
  2. falko

    falko Super Moderator ISPConfig Developer

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

    newfield_no1 New Member

    Hi.

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

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    ls -la /var/www/web6/.spamassassin/
    ?
     
  5. newfield_no1

    newfield_no1 New Member

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

    falko Super Moderator ISPConfig Developer

    The permissions are identical. :confused: Maybe the different versions of DB_File are really the problem...
     
  7. newfield_no1

    newfield_no1 New Member

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

    falko Super Moderator ISPConfig Developer

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

    newfield_no1 New Member

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

    newfield_no1 New Member

    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?
     
  11. falko

    falko Super Moderator ISPConfig Developer

  12. newfield_no1

    newfield_no1 New Member

    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?
     
  13. falko

    falko Super Moderator ISPConfig Developer

    That should work.
     
  14. newfield_no1

    newfield_no1 New Member

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

    newfield_no1 New Member

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

    newfield_no1 New Member

    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?
     
  17. falko

    falko Super Moderator ISPConfig Developer

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

Share This Page