Freeradius accounting issues

[Marinko Tarlac]

Or you can simple make small changes in SQL queries  for accounting and 
you won't need to use unlang...



Arran Cudbard-Bell wrote:
> Actually, option 4. If your NAS supports interim updates, you can add 
> an additional field to the accounting database, and update the 
> timestamp in this field every time an interim update packet is 
> received. Then run a cron job to check for timestamps which are older 
> than the interim update period and close those entries.
>
> You can do the updates with unlang and SQL xlat.
>
> -Arran
>
>
> On Aug 6, 2010, at 2:53 PM, Siryx XL wrote:
>
>> Hi everyone.
>>
>> I got freeradius to AAA the access to a Cisco Routers.
>>
>> If for some reason you disconnect because the router power off, an 
>> accounting finish packets is not sent to my radius, so in the DB 
>> looks like the user is still logged in....
>>
>> an example:
>>
>> mysql> select radacctid,username,acctstarttime,acctstoptime from 
>> radacct where username = "jhon.doe" and acctstarttime > "2010-08-05 
>> 07:45:30";
>> +-----------+-----------------+----------------------+-------------------------+
>> | radacctid  | username  | acctstarttime             | acctstoptime    |
>> +----------- 
>> +-----------------+---------------------+-------------------------+
>> |     93760   | jhon.doe     | 2010-08-05 07:45:31 | 
>> NULL                | 
>> |     93761   | jhon.doe     | 2010-08-05 07:45:50 | 
>> NULL                | 
>> |     93762   | jhon.doe     | 2010-08-05 07:52:23 | 
>> NULL                | 
>>
>>
>>
>> What can I do to update this entries after a certain time has pass, 
>> or do something else so fix those entries? 
>>
>> Thanks in advance.
>> -
>> List info/subscribe/unsubscribe? 
>> See http://www.freeradius.org/list/users.html
>
> ------------------------------------------------------------------------
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html