Mar
17
2008
Radius servers generate a lot of accounting records. Is it worth keeping them? Damn yeah! Beside the fact they could be used to check if a customer was connected at a given date, or find out who got IP address X.X.X.X that same day, the most interesting is to generate traffic reports and show customers [...]
Tags: accounting, billing system, Freeradius, graph, linux, Mysql, Oracle, Postgresql, radius, report, reporting, SQL, traffic
Aug
01
2007
Many people using Radius for accounting don’t know there are counters limits. Values defined in the protocol are stored in 32 bit fields meaning you will never go any higher than 4294967296 bits, that is fairly more than 4GB. If a session stays up for days, there are good chances that the counter resets to [...]
Tags: accounting, Cisco, Database, Freeradius, gigawords, interval, linux, Mysql, radius, SQL, traffic, update
Oct
11
2006
Logging Radius accounting into Mysql database can fill up a lot of space. Some performance issues will arise at some stage as well, especially if traffic reporting scripts are to be added to the overall system. That’s why we added a new table to log older accounting records.
Motivations
We can of course delete all records older [...]
Tags: accounting, archive, Database, engine, Freeradius, linux, Mysql, radius, SQL, traffic