Status X User

Alexander Clouter alex at digriz.org.uk
Fri Oct 23 21:20:48 CEST 2009


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.




More information about the Freeradius-Users mailing list