On Aug 6, 2010, at 3:12 PM, Marinko Tarlac wrote:
> Or you can simple make small changes in SQL queries for accounting and you
> won't need to use unlang...
I guess if you really just want to:
"update this entries after a certain time has pass"
Then that's easy enough with a simple update query, however it's generally a
bad idea to just close out sessions because they've run on too long. Unless of
course you don't care about the accuracy of your accounting database.
-Arran
>
>
>
> 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
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
