RE: Freeradius accounting issues

2010-08-10 Thread Siryx XL
> 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 S

Re: Freeradius accounting issues

2010-08-06 Thread Arran Cudbard-Bell
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... I guess if you really just want to: "update this entries after a certain time has pass" Then that's easy enough with a simple u

Re: Freeradius accounting issues

2010-08-06 Thread Marinko Tarlac
Or you can simple make small changes in SQL queries for accounting and you won't need to use unlang... 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

Re: Freeradius accounting issues

2010-08-06 Thread Arran Cudbard-Bell
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

Re: Freeradius accounting issues

2010-08-06 Thread 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

Freeradius accounting issues

2010-08-06 Thread Siryx XL
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,acct