Bacula-users

Re: [Bacula-users] Maildir and mysql plugin

2010-08-24 19:40:48
Subject: Re: [Bacula-users] Maildir and mysql plugin
From: Rory Campbell-Lange <rory AT campbell-lange DOT net>
To: Gavin McCullagh <gavin.mccullagh AT gcd DOT ie>
Date: Wed, 25 Aug 2010 00:37:01 +0100
On 24/08/10, Gavin McCullagh (gavin.mccullagh AT gcd DOT ie) wrote:
> Hi,
> 
> On Mon, 23 Aug 2010, Rados??aw Korzeniewski wrote:
> 
> > 2010/8/23 Marcio Merlone <marcio.merlone AT a1.ind DOT br>
> > 
> > > I was wondering... would be nice to have a maildir backup plugin, where
> > > one could backup a maildir and have its contents indexed and restorable
> > > by sender, subject, date, attachments, etc.. I could try to write one
> > > myself, but wouldn't have the required skills and time. Has anyone ever
> > > though about this? Is it doable?

We do this by making a shadow copy of each email passing through Exim
and storing it in a directory with the day's date using Exim's unique
mail identifier to name the file. While doing this Exim calls a postgres
database and stores the headers in the database. Every night we spin
through the stored files and calculate their sha1sums and then match
these to the records in the database.

This doesn't allow one to very easily deal with Maildirs, but it does
allow one to retrieve specific emails very quickly. All one would need
to do in bacula is to specify the date and id of the specific mail file.

I can provide more information if that is of interest, although it is
outside the scope of your suggestion regarding a specific plugin.

Interestingly, if you used something like Dovecot's dsync to
periodically sync your imap accounts to dbmail, you would get those
headers for free in a database format. But then you would have to have
two copies of all your mail!

Another post-processing technique would be to write something on top of
an imap sync tool (such as the excellent offlineimap
(http://wiki.github.com/jgoerzen/offlineimap/) to see if a mail has been
seen before in a particular folder and if not record its headers in a
database. Note that many imap daemons change the name of the stored
files to record mail flags.

Regards
Rory

-- 
Rory Campbell-Lange
rory AT campbell-lange DOT net

------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users 
worldwide. Take advantage of special opportunities to increase revenue and 
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>