2009/10/23 Alexander Clouter <[email protected]>: > Sergio Belkin <[email protected]> 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 - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
