Re: [Lazarus] mbox mail format conversion to SQL database
I found this: http://pnews.urdada.net/ *Features:* - Read/Post/Reply/Crosspost/Forward/Delete articles to/from News server(s). - Multiple News server and multiple categories of news groups. - Support NNTP over SSL (NNTPS) and NNTP authentication. - Posting and downloading for uuencoded attachment. - Easy to install, neither database access nor IMAP is required. - Authentication is easily configured to work with your existing system. - Multiple language interface and Traditional/Simplified Chinese coding conversion. On Mon, Apr 6, 2009 at 7:14 PM, Graeme Geldenhuys wrote: > On Mon, Apr 6, 2009 at 6:02 PM, David W Noon > wrote: > > > > There is a MDA called dbmail that uses PostgreSQL or MySQL as its > > storage back-end. You can import messages into it using your favourite > > MUA (e.g. KMail, Evolution, M$ Lookout) and it will store them using > > dbmail's POP3 or IMAP4 interface. > > Thanks, I'll take a look at the product. It sounds interesting. I > only use the Firebird RDBMS, but I'm sure it would be simple enough to > bolt on or extract the information I need from dbmail to code up my > own solution. > > Regards, > - Graeme - > > > ___ > fpGUI - a cross-platform Free Pascal GUI toolkit > http://opensoft.homeip.net/fpgui/ > ___ > Lazarus mailing list > Lazarus@lazarus.freepascal.org > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > -- o__ ,_.>/ _ (_)_\(_)___ ...speed is good ___ I believe five out of four people have a problem with fractions. ___ Lazarus mailing list Lazarus@lazarus.freepascal.org http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] mbox mail format conversion to SQL database
On Mon, Apr 6, 2009 at 6:02 PM, David W Noon wrote: > > There is a MDA called dbmail that uses PostgreSQL or MySQL as its > storage back-end. You can import messages into it using your favourite > MUA (e.g. KMail, Evolution, M$ Lookout) and it will store them using > dbmail's POP3 or IMAP4 interface. Thanks, I'll take a look at the product. It sounds interesting. I only use the Firebird RDBMS, but I'm sure it would be simple enough to bolt on or extract the information I need from dbmail to code up my own solution. Regards, - Graeme - ___ fpGUI - a cross-platform Free Pascal GUI toolkit http://opensoft.homeip.net/fpgui/ ___ Lazarus mailing list Lazarus@lazarus.freepascal.org http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] mbox mail format conversion to SQL database
On Mon, 2009-04-06 at 16:26 +0200, Graeme Geldenhuys wrote: > I'm about to tackle this project. It seems that the mbox mail format > is quite simple. But to save myself some time... if anybody knows of a > tool that can convert mbox mail into SQL database tables that would be > great. There is a MDA called dbmail that uses PostgreSQL or MySQL as its storage back-end. You can import messages into it using your favourite MUA (e.g. KMail, Evolution, M$ Lookout) and it will store them using dbmail's POP3 or IMAP4 interface. In fact, dbmail is so good I use it as my main mailserver. I use a PostgreSQL database for the back-end. [AFAIAA, dbmail runs only on POSIX platforms (Linux, FreeBSD, etc.), so if you need to run it on Windows you could be SOL.] Of course, other RDBMS's could pose a problem, as only PostgreSQL and MySQL are supported. However, you could use some generic export tool to extract the data from dbmail's tables to transfer the data to another DBMS. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon) === ___ Lazarus mailing list Lazarus@lazarus.freepascal.org http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
[Lazarus] mbox mail format conversion to SQL database
Hi, I'm about to tackle this project. It seems that the mbox mail format is quite simple. But to save myself some time... if anybody knows of a tool that can convert mbox mail into SQL database tables that would be great. Reason for conversion: I want to write a CGI app using Lazarus that allows private newsgroups to be searchable via a web interface. It will also serve as a backup for the news server. I want to be able to use full text search on all parts of the message (header entries, title, body etc..) Regards, - Graeme - ___ fpGUI - a cross-platform Free Pascal GUI toolkit http://opensoft.homeip.net/fpgui/ ___ Lazarus mailing list Lazarus@lazarus.freepascal.org http://www.lazarus.freepascal.org/mailman/listinfo/lazarus