[SA-exim] [ANNOUNCE] MySpam - Manage your quarantined SPAM

[Mark Lawrence]

Have you been wondering what to do with that ever growing collection of
files building up in /var/spool/sa-exim/SApermreject/new? Does
SpamAssassin occasionally generate a false positive that you need to
recover? Then perhaps MySpam is for you.

I've built an application that stores sa-exim quarantined mails in a
database, and lets users query that database to list or recover mails.
There is both an email interface to the database and a command-line
interface.

I've attached an example email response (that comes in both text/plain
and text/html parts) to the 'list' command.


MySpam is written entirely in Perl and runs efficiently on my personal
server with an SQLite backend. It is also running on three SMTP
gateways supporting over 25,000 addresses with a single MySQL backend.
Most likely it also works with PostgreSQL but that hasn't been tested.

All modules and scripts are fully documented and licensed under the GPL.

You can obtain/install MySpam manually from CPAN:

  $ wget http://search.cpan.org/CPAN/authors/id/M/ML/MLAWREN/MySpam-0.05.tar.gz
  $ tar zxf MySpam-0.05.tar.gz
  $ cd MySpam-0.05
  $ perl Makefile.PL
  $ make install

Automatically install MySpam from CPAN

  $ sudo perl -MCPAN -e 'install MySpam'

Or if you run a Debian derivative you can add
'deb http://rekudos.net stable main' to /etc/apt/sources.list and run:

  $ sudo apt-get update
  $ sudo apt-get install myspam


The first two options will probably need some post-installation effort
for cron(8) files, permissions and/or exim integration.

Once things are installed you can send a mail to myspam at your.domain with
the subject 'help', or jump right in with the myspam(1) manpage.

I welcome any feedback, comments and/or installation stories. Patches
for bugs or RPM packaging will also get your name in the credits :-)

Regards,
Mark.
-- 
Mark Lawrence
-------------- next part --------------
MySpam for root at rekudos.net


The following mail is held in quarantine:


    Date: 2007-10-02 19:23
    From: =?koi8-r?B?4czFy9PBzsTS?= <decipherspa6 at csciences.com>
 Subject: =?koi8-r?B?9M/Sx8/XwdEgzcHSy8EgliDQz9TSxcLJ1MXM2Dogy8zA3sXX2cUg3A==?= =?koi8-r?B?1MHQ2SDQ0s/E18nWxc7J0Q==?=
      ID: 3061

To release send mailto:myspam at localhost?subject=Release:3061


    Date: 2007-10-02 20:29
    From: "Mr. Alexander Borsala" <alexanderborsala1 at yahoo.es>
 Subject: THIS IS FOR YOUR ATTENTION.
      ID: 3062

To release send mailto:myspam at localhost?subject=Release:3062


    Date: 2007-10-02 21:52
    From: "Peter Egwu" <info2424 at poczta.onet.pl>
 Subject: Your urgent response needed
      ID: 3063

To release send mailto:myspam at localhost?subject=Release:3063


    Date: 2007-10-02 21:57
    From: =?koi8-r?B?7sHMz8cuINDMwc4=?= <legendsqao at dlawton.com>
 Subject: =?koi8-r?B?99kgy8HLINLB2iDJ08vBzMkg3NTP1CDTxc3JzsHS?=
      ID: 3064

To release send mailto:myspam at localhost?subject=Release:3064


    Date: 2007-10-03 00:09
    From: abdul aheed <abdul_aheed101011 at hotmail.fr>
 Subject: VERY URGENT AND CONFIDENCIAL
      ID: 3065

To release send mailto:myspam at localhost?subject=Release:3065


    Date: 2007-10-03 02:53
    From: "Chad Lugo" <keqg at brandysgiftshop.com>
 Subject: Microsoft Windows Vista Business, collapsible
      ID: 3066

To release send mailto:myspam at localhost?subject=Release:3066


    Date: 2007-10-03 03:16
    From: "PayPal"<accounts at paypal.us>
 Subject: Notification from Billing Departament
      ID: 3067

