Status X User

[Alexander Clouter]

Sergio Belkin <sebelk at gmail.com> wrote:
>
> 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'?
>>
> 
> Ooops, I have no mysql
>
That is a *good* thing, use PostgreSQL...

> except that there is a way to dump log files to mysql database :)
> 
> Sorry if the question sounds stupid :)
>
It is, thats why there is documentation...

http://freeradius.org/radiusd/man/rlm_sql.html

Cheers

-- 
Alexander Clouter
.sigmonster says: Read the fine print.