<html><head><base href="x-msg://1371/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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.<div><br></div><div>You can do the updates with unlang and SQL xlat.</div><div><br></div><div>-Arran<br><div><br></div><div><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>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></div></div></body></html>