May
16
2009
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 [...]
Tags: active, Freeradius, graph, monitor, mrtg, number, session
Mar
19
2009
MRTG needs at least 2 values to generate graphs. Thus, Most configurations contain the same OID twice in the target line. This leads to 2 problems: – The same data is collected twice which requires more bandwidth, especially when a large number of hosts is monitored – The value may vary during this very short [...]
Tags: CPU, graph, memory, mrtg, OID, one, snmp, snmpget, value
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