Mailing List Archive

New system setup wanting to integrate DB-mail
Hello all,

We currently have an aging email system running older versions of Dovecot and Postfix. There is no archival means or backup other than our disk based backuppc backup. So now we are looking to move our mail server to a virtual environment. With that we are going to be doing quite a few things like upgrading the versions of postfix/dovecot/etc, moving the mailstore to the SAN, and setting up an archival server.

Ideally we would like to have the main postfix server as just that, postfix. That would mean we would have a separate dovecot server along with a separate archival server. This would be to minimize any downtime during upgrades/outages.

Just as a background our setup will be Fedora or Centos. We use OpenLDAP authentication and group lists, mailing lists currently is majordomo but we will be moving to mailman with this migration. The only access by end users of mail is IMAP, there is no POP3 access.

My main concern is how best to integrate DB-mail into this setup. What I am wanting is a way to archive all in/outbound emails and provide an easy to search interface. We have approximately 200 end users and currently have about 1TB of mailstore data. With the archiving portion I would want all mail older than XXX days to be automatically deleted from the primary mailstore but accessible from an IMAP subscribed folder. I have read that this is doable with DB-mail but what about users that have sub-folders? Would that mail be able to be deleted from the main mailstore but yet still readable from an IMAP subscribed folder? What is the best way to not archive mailing list messages?

I am sure I will have many more questions but these are all that come to mind right now. Thanks in advance for any and all input.

--
Donny B.
Re: New system setup wanting to integrate DB-mail [ In reply to ]
Well with all the mail in a mysql database there is no easier way to
search and display the data. Using a php/mysql driven front end for
those means. You mention dovecot. By swapping to dbmail you will be
eliminating that setup from what I have read and looked at from that
setup because dovecot uses mbox and maildir formats not SQL. I'm
currently looking at dbmail myself to solve some issues regarding
SAN/cloudstorage. It seems like a good idea as long as you have enough
ram and the mysql server tweaked right for caching for the amount of
users you will have accessing the mail system.

Forgive me if am wrong about any of this. There seems to be not much
support in the mailing list. I thought I would put out my 2 cents.

Why use fedora? Ubuntu is where it is at. As far as mailing lists I
have not looked too far into that. I'm sure it is not a problem.
On 03/26/2012 at 6:02 PM, Donny Brooks wrote:Hello all,
We currently have an aging email system running older versions
of Dovecot and Postfix. There is no archival means or backup other
than our disk based backuppc backup. So now we are looking to move our
mail server to a virtual environment. With that we are going to be
doing quite a few things like upgrading the versions of
postfix/dovecot/etc, moving the mailstore to the SAN, and setting up
an archival server.
Ideally we would like to have the main postfix server as just that,
postfix. That would mean we would have a separate dovecot server along
with a separate archival server. This would be to minimize any
downtime during upgrades/outages.
Just as a background our setup will be Fedora or Centos. We use
OpenLDAP authentication and group lists, mailing lists currently is
majordomo but we will be moving to mailman with this migration. The
only access by end users of mail is IMAP, there is no POP3 access.
My main concern is how best to integrate DB-mail into this setup.
What I am wanting is a way to archive all in/outbound emails and
provide an easy to search interface. We have approximately 200 end
users and currently have about 1TB of mailstore data. With the
archiving portion I would want all mail older than XXX days to be
automatically deleted from the primary mailstore but accessible from
an IMAP subscribed folder. I have read that this is doable with
DB-mail but what about users that have sub-folders? Would that mail be
able to be deleted from the main mailstore but yet still readable from
an IMAP subscribed folder? What is the best way to not archive mailing
list messages?
I am sure I will have many more questions but these are all that come
to mind right now. Thanks in advance for any and all input.
--
Donny B.