Status X User

[Sergio Belkin]

2009/10/23 Alexander Clouter <alex at digriz.org.uk>:
> 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.
>
> -
> 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 -