First off I've just got to say thanks. We just upgraded from UW to Dovecot migrating from mbox to maildir. Wow, what a difference! Load average used to hang around 5.0 during business hours and could get up to 20+ on a bad day. Now we rarely break 1.0! I'm wondering if there's a way to keep track of the last time a user checked their email and whether they checked it using POP or IMAP. We're trying to gather statistics on what protocols our users use and find accounts that haven't been checked for a long time. We used to be able to do some of this with the finger command and the user's mbox. I found a script called "mfinger" that works better with Maildir, but it's designed for Courier. Any ideas? Thanks!
Del Stoliker wrote:> First off I've just got to say thanks. We just upgraded from UW to Dovecot > migrating from mbox to maildir. Wow, what a difference! Load average used > to hang around 5.0 during business hours and could get up to 20+ on a bad > day. Now we rarely break 1.0!That's encouraging for those of us planning this change :)> I'm wondering if there's a way to keep track of the last time a user checked > their email and whether they checked it using POP or IMAP. We're trying to > gather statistics on what protocols our users use and find accounts that > haven't been checked for a long time. We used to be able to do some of this > with the finger command and the user's mbox. I found a script called > "mfinger" that works better with Maildir, but it's designed for Courier.Can't you just grep through the logs? It's not too hard to add extra logging if needed; I've currently got SELECTs (i.e. IMAP folder opens) logged, for example. Best Wishes, Chris -- --+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+- Christopher Wakelin, c.d.wakelin at reading.ac.uk IT Services Centre, The University of Reading, Tel: +44 (0)118 378 8439 Whiteknights, Reading, RG6 2AF, UK Fax: +44 (0)118 975 3094
On Monday 25 April 2005 22:25, Del Stoliker wrote:> First off I've just got to say thanks. We just upgraded from UW to Dovecot > migrating from mbox to maildir. Wow, what a difference! Load average used > to hang around 5.0 during business hours and could get up to 20+ on a bad > day. Now we rarely break 1.0! > > I'm wondering if there's a way to keep track of the last time a user > checked their email and whether they checked it using POP or IMAP. We're > trying to gather statistics on what protocols our users use and find > accounts that haven't been checked for a long time. We used to be able to > do some of this with the finger command and the user's mbox. I found a > script called "mfinger" that works better with Maildir, but it's designed > for Courier.You don't say how you wish to access this information, but this works: egrep "(pop|imap)-login: Login:" /var/log/mail.log | grep USERNAME| tail -1 Assuming you run it before you rotate your logs, or you could miss out. Another way is to modify Dovecot a little and have it record whatever activity details you want directly into a Database, ie: SQLite / MySQL. This should be simple to do for some inclined developer (if this is a commercial project).> Any ideas? > > Thanks!HTH, -- Dominic GoodforBusiness.co.uk I.T. Services for SMEs in the UK.
--On Monday, April 25, 2005 3:25 PM -0600 Del Stoliker <dstoliker at alphagraphics.com> wrote:> I'm wondering if there's a way to keep track of the last time a user > checked their email and whether they checked it using POP or IMAP.This won't tell you whether IMAP or POP was used, but you can look at the atime on the inbox to see when it was last read. The problem I ran into with this approach was that my verify pass on my backup job would read every file on the system, touching the atime's. To get around this, my verify script would remount the filesystem with noatime for the duration of the verify. So there was a window of an hour or two during which I might miss a user's access.