2009/10/23 Alexander Clouter <alex@digriz.org.uk>:
Sergio Belkin <sebelk@gmail.com> wrote:
Is there a way to get the las time that user got Accept-Accept and Accept-Reject, of course I can parse log files but I wonder if there a radius tool that can do it.
<your data> -> SQL
SELECT * FROM postauth WHERE user_name = '<blar>' AND packet_type = 'Access-Reject' ORDER BY timestamp DESC LIMIT 1
Then for the latter replace 'Access-Accept' with 'Access-Reject'?
Cheers
-- Alexander Clouter .sigmonster says: Zeus gave Leda the bird.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Ooops, I have no mysql, except that there is a way to dump log files to mysql database :) Sorry if the question sounds stupid :) -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin -