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: signature.asc
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.bin>