Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2617 → Rev 2618

/conf/freeradius-web/sql.attrmap
56,3 → 56,4
checkItem Alcasar-Expire-After Alcasar-Expire-After
checkItem CoovaChilli-Max-Total-Octets-Daily CoovaChilli-Max-Total-Octets-Daily
checkItem CoovaChilli-Max-Total-Octets-Monthly CoovaChilli-Max-Total-Octets-Monthly
checkItem CoovaChilli-Max-Total-Octets CoovaChilli-Max-Total-Octets
/conf/radius/alcasar
59,6 → 59,13
reject
}
 
counterCoovaChilliMaxAllTotalOctets { reject = 1 }
if (reject) {
update reply {
Reply-Message := "Your maximum usage volume has been reached"
}
reject
}
counterCoovaChilliMaxTotalOctetsMonthly { reject = 1 }
if (reject) {
update reply {
/conf/radius/alcasar-with-ldap
59,6 → 59,13
reject
}
 
counterCoovaChilliMaxAllTotalOctets { reject = 1 }
if (reject) {
update reply {
Reply-Message := "Your maximum usage volume has been reached"
}
reject
}
counterCoovaChilliMaxTotalOctetsMonthly { reject = 1 }
if (reject) {
update reply {
/conf/radius/sqlcounter
57,3 → 57,14
reset = monthly
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}
 
sqlcounter counterCoovaChilliMaxAllTotalOctets {
sql_module_instance = sql
counter_name = CoovaChilli-Max-All-Total-Octets
check_name = CoovaChilli-Max-Total-Octets
counter_type = data
reply_name = CoovaChilli-Max-Total-Octets
key = User-Name
reset = never
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}'"
}