dovecot - Aug 2005 - pop-before-smtp in SQL?

I need pop-before-smtp (let's not discuss the advisability
of the method), but I'm annoyed at the inefficiency of the
classical perl script that parses the logs.

A long time ago I modified the perl to add the tuple (IP,
time) to an SQL table that the MTA looks at, and to clean up
periodically. I found that this was the best way to deal with
multiple servers that have to share an SQL database anyway.

Wouldn't it be quite trivial to make dovecot write to an SQL
table upon sucessful login, instead of all this log file parsing
by an additional daemon?

On Fri, 2005-08-19 at 16:59 +0200, Lorens wrote:
> Wouldn't it be quite trivial to make dovecot write to an SQL
> table upon sucessful login, instead of all this log file parsing
> by an additional daemon?
If you use sql userdb, you can just add the insert command into the
user_query. Although that doesn't work if Dovecot LDA is used, since it
also calls user_query when delivering mails. I've in TODO that there
should be a separate post_login command.

Another way that already works is to update mail_executable location to
some script which does the SQL insertion and after that executes the
real imap or pop3 binary.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20050819/58c8feb6/attachment.bin>