Netexpertise

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 change anything at all.
 
Installing Oracle Client
Install Oracle runtime client [...]

Tags: compile, Freeradius, Oracle

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 intervals
As a result, it [...]

Tags: accounting, billing software, Cisco, daily, Database, Freeradius, Mysql, quota, radius, report, SQL, traffic

You can easily graph your 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:
 

#!/bin/bash

SQL_USERNAME=radius_username
SQL_DATABASE=radius
SQL_PASSWORD=your_password
SQL_SERVER=127.0.0.1
SQL_ACCOUNTING_TABLE=radacct
BACK_DAYS=5

SESSIONS=`mysql -BN -u$SQL_USERNAME -p$SQL_PASSWORD -h $SQL_SERVER $SQL_DATABASE -e \
“SELECT COUNT(*) FROM $SQL_ACCOUNTING_TABLE \
WHERE acctstoptime IS NULL \
AND Acctstarttime > NOW() – [...]

Tags: active, Freeradius, graph, monitor, mrtg, number, session