Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2510 → Rev 2513

/conf/radius/alcasar
21,10 → 21,13
 
authorize {
sql
expire_on_login
noresetcounter
dailycounter
monthlycounter
expiration
counterCoovaChilliMaxTotalOctetsDaily
counterCoovaChilliMaxTotalOctetsMonthly
logintime
pap
}
/conf/radius/alcasar-with-ldap
21,10 → 21,13
 
authorize {
sql
expire_on_login
noresetcounter
dailycounter
monthlycounter
expiration
counterCoovaChilliMaxTotalOctetsDaily
counterCoovaChilliMaxTotalOctetsMonthly
logintime
pap
ldap {
/conf/radius/sqlcounter
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'"
}