On 10.10.2006, at 16.31, /dev/rob0 wrote:
On Tuesday 10 October 2006 05:51, Tom Sommer wrote:
anyone had any ideas as to how I could run an UPDATE statement upon each login, to set time of last login (and other interesting stuff) in the database table.
Set mail_executable to point to a script:
#!/bin/sh echo "update blah where user = '$USER'" | mysql .. exec /usr/local/libexec/dovecot/imap
Won't the overhead on that be pretty high? Considerings it now has to wrap the imap command in to a script.
I doubt overhead would be much of a problem, since all the shells will use shared memory. The problem I see is that at the time you're
running the update, you have not yet authenticated the user, so your data
could be unreliable.
No, mail_executable is run only after a successful authentication.