• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved Spamassassin : bayes: cannot open bayes databases / R/O: tie failed:

surfgatinho

New Pleskian
Have been getting a bit of SPAM so checked the mailog. Found the following error:

Apr 23 12:25:50 XXXX spamd[3974253]: bayes: cannot open bayes databases /var/qmail/mailnames/EXAMPLE.COMk/chris/.spamassassin/bayes_* R/O: tie failed:

I'm guessing it is a permissions issue - any ideas?
 
You can try to verify this database with

# db_verify /var/qmail/mailnames/EXAMPLE.COMk/chris/.spamassassin/bayes_journal

and I suppose that database is corrupted for some reasons.
You could create a list of corrupted Bayes databases in '/root/corrupted_bayes_db.log', using the following command:

Code:
# echo "" > ~/corrupted_bayes_db.log; for i in $(ls /var/qmail/mailnames/*/*/.spamassassin/bayes_*); do db_verify -oq $i >/dev/null 2>&1; echo plesktest $? $i | tail -n1 | grep "plesktest 1" | cut -d' ' -f3- >> ~/corrupted_bayes_db.log; done

To resolve the issue you may remove the affected databases, so they will be properly re-created during further SpamAssassin operations:

Code:
# for i in $(cat /root/corrupted_bayes_db.log); do rm -f $i; done
# systemctl restart spamassassin
 
Back
Top