Popfile and Misspelled Words

I am having a heck of a time with Popfile these days.  My accuracy is way, way down lately.

Good news! I found the problem. It had nothing to do with Popfile per se, but my setup. Imagine that!

Looking through the word lists, there were tons of misspelled words in my Ham bucket.  Seeing another nail that needed a hammer, I wrote a script that moves misspelled words into the spam bucket.

If it helps anyone else, I’ve attached the script. here

This script requires an ODBC DSN to the SQLite database.  (That’s a mouthful!)  It will definitely work in Linux.  Other platforms?  Dunno.

Feedback is welcome in the comments.

On a side note, popfile in Debian’s repos is ancient.  Get it from popfile’s site. (version 1.1.1 or later!) Also worth noting is popfile’s xmlrpc interface.  Nice!