Detecting last login IMAP and expire old messages

[Bron Gondwana]

On Mon, Jan 10, 2011 at 08:37:14AM -0500, Adam Tauno Williams wrote:
> On Mon, 2011-01-10 at 09:13 -0400, Patrick Boutilier wrote: 
> > On 01/10/2011 08:03 AM, Adam Tauno Williams wrote:
> > > On Sat, 2011-01-08 at 23:35 -0200, Lucas Zinato Carraro wrote:
> > >> Is there a way to get messages from a user account automatic expire if
> > >> account is not in used for 6 months ?
> > > Yes, set the "expire" annotation on the folder.  For example, we set
> > > this to 365 on the user's sent-mail folder and to 14 for the users SPAM
> > > folder.
> > But he only wants to expire messages if the user has not logged in in 
> > the last 6 months.
> 
> Ah, my bad.
> 
> I suppose then it is really an authentication question and not a mailbox
> question.  Hrm.... it would be nice to have a reliable and standard way
> to determine when the last time user xyz was authenticated; but I'm not
> aware of any such thing.

We update a few database records from our custom saslauthd, which is used
by nearly everything now (web, ftp, dav, imap, pop, smtp, jabber, etc) - it
actually speaks 5 different authentication protocols!  So you not only know
how long since any login, but also what sort of login it was.

Bron.