From: Mark Martinec (Mark.Martinec+postfixijs.si)
Date: Mon Mar 05 2007 - 18:40:10 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Monday March 5 2007 23:09, mouss wrote:
> well, the filesystem is a database. it doesn't support sql, but it's
> still a database.
> so use mysql (or whatever) if you need its functionality, and use the
> filesystem otherwise.
>
> what is lacking today IMHO is an implementation that stores some infos
> (the ones you search for... etc) in sql but still uses maildir for the
> messages.

Probably not exactly what you had in mind, but this one comes close:

SQL logging by amavisd-new stores the following information
about all mail, usually for a couple of weeks (e.g. for the
benefit of a pen pals feature):

- envelope sender address
- envelope recipient addresses
- header From field
- header Subject field
- header Message-ID
- timestamp
- SMTP client's IP address
- mail size
- content type (clean/virus/spam/banned...) and spam levels
- our SMTP reponse (plus some other details)
- and optionally: full mail contents
  (i.e. quarantining, also for all mail if desired - archiving,
  no artificial size limits imposed by SQL server or buffer sizes)

Mark

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]