Netexpertise

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

It is recommended to monitor AS400 CPU load with OID .1.3.6.1.4.1.2.6.4.5.1.0 that returns a value based on 10,000. It needs then to be divided by 100 to get a percentage.
The 2nd disadvantage is that the result is slightly wrong, the integer part only being returned.
OID HOST-RESOURCES-MIB::hrProcessorLoad.2 from an IBM i5 520 gives the correct value [...]

Tags: AS400, i5, IBM, memory, monitor, mrtg, resources, snmp, usage

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 lap, producing 2 [...]

Tags: CPU, graph, memory, mrtg, OID, one, snmp, snmpget, value