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 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
