-----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 <[EMAIL PROTECTED]> | spamtrap: [EMAIL PROTECTED] w: http://www.silverdream.org | p: [EMAIL PROTECTED] 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