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]
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
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]
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
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: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
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
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
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
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
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]
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]
