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

[surfgatinho]

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?

 

[IgorG]

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:

# 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:

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

 

[kastor]

IgorG you made my day like often! Thank you for sharing your knowledge!