Email Archiving

Dru has asked for the wisdom of the Perl Monks concerning the following question:

Monks,

I've been tasked to create a method to have all of my team's email archived to a website.

What I was planning on doing, is creating a new generic email address, ie archive@myteamslinuxserver.com, and adding that email address to our team's internal mail group. So anytime someone emails this internal group (ie. MyTeam), a copy of the message is sent to archive@myteamslinuxserver.com and then some super duper software/script retrieves that message from the inbox and post it to a webpage in a listserv type format with search capabilities.

The closes thing that I found is the following: http://sourceforge.net/projects/php-mail-arc/ (written in Perl and PHP), which sounds like exactly what I want, but the downside is it's written for a postgres db while I'm using mysql (I built Apache and PHP to support mysql, not postgres and I'm currently using mysql for a number of other web things and I would prefer not to run two separate databases), plus the code hasn't been updated since 2000!

I'm looking for suggestions before I dive into this code and convert it for mysql and any other Frankenstein modifications which it will undoubtfully need.

P.S. I know this isn't entirely Perl related, but I believe it's Perlish enough (not to get me flamed) and I trust the monks opinion more then anyone else's when it comes to TMTOWTDI type issues.

P.P.S. I did a super search and this Managing a Personal Email Archive is the closes thing I found, but this is more for personal archival and the post is also quite out of date.

Thanks,
Dru

Perl, the Leatherman of Programming languages. - qazwart

Comment on Email Archiving

Replies are listed 'Best First'.
Re: Email Archiving by moritz (Cardinal) on May 31, 2007 at 17:58 UTC
If you already have a mailing list, the list managing program probably already has an archive, you just have to enable it. Perl 6 in German	[reply]
Re^2: Email Archiving by jhourcle (Prior) on Jun 01, 2007 at 03:57 UTC
That's the option I'd go for. Barring that, as silly as it sounds -- gopherd can read mbox format. You just point the gopher server at the file, and it'll generate an index for it, and pull out individual messages on request. I always thought httpd was a bit of a step backwards in that regard.	[reply]
Re: Email Archiving by perlfan (Vicar) on May 31, 2007 at 19:38 UTC
I use mhonarc - it works great, and it is written in Perl! I run a cron against a mailbox file similar to: `/usr/local/bin/mhonarc -add -nolock -treverse -reverse -multipg -idxsi +ze 500 -outdir /path/to/www/mail-archive -msgexcfilter "/regex-to-fil +ter-out/i" -tidxfname index.html /path/to/mbox` [download] I went back and forth between that and hypermail, and ultimately settled on mhonarc once I figured out how to use it. Cheers Update: added "-nolock" flag; I found that my command was failing for the last few days because something happened during an update; probably a server crash on my host's webserver.	[reply] [d/l]
Re: Email Archiving by Dru (Hermit) on Jun 05, 2007 at 06:10 UTC
Sorry for the late response monks, I had to go out of town and just now getting a chance to read the replies. moritz/jhourcle, Yes, this would be the ideal choice, but the list is a Lotus Notes group, which is not managed by me nor do I believe Notes has the capabilities to do what I want (maybe with Domino, but I prefer not to rely on asking my Notes IT team to set it up on their side, I want it completely independent from the Notes platform). perlfan, Thanks for the suggestion on mhonarc, I'll have to check it out. Thanks, Dru Perl, the Leatherman of Programming languages. - qazwart	[reply] [d/l]