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