Netexpertise

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

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