Hi list, I would just like to get some feedback from the list on what would be a good choise for a MTA / POP3 server which will meet the following requirements.
* usernames / aliases / etc should be stored in MySQL or PostgreSQL
* Should be able to handle a large number of emails
* Isn't full of security exploits.
I was going to use exim for the MTA with tpop3d from http://www.ex-parrot.com/~chris/tpop3d / as the POP3 server and use vmail-sql to manage the accounts but I found the following difficulties with such a setup.
1. the exim packaged for Debian doesn't have MySQL support, so an apt-get upgrade would break the system if I made my own package.
2. tpop3d and vmail-sql don't have Debian packages so it would be a matter of keeping up with these software packages and building my own debs every time a new release came out.
Yes I know this last reason isn't a terribly good one, but it is enough to make me consider the alternatives.
Alternative 1. Qmail + vpopmail.
I noticed the vpopmail package for debian is several versions behind that on the inter7 web site. Also the vpopmail-mysql package appears to be broken and doesn't query the MySQL database like it should, I ended up having to build my own deb package of this to correct the problem.
Alternative 2. postfix and cyrus imapd/pop3d
1. postfix does have MySQL support
2. Cyrus appears to cope quite hapilly with MySQL
The only flaw with this set up is that it doesn't really allow for checking your mail on the local system via mutt or something, not a huge problem but a slight inconvenience.
Does anyone else have any recommendations on what would be a good configuration to handle the type of mail setup I am aiming for?
Any feedback would be most helpful.