> Subject: Re: Freeradius accounting issues > From: a.cudba...@googlemail.com > Date: Fri, 6 Aug 2010 15:19:24 -0700 > To: freeradius-users@lists.freeradius.org > > > 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... >
What do you have exactly in mind? > > I guess if you really just want to: > "update this entries after a certain time has pass" > I have thinking in that these days that option too. > 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html