Using MySQL as the Bayes store
It looks like there’s another workaround for the Berkeley DB version clash on Dreamhost’s servers, use MySQL as the database instead. I didn’t realise this was an option and came across it on DH’s forums. Someone’s written up a guide to installing SA on DH:
http://www.unsaturated.com/projects.spamassassinMySQL.html
But I didn’t want to install from scratch and thankfully you can import your existing bayes data. From the README.bayes file that is distributed with SA:
- Run ’sa-learn –backup > backup.txt’ which will backup your bayes data into a text file.
- Optionally you can run ’sa-learn –clear’ to remove the DBM based bayes files.
- Modify your local.cf file according to the directions above.
- Run ’sa-learn –restore backup.txt’ to restore your bayes data to the SQL database.
This went without a hitch and my spam filtering is decent again!
