| 35,27 → 35,3 |
|---|
| 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'" |
| } |