[Dovecot] mysql +update

Timo Sirainen tss at iki.fi
Sun Dec 3 12:58:38 UTC 2006


On Wed, 2006-11-29 at 12:12 +0100, SysOp wrote:
> Hi all,
> 
> how to put in databaswe (mysql) some information after login
> dovecot can only get information from database (user_query, password_query)
> exist some query to put in, for example last login date into database ?

Easiest way is to change mail_executable to a script which executes:

#!/bin/sh

echo "update users set last_login = now where username = '$USER'" | mysql ..
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/20061203/3d3f9bde/attachment.pgp 


More information about the dovecot mailing list