New entry for Interim packet

[Tony Spencer]

Hello

 

Our setup is as follows:

 

Centos 5.2

FreeRADIUS Version 2.0.2

MySQL Version: 4.1.20

 

We are using FreeRadius for our ADSL users and its working fine.

Except when it comes to working out the usage stats for each user at the end
of each month.

Its easy to do with all sessions that started in the previous month and have
a Stop status.

But it's difficult when a session rolled over to the next month because the
status is Alive.

We're trying to find a why to make FreeRadius:

 

Enter a new entry into the Radacct table for a session for an Interim update

Mark the previous session with a stop Status and update the OctetsIn and
OctetsOut for that session with the current value.

Set the new session OctetsIn and OctetsOut at zero until the next update and
then it starts from the beginning again.

 

However we can't find a way of making FreeRadius:

 

Run 2 sql statements in the same update.

Set the new session counter to zero and not roll over the next updates
Octets.

 

 

We have found the following site:
http://www.netexpertise.eu/en/freeradius/daily-accounting.html with a way of
doing this within MySQL with procedures, but apparently this only works with
MySQL 5. 

Having installed MySQL 5 on a test server and importing  our Radius database
we tried running the first procedure but get an error:

 

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'DECLARE COUNTER_LIMIT BIGINT(12)' at line 1

mysql>   SET COUNTER_LIMIT = POW(2,32);

ERROR 1193 (HY000): Unknown system variable 'COUNTER_LIMIT

 

 

Has anyone any ideas on how to do what we require or has anyone had any luck
with the instructions on the URL?

 

Thanks in advance.

 

Tony

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20081120/23c03fd2/attachment.html>