[ANNOUNCE] MySpam - Manage your quarantined SPAM
Mark Lawrence <[email protected]> Thu, 4 Oct 2007 10:10:51 +0200
| Newsgroups | gmane.mail.exim.spamassassin |
|---|---|
| Message-ID | <[email protected]> |
--vkogqOf2sHV7VnPd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 [email protected] 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 --vkogqOf2sHV7VnPd Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="myspam-list.txt" MySpam for [email protected] The following mail is held in quarantine: Date: 2007-10-02 19:23 From: =?koi8-r?B?4czFy9PBzsTS?= <[email protected]> Subject: =?koi8-r?B?9M/Sx8/XwdEgzcHSy8EgliDQz9TSxcLJ1MXM2Dogy8zA3sXX2cUg3A==?= =?koi8-r?B?1MHQ2SDQ0s/E18nWxc7J0Q==?= ID: 3061 To release send mailto:myspam@localhost?subject=Release:3061 Date: 2007-10-02 20:29 From: "Mr. Alexander Borsala" <[email protected]> Subject: THIS IS FOR YOUR ATTENTION. ID: 3062 To release send mailto:myspam@localhost?subject=Release:3062 Date: 2007-10-02 21:52 From: "Peter Egwu" <[email protected]> Subject: Your urgent response needed ID: 3063 To release send mailto:myspam@localhost?subject=Release:3063 Date: 2007-10-02 21:57 From: =?koi8-r?B?7sHMz8cuINDMwc4=?= <[email protected]> Subject: =?koi8-r?B?99kgy8HLINLB2iDJ08vBzMkg3NTP1CDTxc3JzsHS?= ID: 3064 To release send mailto:myspam@localhost?subject=Release:3064 Date: 2007-10-03 00:09 From: abdul aheed <[email protected]> Subject: VERY URGENT AND CONFIDENCIAL ID: 3065 To release send mailto:myspam@localhost?subject=Release:3065 Date: 2007-10-03 02:53 From: "Chad Lugo" <[email protected]> Subject: Microsoft Windows Vista Business, collapsible ID: 3066 To release send mailto:myspam@localhost?subject=Release:3066 Date: 2007-10-03 03:16 From: "PayPal"<[email protected]> Subject: Notification from Billing Departament ID: 3067 To release send mailto:myspam@localhost?subject=Release:3067 Date: 2007-10-03 05:22 From: "Muriel K. Figueroa" <[email protected]> Subject: have ShortDick? Safe, effective and 100% natural way to add 1-4 inches m071rp16bb ID: 3068 To release send mailto:myspam@localhost?subject=Release:3068 Date: 2007-10-03 05:39 From: St. George Online <[email protected]> Subject: Your Account Is Blocked ID: 3069 To release send mailto:myspam@localhost?subject=Release:3069 Date: 2007-10-03 05:57 From: "EMMANUEL ABALO" <[email protected]> Subject: Lets partner to pull this through ID: 3070 To release send mailto:myspam@localhost?subject=Release:3070 Date: 2007-10-03 08:46 From: "MR. WILLIAM R. HOWELL" <[email protected]> Subject: OPPORTUNITY FROM EXXONMOBIL LONDON ID: 3071 To release send mailto:myspam@localhost?subject=Release:3071 Date: 2007-10-03 11:04 From: "claude guillette" <[email protected]> Subject: claude guillette ID: 3072 To release send mailto:myspam@localhost?subject=Release:3072 Date: 2007-10-03 11:34 From: "Senator Jubril Aminu" <[email protected]> Subject: Sent 3rd October 2007 ID: 3073 To release send mailto:myspam@localhost?subject=Release:3073 Date: 2007-10-03 12:28 From: =?koi8-r?B?6fPvIDkwMDE6MjAwMA==?= <[email protected]> Subject: =?koi8-r?B?UmU6IOTPy9XNxc7UydLP18HOycUg8+3rINDPIElTTyA5MDAxOjIwMA==?= =?koi8-r?B?MA==?= ID: 3074 To release send mailto:myspam@localhost?subject=Release:3074 Date: 2007-10-03 12:44 From: Royal Heritage Mega Jackpot Lottery <[email protected]> Subject: LICENSED. ONLINE BALLOT LOTTERY ID: 3075 To release send mailto:myspam@localhost?subject=Release:3075 Date: 2007-10-03 12:49 From: deco kelvin <[email protected]> Subject: Mr Deco Kelvin ID: 3076 To release send mailto:myspam@localhost?subject=Release:3076 Date: 2007-10-03 14:04 From: [email protected] Subject: CONGRATULASTION,YOU HAVE WON A LOTTERY ID: 3077 To release send mailto:myspam@localhost?subject=Release:3077 Date: 2007-10-03 16:12 From: HALIMA AHMED <[email protected]> Subject: PLS BE OUR GUADIAN FROM HALIMA,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ID: 3078 To release send mailto:myspam@localhost?subject=Release:3078 Date: 2007-10-03 19:06 From: MySpam <[email protected]> Subject: Re: list ID: 3079 To release send mailto:myspam@localhost?subject=Release:3079 Date: 2007-10-03 19:06 From: [email protected] (Mail Delivery System) Subject: Undelivered Mail Returned to Sender ID: 3080 To release send mailto:myspam@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@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@localhost Response generated in 0.148 seconds --vkogqOf2sHV7VnPd Content-Type: text/html; charset=utf-8 Content-Disposition: attachment; filename="myspam-list.html" Content-Transfer-Encoding: 8bit <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <title>MySpam Response</title> <style type="text/css"> body { padding: 1em; font:85% Verdana,Tahoma,Arial,sans-serif; } h1 { font-size: 120%; } h2 { font-size: 100%; } table#quarantine { border: solid 1px #a0a0a0; width: 100%; } .odd { } .even { } th { text-align: left; background: #cfcfcf; white-space: nowrap; } th,td { padding-left: 0.5em; padding-right: 0.5em; vertical-align: top; border-bottom: solid 1px #d0d0d0; } td.date, td.released { white-space: nowrap; } .num { text-align: right; } td.whitelist_action { width: 30%; } td.command { font-weight: bold; padding-bottom: 1em; } .error { color: #dd0000; } .timing { font-size: 80%; } </style> </head> <body> <h1>MySpam for [email protected]</h1> <p>The following mail is held in quarantine:</p> <table id="quarantine"> <tr> <th>Date (UTC)</th> <th>From</th> <th>Subject</th> <th>Score</th> <th>Released</th> </tr> <tr class="odd"> <td class="date">2007-10-02 19:23</td> <td class="from">Александр <[email protected]></td> <td class="subject">Торговая марка √ потребитель: ключевые этапы продвижения</td> <td class="num">3.6</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3061">Release:3061</a> </td> </tr> <tr class="even"> <td class="date">2007-10-02 20:29</td> <td class="from">"Mr. Alexander Borsala" <[email protected]></td> <td class="subject">THIS IS FOR YOUR ATTENTION.</td> <td class="num">6.3</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3062">Release:3062</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-02 21:52</td> <td class="from">"Peter Egwu" <[email protected]></td> <td class="subject">Your urgent response needed</td> <td class="num">11.9</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3063">Release:3063</a> </td> </tr> <tr class="even"> <td class="date">2007-10-02 21:57</td> <td class="from">Налог. план <[email protected]></td> <td class="subject">Вы как раз искали этот семинар</td> <td class="num">4.7</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3064">Release:3064</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 00:09</td> <td class="from">abdul aheed <[email protected]></td> <td class="subject">VERY URGENT AND CONFIDENCIAL</td> <td class="num">10.2</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3065">Release:3065</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 02:53</td> <td class="from">"Chad Lugo" <[email protected]></td> <td class="subject">Microsoft Windows Vista Business, collapsible</td> <td class="num">15.9</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3066">Release:3066</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 03:16</td> <td class="from">"PayPal"<[email protected]></td> <td class="subject">Notification from Billing Departament</td> <td class="num">17.0</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3067">Release:3067</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 05:22</td> <td class="from">"Muriel K. Figueroa" <[email protected]></td> <td class="subject">have ShortDick? Safe, effective and 100% natural way to add 1-4 inches m071rp16bb</td> <td class="num">18.3</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3068">Release:3068</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 05:39</td> <td class="from">St. George Online <[email protected]></td> <td class="subject">Your Account Is Blocked</td> <td class="num">2.9</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3069">Release:3069</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 05:57</td> <td class="from">"EMMANUEL ABALO" <[email protected]></td> <td class="subject">Lets partner to pull this through </td> <td class="num">7.8</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3070">Release:3070</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 08:46</td> <td class="from">"MR. WILLIAM R. HOWELL" <[email protected]></td> <td class="subject">OPPORTUNITY FROM EXXONMOBIL LONDON</td> <td class="num">4.3</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3071">Release:3071</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 11:04</td> <td class="from">"claude guillette" <[email protected]></td> <td class="subject">claude guillette</td> <td class="num">3.0</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3072">Release:3072</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 11:34</td> <td class="from">"Senator Jubril Aminu" <[email protected]></td> <td class="subject">Sent 3rd October 2007</td> <td class="num">4.2</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3073">Release:3073</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 12:28</td> <td class="from">ИСО 9001:2000 <[email protected]></td> <td class="subject">Re: Документирование СМК по ISO 9001:2000</td> <td class="num">3.6</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3074">Release:3074</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 12:44</td> <td class="from">Royal Heritage Mega Jackpot Lottery <[email protected]></td> <td class="subject">LICENSED. ONLINE BALLOT LOTTERY</td> <td class="num">4.6</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3075">Release:3075</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 12:49</td> <td class="from">deco kelvin <[email protected]></td> <td class="subject">Mr Deco Kelvin</td> <td class="num">6.3</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3076">Release:3076</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 14:04</td> <td class="from">[email protected]</td> <td class="subject">CONGRATULASTION,YOU HAVE WON A LOTTERY</td> <td class="num">13.8</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3077">Release:3077</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 16:12</td> <td class="from">HALIMA AHMED <[email protected]></td> <td class="subject">PLS BE OUR GUADIAN FROM HALIMA,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,</td> <td class="num">11.3</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3078">Release:3078</a> </td> </tr> <tr class="odd"> <td class="date">2007-10-03 19:06</td> <td class="from">MySpam <[email protected]></td> <td class="subject">Re: list</td> <td class="num">6.5</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3079">Release:3079</a> </td> </tr> <tr class="even"> <td class="date">2007-10-03 19:06</td> <td class="from">[email protected] (Mail Delivery System)</td> <td class="subject">Undelivered Mail Returned to Sender</td> <td class="num">12.2</td> <td class="released"> <a href="mailto:myspam@localhost?subject=Release:3080">Release:3080</a> </td> </tr> </table> <p>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@localhost and paste the 'Release:12345678910' text (without the quotes) into the subject field. <h2>Current Whitelist</h2> <p>None </p> <h2>Subscription Status</h2> <p>None </p> <p>If you have questions about this mail recovery mechanism please contact your local IT support or <a href="mailto:postmaster@localhost">postmaster@localhost</a> </p> <p class="timing">Response generated in 0.148 seconds</p> </p> </body> </html> <!-- XML::API v0.14 --> --vkogqOf2sHV7VnPd Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ SA-Exim mailing list [email protected] http://lists.merlins.org/lists/listinfo/sa-exim --vkogqOf2sHV7VnPd--