To release send mailto:myspam at localhost?subject=Release:3067


    Date: 2007-10-03 05:22
    From: "Muriel K. Figueroa" <k_figueroa_nk at ups.com>
 Subject: have ShortDick? Safe, effective and 100% natural way to add 1-4 inches m071rp16bb
      ID: 3068

To release send mailto:myspam at localhost?subject=Release:3068


    Date: 2007-10-03 05:39
    From: St. George Online <customerservice at st.george.com.au>
 Subject: Your Account  Is Blocked
      ID: 3069

To release send mailto:myspam at localhost?subject=Release:3069


    Date: 2007-10-03 05:57
    From: "EMMANUEL ABALO" <emmanuelabalo at xemail.de>
 Subject: Lets partner to pull this through 
      ID: 3070

To release send mailto:myspam at localhost?subject=Release:3070


    Date: 2007-10-03 08:46
    From: "MR. WILLIAM R. HOWELL" <bbrown23 at mail.csuchico.edu>
 Subject: OPPORTUNITY FROM EXXONMOBIL LONDON
      ID: 3071

To release send mailto:myspam at localhost?subject=Release:3071


    Date: 2007-10-03 11:04
    From: "claude guillette" <claude_guillette_1936 at latinmail.com>
 Subject: claude guillette
      ID: 3072

To release send mailto:myspam at localhost?subject=Release:3072


    Date: 2007-10-03 11:34
    From: "Senator Jubril Aminu" <committee_record1 at yahoo.it>
 Subject: Sent 3rd October 2007
      ID: 3073

To release send mailto:myspam at localhost?subject=Release:3073


    Date: 2007-10-03 12:28
    From: =?koi8-r?B?6fPvIDkwMDE6MjAwMA==?= <verdictoez at cajunnet.net>
 Subject: =?koi8-r?B?UmU6IOTPy9XNxc7UydLP18HOycUg8+3rINDPIElTTyA5MDAxOjIwMA==?= =?koi8-r?B?MA==?=
      ID: 3074

To release send mailto:myspam at localhost?subject=Release:3074


    Date: 2007-10-03 12:44
    From: Royal Heritage Mega Jackpot Lottery <heritage at yahoo.co.uk>
 Subject: LICENSED. ONLINE BALLOT LOTTERY
      ID: 3075

To release send mailto:myspam at localhost?subject=Release:3075


    Date: 2007-10-03 12:49
    From: deco kelvin <decokelvin15 at hotmail.co.uk>
 Subject: Mr Deco Kelvin
      ID: 3076

To release send mailto:myspam at localhost?subject=Release:3076


    Date: 2007-10-03 14:04
    From: INFOBOX80 at aol.in
 Subject: CONGRATULASTION,YOU HAVE WON A LOTTERY
      ID: 3077

To release send mailto:myspam at localhost?subject=Release:3077


    Date: 2007-10-03 16:12
    From: HALIMA AHMED <halimaggahmed at hotmail.fr>
 Subject: PLS BE OUR GUADIAN FROM HALIMA,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
      ID: 3078

To release send mailto:myspam at localhost?subject=Release:3078


    Date: 2007-10-03 19:06
    From: MySpam <myspam at rekudos.net>
 Subject: Re: list
      ID: 3079

To release send mailto:myspam at localhost?subject=Release:3079


    Date: 2007-10-03 19:06
    From: MAILER-DAEMON at spf16.us4.outblaze.com (Mail Delivery System)
 Subject: Undelivered Mail Returned to Sender
      ID: 3080

To release send mailto:myspam at localhost?subject=Release:3080


Some mail clients (particularly Blackberries, and certain WebMail
applications) will not generate the correct email when you click on the
release link. In this situation simply copy the 'Release:12345678910'
text into the clipboard. Then compose a new email using your mail client
to myspam at localhost and paste the Release:12345678910' text
(without the quotes) into the subject field.

Current Whitelist
 None

Subscription Status
 None


If you have questions about this mail recovery mechanism
 please contact your local IT support or postmaster at localhost

Response generated in 0.148 seconds
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.merlins.org/archives/sa-exim/attachments/20071004/bfbf762b/attachment-0001.html