[Dovecot] Last login fields

[Dean Manners]

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 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) 
> http://docs.bulletinwireless.net/display/public/support
> http://www.bulletinwireless.com/
> Ph +64 9 307 1764  Fax +64 9 307 1148
>