|
|
|
|
|
|||||||
| Web & Network Services Discussion related to network/web services such as apache, bind, sendmail, etc. |
 |
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2009, 20:15
|
|||
|
|||
Database based mail server
I wasn't sure where to post this so I chose the General forum. I'm looking to replace an Exchange server with an open source solution. It should use a database (preferably MySQL) to store its mail. It'll need some sort of antivirus solution for the SMTP protocol as well as the ability to scan the database for viruses (hopefully in real time) and a spam filter. In addition, it will have to have a web-based mail interface (PHP?) and I'd prefer not to have to write one myself. Does such a solution exist or am I dreaming?
Thanks!  J. 
|
|
#2
April 15th, 2009, 23:05
|
||||
|
||||
|
If you want a groupware server to replace Exchange, with shared e-mail, shared contacts, shared calendars, etc, then have a look at Zimbra. There's an open-source version that uses custom code to glue together Postfix, Amavisd-new, ClamAV, SpamAssassin, Cyrus IMAP, OpenLDAP, MySQL, and a custom AJAX web interface. It's really quite slick, and scalable.
Of all the ones we've tried (Merak, OpenXchange, Scalix, FirstClass, Kolab, and a few others), it's the best combination of easy-of-use, ease-of-administration, features, and compatibility. It's also one of the few that uses all open standards for accessing the data (SMTP, IMAP, SOAP, REST, LDAP, CalDAV, WebDAV, iCal, HTTP, and so on). There's also a very easy upgrade path to their Network Edition, which includes over-the-air sync for blackberries and activesync clients, and a connector for full outlook compat (makes the zimbra server look like an exchange server). The only downside is that they don't officially support FreeBSD.
|
| The Following User Says Thank You to phoenix For This Useful Post: | ||
ph0enix (April 16th, 2009) | ||
|
#3
April 16th, 2009, 04:57
|
|||
|
|||
|
A ... long ... time ago I implemented my mail system on dbmail, with a Postfix front end.
http://www.dbmail.org/ Also a ... long ... time ago I moved to something more conventional based on maildir, postfix etc. To be honest I can't recall why we moved off of it, other than it was something of a technology reach at the time and I wanted something a little bit more mainstream to maintain. I see the project is still alive and active so perhaps it is worth a shot. Looks like they never did write a client for it, instead relying on IMAP or pop3 clients. Truth be told I keep musing about writing a web based MUA in Python but somehow other priorities keep showing up and we still run Squirrelmail.
|
| The Following User Says Thank You to mwatkins For This Useful Post: | ||
ph0enix (April 16th, 2009) | ||
|
#5
April 16th, 2009, 16:54
|
|||
|
|||
|
I believe we had this issue on on bsdforums.org at one point. I'm not sure if it's the same phoenix that was a mod there. They didn't let me use my nickname there so I had to choose something else.
|
|
#6
April 16th, 2009, 18:36
|
||||
|
||||
|
I'm the phoenix on the following forums: dualboot (member), daemonforums (admin), bsdforums (mod), freebsd forums (mod), bsdnexus (member), osnews (member).
When that nick isn't available, I also go by phoenix_rizzen (slashdot). That's the problem with using such a great nick ... sometimes it's already taken (like on the zimbra forums). Back to the main topic: have you looked into any of the suggestions yet? Or are you still wanting more suggestions?
|
| The Following User Says Thank You to phoenix For This Useful Post: | ||
ph0enix (June 19th, 2009) | ||
|
#8
April 16th, 2009, 20:01
|
||||
|
||||
|
Search the forums. One of the member's posted links to the port he's working on.
|
| The Following User Says Thank You to phoenix For This Useful Post: | ||
ph0enix (June 19th, 2009) | ||
|
#10
April 18th, 2009, 00:56
|
|||
|
|||
|
I found dbmail to be cool enough; at the time I built a mini "ISP" solution using it. Certainly it was easy enough to code up a solution when most or all of the moving parts are in a database.
It was a proof of concept which we never scaled big. If indeed it does grow big, you'll have to think seriously about backup. In the end I preferred the flexibility that a good-ol-file system gives so the dbmail-backed solution got shelved.
|
| The Following User Says Thank You to mwatkins For This Useful Post: | ||
ph0enix (June 19th, 2009) | ||
|
#11
May 7th, 2009, 13:24
|
|||
|
|||
|
video tutorial with an open source solution:
http://www.sima-it.com/en/how_to_ste...SQL_FreeBSD-6/
|
| The Following User Says Thank You to alex2323 For This Useful Post: | ||
ph0enix (June 19th, 2009) | ||
|
#12
May 7th, 2009, 19:39
|
|||
|
|||
|
When you think of the fact zfs supports a petabyte filesystem, I don't think it makes any sense to go with dbmail. Also, keep in mind, exchange drop-ins are quirky - even the good ones (Zimbra, Kerio) Users are used to the whole shared calendaring/contacts thing; if you can train them to use other resources like a shared addressbook in csv format that Thunderbird/Outlook can pick up for example and a calendar like on a network share or something, you can save yourself a lot of administrative overhead and hassle. My most recent MTA was just postfix, dovecot, mysql, and amavis.
|
| The Following User Says Thank You to Dryanta For This Useful Post: | ||
ph0enix (June 19th, 2009) | ||
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [Solved] Setting up Mail Server | Lego | Web & Network Services | 67 | July 14th, 2009 22:07 |
| [Solved] Mail Server (Postfix) SMTP problem | SomeoneHere | Web & Network Services | 10 | April 29th, 2009 12:55 |
| I have this mail in /var/mail/root | mfaridi | General | 2 | March 17th, 2009 08:16 |
| some question about e-mail server | kalns | Web & Network Services | 12 | March 2nd, 2009 23:22 |
| E-mail server behind NAT | icer | Web & Network Services | 12 | February 27th, 2009 03:12 |
Linear Mode
