[Dovecot] Last login fields
Hey guys, Wondering if anyone has tried to do this before - a last login timestamp field. Using mysql for auth, I figured it would be easy enough to add a timestamp field and then tack an UPDATE statement on the end of the password_query. But of course, dovecot sees this as only one statement to pass to MySQL - of which MySQL barfs at.. Any ideas on how to achieve this ?
Regards
Dean Manners
Perhaps write a stored procedure that applies the update, then returns the result of the password query?
On 02/15/07 17:15, Dean Manners wrote:
Hey guys, Wondering if anyone has tried to do this before - a last login timestamp field. Using mysql for auth, I figured it would be easy enough to add a timestamp field and then tack an UPDATE statement on the end of the password_query. But of course, dovecot sees this as only one statement to pass to MySQL - of which MySQL barfs at.. Any ideas on how to achieve this ?
Regards
Dean Manners
-- Services & Support, Bulletin Wireless (NZ) http://docs.bulletinwireless.net/display/public/support http://www.bulletinwireless.com/ Ph +64 9 307 1764 Fax +64 9 307 1148
Thanks Zach, Il read up on stored proceadures I have a feeling only 5.0 supports though. Have since refined my google searches and stumbled on another approach, on the wiki no less: http://wiki.dovecot.org/PostLoginScripting
Regards
Dean Manners
-----Original Message----- From: dovecot-bounces@dovecot.org [mailto:dovecot-bounces@dovecot.org] On Behalf Of Zach Bagnall Sent: Thursday, February 15, 2007 3:24 PM To: Dean Manners Cc: 'Dovecot Mailing List' Subject: Re: [Dovecot] Last login fields
Perhaps write a stored procedure that applies the update, then returns the result of the password query?
On 02/15/07 17:15, Dean Manners wrote:
- a last login
Hey guys, Wondering if anyone has tried to do this before
timestamp field. Using mysql for auth, I figured it would be easy enough to add a timestamp field and then tack an UPDATE statement on the end of the password_query. But of course, dovecot sees this as only one statement to pass to MySQL - of which MySQL barfs at.. Any ideas on how to achieve this ?
Regards
Dean Manners
-- Services & Support, Bulletin Wireless (NZ) http://docs.bulletinwireless.net/display/public/support http://www.bulletinwireless.com/ Ph +64 9 307 1764 Fax +64 9 307 1148
participants (2)
-
Dean Manners
-
Zach Bagnall