[Dovecot] proxy logging

[Timo Sirainen]

On Thu, 2008-01-24 at 23:38 -0200, diego wrote:
> Hi, I'm testing dovecot 1.1.beta14 on two debian etch with 
> drbd+ocfs2[active/active], I use qmail+vpopmail(userdb) and three 
> front-end with openbsd 4.2 with dovecot 1.1.beta14 as proxy with passdb 
> sql through vpopmail database.
> Is posible to add logs into vpopmail.vlog from proxys?, like "update 
> vlog blah blah..." or in other sql database?

So the proxy verifies that the password is correct before forwarding the
connection? And you want it to execute an SQL statement whenever user
authenticates successfully?

> I tried with post login scripting but I don't recibe any variable.

Proxies don't log in, so that doesn't work.

The only way I see for this to work is if you use a SQL function that
verifies first if the authentication was successful (you have user-given
password in %w), and after that does the log update. But if you're using
MySQL I'm not sure if this will work. There have been some problems with
MySQL functions before.

-------------- 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/20080131/f74a8cf2/attachment.bin