Status X User

[Alexander Clouter]

Sergio Belkin <sebelk at 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.