dovecot - Jan 2011 - Last login

Hi,

I'm trying to find a way to find inactive users.

Is there a simple way to deduct the last login date of a user from that 
users Maildir files? Are the timestamps on the index files reliable?

I ask because the system and dovecot logs are not available to me but I 
can search the whole .../vmail/domain/user/Maildir tree.

I'n running 1.2.9 on ububtu 10.04 LTS with posttfix and postfixadmin. 
The users (all are virtual) reside in the postfixadmin MySQL tables.

TNX
Egbert Jan (NL)

On Sun, Jan 09, 2011 at 09:19:39PM +0100, Egbert Jan van den Bussche
wrote:
> 
> I'm trying to find a way to find inactive users.
What we do is to touch a file upon every login:

protocol imap {
	<snip>
	mail_executable = /usr/local/dovecot/sbin/imap-wrapper.sh
}

protocol pop3 {
	<snip>
	mail_executable = /usr/local/dovecot/sbin/pop-wrapper.sh
}

and these simply do:

	#! /bin/sh -
	touch /var/log/activemailaccounts/imap/$USER
	exec /usr/local/dovecot/libexec/dovecot/imap

Once a day we push this info to a database, and use that to view
stats on account/protocol usage.



  -jf