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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
