cacti - data query

apacheerr.sh

#!/bin/sh

sed -e "s/\[.*\]\([^:]*\)\(.*\)/\1/" /var/log/httpd/error_log |
    sort |
    uniq -c |
    tr -s " " |
    sed 's/^[ ]//g' |
    cut -f 1 -d ' ' |
    awk '{a+=$0}END{print a}'

gistfile1.txt

IF-MIB::ifInOctets.1 = Counter32: 331453802
IF-MIB::ifInOctets.2 = Counter32: 5572307
IF-MIB::ifOutOctets.1 = Counter32: 4113764072
IF-MIB::ifOutOctets.2 = Counter32: 1670066329

interface.xml

<ifInOctets>
  <name>Bytes In</name>
  <method>walk</method>
  <source>value</source>
  <direction>output</direction>
  <oid>.1.3.6.1.2.1.2.2.1.10</oid>
</ifInOctets>
<ifOutOctets>
  <name>Bytes Out</name>
  <method>walk</method>
  <source>value</source>
  <direction>output</direction>
  <oid>.1.3.6.1.2.1.2.2.1.16</oid>
</ifOutOctets>

snmpd.conf

extend .1.3.6.1.3.1 APACHEERR /usr/share/webapps/cacti/scripts/apacheerr.sh