May
11
2013
Radius servers generate a lot of accounting records. Is it worth keeping them? Of course! 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 Freeradius traffic usage graphs and […]
Tags: Freeradius, graph, linux, Mysql, Oracle, Postgresql, radius, Reporting
Jul
22
2008
If you wonder if you should use rlm_ippool or rlm_sqlippool to turn your Radius into a “DHCP” server, read on! rlm_ippool We first configured Freeradius to provide IP addresses through the ippool module. IPs are stored internally in a binary data file. radiusd.conf Users In users, we’ve got: On startup, db.ippool and db.ipindex are created […]
Tags: Freeradius, linux, Mysql, radius
Aug
01
2007
Some 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, linux, Mysql, radius
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, Encryption, Freeradius, Mysql, Openssl, performance, radius, SSL
May
07
2007
We are not trying to build a full comparative of Mysql and Postgresql in this article. This subject has been discussed many times and everyone has his own opinion on this. Some directions may be given and only a few critirias will be analysed to be used with Freeradius. Criteria If we check what’s already […]
Tags: Database, Freeradius, Mysql, performance, Postgresql, radius