Mailing List Archive

Delivery of one domain to mysql database...
Would it be difficult to set exim up to deliver all mail directed at one
domain into a mysql database (after authenticating the users via that
database), and the rest as a standard postoffice? Or would it be more
efficient to just have the web client handle pop3 e-mail so the users
can check their mail with a standard mail reader?

Thanks in advance.
Re: Delivery of one domain to mysql database... [ In reply to ]
On Mon, 24 Jun 2002, Cory Daehn wrote:

> Would it be difficult to set exim up to deliver all mail directed at one
> domain into a mysql database (after authenticating the users via that
> database), and the rest as a standard postoffice? Or would it be more
> efficient to just have the web client handle pop3 e-mail so the users
> can check their mail with a standard mail reader?

Exim can deliver down a pipe. It's up to you to set up whatever you like
at the other end of the pipe.

I rather suspect a database is not the best tool for storing emails.
Remember, they can get very big.


--
Philip Hazel University of Cambridge Computing Service,
ph10@cus.cam.ac.uk Cambridge, England. Phone: +44 1223 334714.
AW: Delivery of one domain to mysql database... [ In reply to ]
Hello,

> > Would it be difficult to set exim up to deliver all mail
> directed at one
> > domain into a mysql database (after authenticating the
> users via that
> > database), and the rest as a standard postoffice? Or
> would it be more
> > efficient to just have the web client handle pop3 e-mail
> so the users
> > can check their mail with a standard mail reader?
>
> Exim can deliver down a pipe. It's up to you to set up
> whatever you like
> at the other end of the pipe.
>
> I rather suspect a database is not the best tool for storing emails.
> Remember, they can get very big.

That's not the problem. For example I'm running here a 10GB Postgres
database without any problem. Also remember that MS Exchange is
based on a simple MS-SQL-Server-Database... :-)

But we don't want to use MS here, eh?

I would prefer an IMAP-Server, where the mails are stored. I use here
Cyrus IMAPd with exim and this combination is running very well.
There is a Web-Interface called IMP available, too, but You can also
use any other IMAP-Client.

cp