Subversion Repositories ALCASAR

Rev

Rev 2510 | Rev 2597 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 2510 Rev 2513
Line 33... Line 33...
33 
	check_name = Alcasar-Expire-After
 33 
	check_name = Alcasar-Expire-After
34 
	key = User-Name
 34 
	key = User-Name
35 
	reset = never
 35 
	reset = never
36 
	$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf
 36 
	$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf
37 
}
 37 
}
- 
 
 38 
 
- 
 
 39 
sqlcounter counterCoovaChilliMaxTotalOctetsDaily {
- 
 
 40 
	sql_module_instance = sql
- 
 
 41 
	counter_name = CoovaChilli-Max-Total-Octets-Daily
- 
 
 42 
	check_name = CoovaChilli-Max-Total-Octets-Daily
- 
 
 43 
	counter_type = data
- 
 
 44 
	reply_name = CoovaChilli-Max-Total-Octets
- 
 
 45 
	sqlmod-inst = sql
- 
 
 46 
	key = User-Name
- 
 
 47 
	reset = daily
- 
 
 48 
	query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
- 
 
 49 
}
- 
 
 50 
 
- 
 
 51 
sqlcounter counterCoovaChilliMaxTotalOctetsMonthly {
- 
 
 52 
	sql_module_instance = sql
- 
 
 53 
	counter_name = CoovaChilli-Max-Total-Octets-Monthly
- 
 
 54 
	check_name = CoovaChilli-Max-Total-Octets-Monthly
- 
 
 55 
	counter_type = data
- 
 
 56 
	reply_name = CoovaChilli-Max-Total-Octets
- 
 
 57 
	sqlmod-inst = sql
- 
 
 58 
	key = User-Name
- 
 
 59 
	reset = monthly
- 
 
 60 
	query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0)FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
- 
 
 61 
}