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/

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.

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/

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.