[Dovecot] How to store Dovecot Logs in SQL DB

[Timo Sirainen]

On Mon, 2006-09-04 at 10:45 +0200, Krzysztof wrote:
> >
> > Or are you trying to say that authentication logging to SQL should be a
> > Dovecot feature?
> >
> >   
> It would be great if Dovecot had that feature.

In Dovecot v2.0 I'm going to use separate log processes, which should
then be somewhat easily replaceable with eg. perl scripts that log to
database. Or whatever.

> I need it for quick view of users login history. 

You could do this by pointing mail_executable to a script:

#!/bin/sh

echo "INSERT INTO logins (user, time) VALUES ('$user', now())" | psql mails

exec /usr/local/libexec/dovecot/imap

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20061009/fee73653/attachment.pgp