5,7 → 5,7 |
reply_name = Session-Timeout |
key = User-Name |
reset = daily |
$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf |
query = "SELECT IFNULL((SELECT SUM(acctsessiontime - GREATEST((%%b - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%%b'), 0)" |
} |
|
sqlcounter monthlycounter { |
15,7 → 15,7 |
reply_name = Session-Timeout |
key = User-Name |
reset = monthly |
$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf |
query = "SELECT IFNULL((SELECT SUM(acctsessiontime - GREATEST((%%b - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%%b'), 0)" |
} |
|
sqlcounter noresetcounter { |
24,7 → 24,7 |
check_name = Max-All-Session |
key = User-Name |
reset = never |
$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf |
query = "SELECT IFNULL(SUM(AcctSessionTime), 0) FROM radacct WHERE username='%{${key}}'" |
} |
|
sqlcounter expire_on_login { |
33,7 → 33,7 |
check_name = Alcasar-Expire-After |
key = User-Name |
reset = never |
$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf |
query = "SELECT IFNULL((SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE username='%{${key}}' ORDER BY acctstarttime LIMIT 1), 0)" |
} |
|
sqlcounter counterCoovaChilliMaxTotalOctetsDaily { |
42,10 → 42,9 |
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'" |
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)), 0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" |
} |
|
sqlcounter counterCoovaChilliMaxTotalOctetsMonthly { |
54,8 → 53,7 |
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'" |
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" |
} |