Hello... this is a follow up to my last post where I promised to post a URL for the script that runs the various omshowpdl commands and whips up a virtusertable for Sendmail.
It's intended use is with the Spamdigester (
http://spamdigester.org), a set of PHP scripts and wrappers around Sendmail, SpamAssassin, Spamass-milter, and ClamAV that acts as a FOSS perimeter email 'firewall'. It takes every email coming into an organization, and runs it through SpamAssassin. If the message is tagged as spam, then the email is sent to a quarantine area (a MySQL database).
Periodically, a query is run that generates a digest email in HTML format that has radio buttons for each message: Reject, Accept, and Accept and Whitelist. The user submits the form with either the button at the bottom of the email (if their email client allows such foolishness), or by opening the Digest up in a webpage hosted on the Spamdigester system. The SpamDigester is entirely made up of Free and Open Source Software, and utilizes spamAssasin's MySQL userprefs and whitelist functionality. It is currently not trivial to set up, although we're working on that. Feel free to contact me with any questions you may have in setting it up!
The SpamDigester is a Client/ Server application, using XMLRPC in the background, and includes nifty features like database pruning etc..
On to the Scalix integration script... I've added to it the ability to have locally delivered addresses on the Digester server, plus addresses that are ignored on the Digester (i.e. addresses that are only allowed to be used locally on the Scalix server, either via Outlook or SWA, but are not available for public (spam) consumption). An example would be an address like
staff@domain.com. It also loops through public distribution groups in addition to individual users.
The script can be found here:
http://thatitguy.com/downloads/mkVirtUsertable.php.txt
I would appreciate any thoughts or input you may have! Happy Spam killing!