So everyone knows I like SpamAssassin. Anyone with a hosting account on prime also knows that the prefs are stored in a SQL
database on another server quark.
About two days after I switched over to this system, I wrote a simple tool, UpdatePrefs, that basically takes your
user_prefs file from spamassassin and dumps them up to the database server. (It can also "fetch" your rules, for legacy
compatibility -- I wanted a way out if I had to abandon the SQL thing).
Naturally, when I write a util like this, I post to the SpamAssassin mailing list. No response whatsoever.
I FINALLY heard from SOMEONE about this a couple days ago:
[11:53:59] * trjh [User] is now online =)
[11:53:59] trjh: hello. if you wouldn't mind, i'd like to ask you about the updateprefs.pl script you mentioned in May '05
on the spamassassin-users mailing list?
[11:53:59] -larpGM- [Away for 9:47m] Must have stepped out...
[11:56:31] larpGM: Heya
[11:56:37] larpGM: about time I heard from someone on that.
[11:57:09] trjh: i'm just converting my own personal setup to use sql (hoping it'll speed up the dog-slow performance on my
7-yr-old freebsd box)
[11:57:36] trjh: it's taken me half an hour to find any reference to anything like that. i'm shocked your script isn't in
the spamassassin distribution and mentioned in the README.
[11:58:15] trjh: anyway, i ask because it isn't where you said it was then :) (www.gushi.org/updateprefs.pl)
[12:11:22] larpGM: Gimme a sec, lemme see if I can find it.
[12:13:23] trjh: np, thank you.
[12:14:11] larpGM: as a warning, it's still slightly unpolished.
[12:15:36] larpGM: http://www.gushi.org/updateprefs.pl
[12:15:52] larpGM: it was actually symlinked to the binary, which I moved from updateprefs.pl to updateprefs
[12:16:07] trjh: not a worry, thank you!
[12:17:24] larpGM: it's short and relatively sweet
[12:17:48] larpGM: also, I found when I moved to SQL, I just had to accept the reality that my bayes corpus had to be rebuilt.
[12:18:15] larpGM: but then, mine were huge
[12:18:15] trjh: sa-learn --restore didn't do the trick?
[12:20:21] larpGM: nope
[12:20:28] larpGM: I cut my losses, this was a while ago too
[12:21:24] trjh: would you mind if i put a reference to your message & script here?
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadme ("Dan Mahoney wrote a perl script to convert user_prefs
from file to database format. He mentions it here and it can be found here.")
[12:23:12] larpGM: Sure.
[12:23:14] larpGM: feel free
[12:23:38] larpGM: I'm generally very embittered with the SA mailing lists. I post intelligent things, and get no response.
[12:23:43] larpGM: I post errors, get no response.
[12:25:49] larpGM: keeping in mind you're the first person who's asked about this should-be-commonsense utility in as longas
it's been since I wrote this.
[12:48:08] trjh: maybe nobody upgrades. maybe they all write it from scratch :)
[12:48:42] larpGM: possibly
[12:48:47] larpGM: note when I posted it.
[12:49:02] trjh: i did alright.
[13:03:57] trjh: duly updated. you might add a comment or two at the top of your script, something like i've just added on
my local copy:
[13:04:00] trjh: # written by Dan Mahoney
[13:04:03] trjh: # http://www.gushi.org/updateprefs.pl
[13:04:21] trjh: anyway, you're now closer to the SA canon than you were before :)
Ah well, better late than never I suppose.