OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Re: Mail archive solution

From: Benjamin Schmidt (schmidi2directbox.com)
Date: Mon Nov 26 2007 - 17:40:12 CST


Hey

We use dbmail (older version) for archieving eMails (1G or more per day). It's horror with dbmail I just wanna say that ! ! You will have a very huge innodb file. mysqldump will stop working when this file reaches a size of ~40 GB (if I remember correctly). Also the db schema is very innefficient for searching. A search frontend you have to develop anyway.

If I could rewrite the hole lot, I would use Maildir with daily folders and use mysql for indexing.

Best regards,
Benjamin Schmidt

( ! message not signed because the webfrontend was used ! )

-------- directBOX Reply ---------------
From: mlist.onlyfree.fr
To :
Date: 26.11.2007 15:37:26

Thomas Domingo Dahlmann wrote:
> Hi all
>
> Anyone in here who knows about a mail-archive solution based on mysql and
> postfix (or similar solution)?
>

you mean storing mail in mysql? If so, look at dbmail.

> I need a place to bcc all mail (passing in and out of the company) to be
> in compliance with local regulations. Of course it would also be nice if
> the solution had a decent search capability. I have the gateway that does
> the actual bcc I just need a place to store it.