Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2617 → Rev 2618

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