Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2596 → Rev 2597

/conf/radius/sqlcounter
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'"
}