Col skrev, on 13-08-2007 15:15:
I currently have about 10 dspam users with varying levels of training.
I do have one account which has a great deal of training and I would
like to use this data and create a single group so that all my users can
benefit.
How would I start this progress?
Well, what I'd do (and what I have done in the past, with 1,500 users
and an unmanageable 15GB MySQL InnoDB database), was to create a shared
group.
Then I took one single user (all had more or less the same tokens due to
their corpus training and their own laziness in training) and
dspam_merge'd that to the group. Then I dropped all the users but the
group and mysqldumped the MySQL database to a "text" DB file, dropped
the database, created a new DB with the same name and added the "text"
dump file to the DB.
No, I'm by far from being a MySQL DBA, but I'm good at reading html docs
(even those as huge as the MySQL manual) and getting what I want out of
them. And putting that into practice.
Now I have a 140MB MySQL *everything* (including Postfix Policyd and
SquirrelMail) MySQL InnoDB dspam DB. I lie, Policyd is MyISAM (Fie, og
fie, Cami).
And I'm satisfied with the spam group performance. I've weighed up in a
few ways against my lazy users' lack of willing to do anything about
training dspam or looking at their quarantine directories by writing
simple shell scripts having my virtual IMAP user nag, nag, nag each user
who can't be bothered, every day, till they get sick of it and either
drop my site's email service or do something about that.
No, my setup's a Postfix dspam/Courier IMAP hybrid that doesn't conform
to Jonz' original concept with CGI 'nall, but I'm (more or less) pleased
with my own adaption. By and all I consider it better than his, but only
'cos I'm running (Courier) IMAP (and maildrop) for all my sites.
Very greatful for any help.
Well, s/greatful/grateful/g
Best,
--Tonni
--
Tony Earnshaw
Email: tonni at hetnet dot nl
