Sergio Belkin <seb...@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