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: <dovecot.org/pipermail/dovecot/attachments/20050819/58c8feb6/attachment.bin>