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
Jun
11
2007
This is related to Freeradius software but can be applied to any application that needs to encrypt Mysql traffic. Freeradius is compliant to Radius protocol characteristics, which give ability to accomplish various actions, such as authenticate users. Number of caveats have been found, not related to the software but to the protocol. Joshua Hill from [...]
Tags: Database, encrypt, encryption, Freeradius, Mysql, Openssl, performance, radius, secure, security, SSL