[Dovecot] Last login fields
deanm at ispone.com.au
Thu Feb 15 04:34:55 UTC 2007
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:
> -----Original Message-----
> From: dovecot-bounces at dovecot.org
> [mailto:dovecot-bounces at 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:
> > 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)
> Ph +64 9 307 1764 Fax +64 9 307 1148
More information about the dovecot