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 […]
Oct 04 2009
Compilation Error? The Oracle client being installed (11g R2 in my setup), Freeradius doesn’t seem to find Oracle headers. I get the following error message: Error compiling Oracle/Freeradius configure: WARNING: oracle headers not found. Use –with-oracle-home-dir=<path>. configure: WARNING: silently not building rlm_sql_oracle. configure: WARNING: FAILURE: rlm_sql_oracle requires: oci.h. Specifying the path to –with-oracle-home-dir doesn’t […]
May 30 2009
We have seen a few posts on Freeradius user list and other forums asking how to collect accounting periodically. The Radius protocol provides accounting but not in the way that many would like. Here’s a short list of things we would like to modify or improve: Traffic is not collected at regular intervalsAs a result, […]
May 16 2009
You can easily graph Freeradius number of active sessions with a simple shell script, if you store accounting data in a SQL database. Use the script below for Mysql that you can easily adapt to other databases like Oracle or PostgreSQL. Check the complete list of supported databases by Freeradius. A certain number of sessions […]
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 […]