[Dovecot] mysql +update
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:
echo "update users set last_login = now where username = '$USER'" | mysql ..
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
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