Re: MySQL mail servers
Steven Nakhla wrote: Why? Well, we have our reasons. Particularly because we want an efficient way to handle millions of messages, plus the ability to search/manipulate/data mine through them using specific applications. I hate to disappoint you, but mail storage as raw files is probably more efficient than using MySQL, but YMMV. I've found qmail with Courier-IMAP to be so fast that I can't really say I'd want to try using a different back-end at all. If you end up with any benchmarks, feel free to post them. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
You may be able to do something with SquirrelMail. It's an email front end written in PHP, so you may be able to customize it for your needs. I actually have a need to store all emails in a database also, mainly to link emails with people for followups. I actually do this right now, but I have a script that runs every 2 minutes to transfer email to and from the mail server and the database. It's actually a kludge of pieces right now (FileMaker, Applescript, Outlook Express), which I am looking to replace with open source software. On Tuesday, April 1, 2003, at 04:04 PM, Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Ideally, I'd like to be able to setup an IMAP server that stores everything via a MySQL backend. Any thoughts? Recommendations? Or is this not possible? Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL mail servers
Are there currently any open-source mail servers that utilize MySQL? I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Ideally, I'd like to be able to setup an IMAP server that stores everything via a MySQL backend. Any thoughts? Recommendations? Or is this not possible? Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? Yes, many. I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Why, exactly? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 57 days, processed 1,928,444,836 queries (388/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
Why? Well, we have our reasons. Particularly because we want an efficient way to handle millions of messages, plus the ability to search/manipulate/data mine through them using specific applications. SN --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? Yes, many. I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Why, exactly? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 57 days, processed 1,928,444,836 queries (388/sec. avg) __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
Well To do selects on your mail archive? BTW - I've heard that Linux Magazine has developed into a handsom rag. Congradulations. I would never had thought it after seeing the first issue. Ruben On Tue, Apr 01, 2003 at 01:15:00PM -0800, Jeremy Zawodny wrote: On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? Yes, many. I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Why, exactly? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 57 days, processed 1,928,444,836 queries (388/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- __ Brooklyn Linux Solutions __ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com http://www.mrbrklyn.com - Consulting http://www.inns.net -- Happy Clients http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-0585 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
On Tue, Apr 01, 2003 at 01:17:45PM -0800, Steven Nakhla wrote: Why? Well, we have our reasons. I'm sure you do. But I'm curious to know them... unless they're secret, of course. :-) Particularly because we want an efficient way to handle millions of messages, plus the ability to search/manipulate/data mine through them using specific applications. Got it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 57 days, processed 1,928,958,383 queries (388/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
Take a look at dbmail. http://www.dbmail.org -- Jason On 4/1/03 4:04 PM, Steven Nakhla [EMAIL PROTECTED] wrote: Are there currently any open-source mail servers that utilize MySQL? I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Ideally, I'd like to be able to setup an IMAP server that stores everything via a MySQL backend. Any thoughts? Recommendations? Or is this not possible? Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com --- | Jason Burfield | | | [EMAIL PROTECTED] | http://www.burfield.com | --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
--- ** ORIGINAL MESSAGE FROM:Jeremy Zawodny [EMAIL PROTECTED]** ** ORIGINAL MESSAGE SENT:Tue Apr 01 13:15:00 ** ** ORIGINAL MESSAGE BELOW ** --- re: On Tue Apr 01 2003 at 01:04:59PM -0800 Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? Jeremey wrote: Yes many. Steven wrote: I know that there are some that will authenticate against accounts stored in a MySQL database but I am looking for a mail server that actually stores the messages in the database. Jeremey wrote: Why exactly? Jeremy Well, I can answer the why, and say I built myself a web-based email application (Java/Tomcat/MySQL/Linux) so that my email would be centralized. I found myself working on and using one of about 6 computers each week, and my email was getting spread out over the machines. I wasn't interested in using a Yahoo/Hotmail type account, as dealing with all the banners and flashing lights didn't attract me. So I decided to roll my own. Now my email is stored on and handled through one server, in a MySQL database. I can search the heck out of it, and needless to say, access it anywhere. I'm now considering a java GUI app to manage my mail (access via RMI perhaps), so having it in the database is very convenient. I suppose other people have their reasons for storing email in a databaseanyone? Rob Mazur - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
This is not flamebait. I'm not trying to be disagreeable or a jerk. Just a thought. What about IMAP? -jeff On Wed, 1969-12-31 at 17:59, mazur wrote: --- ** ORIGINAL MESSAGE FROM:Jeremy Zawodny [EMAIL PROTECTED]** ** ORIGINAL MESSAGE SENT:Tue Apr 01 13:15:00 ** ** ORIGINAL MESSAGE BELOW ** --- re: On Tue Apr 01 2003 at 01:04:59PM -0800 Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? Jeremey wrote: Yes many. Steven wrote: I know that there are some that will authenticate against accounts stored in a MySQL database but I am looking for a mail server that actually stores the messages in the database. Jeremey wrote: Why exactly? Jeremy Well, I can answer the why, and say I built myself a web-based email application (Java/Tomcat/MySQL/Linux) so that my email would be centralized. I found myself working on and using one of about 6 computers each week, and my email was getting spread out over the machines. I wasn't interested in using a Yahoo/Hotmail type account, as dealing with all the banners and flashing lights didn't attract me. So I decided to roll my own. Now my email is stored on and handled through one server, in a MySQL database. I can search the heck out of it, and needless to say, access it anywhere. I'm now considering a java GUI app to manage my mail (access via RMI perhaps), so having it in the database is very convenient. I suppose other people have their reasons for storing email in a databaseanyone? Rob Mazur - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
--- ** ORIGINAL MESSAGE FROM:Jeff Kilpatrick [EMAIL PROTECTED]** ** ORIGINAL MESSAGE SENT:Tue Apr 01 14:38:21 ** ** ORIGINAL MESSAGE BELOW ** --- On Wed 1969-12-31 at 17:59 mazur wrote: --- ** ORIGINAL MESSAGE FROM:Jeremy Zawodny [EMAIL PROTECTED]** ** ORIGINAL MESSAGE SENT:Tue Apr 01 13:15:00 ** ** ORIGINAL MESSAGE BELOW ** --- re: On Tue Apr 01 2003 at 01:04:59PM -0800 Steven Nakhla wrote: Are there currently any open-source mail servers that utilize MySQL? Jeremey wrote: Yes many. Steven wrote: I know that there are some that will authenticate against accounts stored in a MySQL database but I am looking for a mail server that actually stores the messages in the database. Jeremey wrote: Why exactly? Jeremy Well I can answer the why and say I built myself a web-based email application (Java/Tomcat/MySQL/Linux) so that my email would be centralized. I found myself working on and using one of about 6 computers each week and my email was getting spread out over the machines. I wasnt interested in using a Yahoo/Hotmail type account as dealing with all the banners and flashing lights didnt attract me. So I decided to roll my own. Now my email is stored on and handled through one server in a MySQL database. I can search the heck out of it and needless to say access it anywhere. Im now considering a java GUI app to manage my mail (access via RMI perhaps) so having it in the database is very convenient. I suppose other people have their reasons for storing email in a databaseanyone? Rob Mazur - re: This is not flamebait. Im not trying to be disagreeable or a jerk. Just a thought. What about IMAP? -jeff Oh that's fine. :-) I agree IMAP would do the trick. I did it more as a pet project, and as a way to explore Sun's JavaMail API. It also gave me an excuse to add another MySQL database to my collection! In other words, it is my hobby project that I enjoy coding on the side. Rob Mazur - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mail servers
On Tue, 1 Apr 2003 13:15:00 -0800, Jeremy Zawodny used a few recycled electrons to form: | On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote: | | Are there currently any open-source mail servers that utilize MySQL? | | Yes, many. | | I know that there are some that will authenticate against accounts | stored in a MySQL database, but I am looking for a mail server that | actually stores the messages in the database. | | Why, exactly? I know of one, but it isn't open source. It's called Iris and was written in-house by one of our developers. Iris currently processes all the email forwarding, pop, IMAP, etc for directNIC.com customers. It supports filters, mailing lists, archiving, RBLs, auto-responders, and probably a couple things I forget... I'm trying to get him to add a NNTP interface for the mailing lists now. ;-) So I guess the short answer is yes, there is at least one. We only use it in-house currently. There might be others... --Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]