25 Sep
2006
25 Sep
'06
11:36 p.m.
On Mon, Sep 25, 2006 at 12:55:31PM -0700, Dan Trainor wrote:
What I'm ultimately wanting to do is have Dovecot preform some action, or a trigger, when the user is successfully authenticated. Even more specifically, I'd like to run another SQL query to record a date/time for last authenticated login.
At least in PostgreSQL, you can define TRIGGERs on the SELECT's themselves. Of course you still don't know whether the login was successful, but this way you could log every login _attempt_ automatically.
Grrty