OK, probably a long message. Here's a summary: I have PostFix + MySQL + Amavisd-New + ClamAV +Dovecot + (SquirrelMail and IMP) + PostFix.Admin all working together well using virtual domains stored in MySQL.
I can't find a good clear HOWTO for getting SpamAssassin plugged into the mix to allow per-user preferences with the ability for the users to set their own prefs using something like one of the SquirrelMail plugins. I would actually prefer using a SEPARATE (not a webmail plugin) web enabled method for users to set preferences so those who won't be using webmail at all would have easy access to a "point and click" preferences page. Now the long background message. I work for a small ISP. When I started work here there was already a Windows based mail server in place with no spam scanning at all. I suggested moving away from that a few years ago before the company grew much. Never happened. We did add spam scanning but it has no way to easily do per-user settings so I, as the mail admin, get to try to keep the settings tweaked by hand at the domain level to keep out the worst spam and not block valid email. that was working OK at about 100K/day inbound. I was sending about 60K to /dev/nul and figure about 30K to 37K more were spam that got through. But the Windows based server was having trouble keeping up and I kept suggesting getting away from it. A couple of weeks ago we got hit by a spam-storm that bumped up up to over 500K inbound and the mail server gorfed in a bad way. Now I get to replace it while working in "Oh SH**!" mode. I need to have it working by the first week of May so I have a few weeks. And as stated above, I already have most of it working. Right now I'm building this all on a single server. When it's done and I have the user base moved over I'm going to rebuild the current mail server box and move Amavis + ClamAV + SA over there to act as a gateway. I need it all working well with MySQL so I can leave the database and IMAP server on the current machine and at some point I'd like to be able to figure out how to do domain level markup as a gateway for a few hosted domains that will stay on another Win based server until I have time to rebuild it (that server is still very low volume with only small "family type" domains hosted for some of our customers). I have googled until my eyes are as white as the monitor screen. I keep finding bits and pieces of how to get SA working with MySQL but nothing that clearly describes getting it working with Amavisd-New and what it needs in a database. I'd like to put all the info into a single database and I want both domain-wide and customer pref whitelist/blacklist and customer pref Bayes to work. I'm a bit wary of auto-whitelist -- it would be nice if I could get it set up so a customer's server side (webmail) address book would be read as a whitelist. Can someone point me to a "definitive guide"? Should I try to locate a local copy of the O'Reilly SA book to buy (I'm sort of in a backwater area - buying a copy without using mail order might take a 4 hour round trip drive). Thanks all, Gerald
