Archive for the 'Monitoring' Category



May 16 2009

Graph Number of Freeradius Sessions in MRTG

Published by under Freeradius,Monitoring

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= 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 […]

No responses yet

Apr 10 2009

Monitor AS400 Resources with MRTG

Published by under AS400,Monitoring

It is recommended to monitor AS400 CPU load with OID . 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 […]

2 responses so far

Mar 19 2009

Graph Only One Value in MRTG

Published by under Monitoring

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 […]

One response so far