Freeradius accounting issues

[Arran Cudbard-Bell]

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? 
> 

You have three options, mail Cisco and ask why their products don't send Accounting-ON messages on startup (like pretty much every other well designed NAS does).

Switch NAS vendor.

Or write a script that polls the NAS that according to the accounting database have clients still present and close sessions in the database where they no longer exist on the NAS.

-Arran

> Thanks in advance.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100806/b3842827/attachment.html>