Accounting

[Jonathan Gazeley]

We at Bristol have used FreeRADIUS with no problems for some time, but I 
would like to alter the way that accounting is performed, but I am 
unsure of how to do it.

Currently all the accounting is sent to a MySQL database. The 'radacct' 
table tells me the start/stop of each session and the amount of traffic 
passed in that time. However the traffic figures are only updated when 
the user's session terminates. Is there a way to get up-to-date 
statistics that can be polled, say, on an hourly basis?

What I'm getting at is that I want each user to have a daily/weekly/etc 
traffic quota so the radius server should repeatedly check to see if it 
has been exceeded. Appropriate action will be taken elsewhere is this is 
exceeded.

Does anyone have any pointers? e.g. can the radius server be queried 
intermittently for traffic figures? Can the radacct table be updated 
hourly without forcing a disconnection?

Cheers,
Jonathan

----------------------------
Jonathan Gazeley
Systems Support Specialist
ResNet | Wireless & VPN Team
Information Services
University of Bristol
----------------------------