<html><head><base href="x-msg://1371/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Aug 6, 2010, at 2:53 PM, Siryx XL wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div class="hmmessage" style="font-size: 10pt; font-family: Tahoma; ">Hi everyone.<br><br>I got freeradius to AAA the access to a Cisco Routers.<br><br>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....<br><br>an example:<br><br>mysql> select radacctid,username,acctstarttime,acctstoptime from radacct where username = "jhon.doe" and acctstarttime > "2010-08-05 07:45:30";<br>+-----------+-----------------+----------------------+-------------------------+<br>| radacctid | username | acctstarttime | acctstoptime |<br>+----------- +-----------------+---------------------+-------------------------+<br>| 93760 | jhon.doe | 2010-08-05 07:45:31 | NULL |<span class="Apple-converted-space"> </span><br>| 93761 | jhon.doe | 2010-08-05 07:45:50 | NULL |<span class="Apple-converted-space"> </span><br>| 93762 | jhon.doe | 2010-08-05 07:52:23 | NULL |<span class="Apple-converted-space"> </span><br><br><br><br>What can I do to update this entries after a certain time has pass, or do something else so fix those entries?<span class="Apple-converted-space"> </span><br><br></div></span></blockquote><div><br></div><div>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).</div><div><br></div><div>Switch NAS vendor.</div><div><br></div><div>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.</div><div><br></div><div>-Arran</div><br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div class="hmmessage" style="font-size: 10pt; font-family: Tahoma; ">Thanks in advance.<br>-<br>List info/subscribe/unsubscribe? See<span class="Apple-converted-space"> </span><a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></div></span></blockquote></div><br></body></html>