Finding out which accounts are 'inactive'?

Jamie L. Penman-Smithson devnull at silverdream.org
Tue Sep 21 13:37:57 EDT 2004


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hey all,

I recently switched from using saslauthd and pam-mysql to the sql auxprop
plugin.

However, I miss one feature that pam-mysql had, when a user logged in
it would record it in a table in my mysql database:

[...]
+--------+-----------------+------------------------+------+---------------------+------+
| id     | msg             | user                   | host | time                | pid  |
+--------+-----------------+------------------------+------+---------------------+------+
| 103161 | AUTH SUCCESSFUL | cyrus                     |      | 2004-09-14 19:23:12 | 1696  |
| 103162 | AUTH SUCCESSFUL | cyrus                     |      | 2004-09-14 19:23:19 | 1695  |
| 103163 | AUTH SUCCESSFUL | jamie.silverdream.org     |      | 2004-09-14 19:24:34 | 1696  |
| 103164 | AUTH SUCCESSFUL | jamie.silverdream.org     |      | 2004-09-14 19:26:34 | 1695  |
[...]

I used this to work out which accounts weren't being used. I was wondering
if there was any way of doing this with cyrus, without having to use
pam-mysql..?

Or, phrased differently, a way of finding out which accounts are inactive.
Yes, I realise I could grep my logs, but it's a pain grepping through
tonnes of logfiles. I'd also rather not reinvent the wheel if possible.

Thanks in advance,

-- 
-jamie <jamie at silverdream.org> | spamtrap: spam at silverdream.org
 w: http://www.silverdream.org | p: sms at silverdream.org
 pgp key @ http://silverdream.org/~jps/pub.key
 17:30:01 up 4 days, 15:18, 14 users,  load average: 0.39, 0.52, 0.62

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFBUGbpx2omo/Dc/KgRAoqpAJ9L1LPhb+HpvsOaxDDFN0mxXuAPRwCfZY7d
wSFtOGJY/RwFjy++7p6zCjE=
=vN9n
-----END PGP SIGNATURE-----


---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html




More information about the Info-cyrus mailing list