Saturday, November 15, 2008

spamassassin (or spamd) fails while accessing bayes databases - R/O: tie failed: Transport endpoint is not connected

just found lines like these in the spamd.log (i.e. spamassassin was not able to use the bayes databases any more...)
warn: bayes: cannot open bayes databases /.../.spamassassin/bayes_* R/O: tie failed: No such file or directory
...
warn: bayes: cannot open bayes databases /.../.spamassassin/bayes_* R/O: tie failed:
warn: bayes: cannot open bayes databases /.../.spamassassin/bayes_* R/O: tie failed: Transport endpoint is not connected
the problem seemed to have been a mismatch in used versions of the BereklyDB files (don't know how exactly they got mixed up...)
anyways, the following commands helped:
for i in auto-whitelist bayes_*; do db4.6_dump ${i} | db4.3_load ${i}.db; chown Debian-exim:Debian-exim ${i}.db; chmod g-rwx ${i}.db; done;
mmv '*.db' '#1'
after that one may check/sync/rebuild the databases along the lines of:
sudo -u Debian-exim sa-learn -u USERNAME --rebuild --dbpath /.../.spamassassin/ -D
some inspiration cam from this thread: http://lists.debian.or.jp/debian-users/200601/msg00113.html

No comments: