35,3 → 35,27 |
reset = never |
$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf |
} |
|
sqlcounter counterCoovaChilliMaxTotalOctetsDaily { |
sql_module_instance = sql |
counter_name = CoovaChilli-Max-Total-Octets-Daily |
check_name = CoovaChilli-Max-Total-Octets-Daily |
counter_type = data |
reply_name = CoovaChilli-Max-Total-Octets |
sqlmod-inst = sql |
key = User-Name |
reset = daily |
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" |
} |
|
sqlcounter counterCoovaChilliMaxTotalOctetsMonthly { |
sql_module_instance = sql |
counter_name = CoovaChilli-Max-Total-Octets-Monthly |
check_name = CoovaChilli-Max-Total-Octets-Monthly |
counter_type = data |
reply_name = CoovaChilli-Max-Total-Octets |
sqlmod-inst = sql |
key = User-Name |
reset = monthly |
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0)FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" |
} |