mbox mail format conversion to SQL database

[Graeme Geldenhuys]

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/

[David W Noon]

Post by Graeme Geldenhuys
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.

[Graeme Geldenhuys]

Post by David W Noon
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/

[Reenen Laurie]

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

Post by Graeme Geldenhuys

Post by David W Noon
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
http://www.lazarus.freepascal.org/mailman/listinfo/lazarus