Subversion Repositories ALCASAR

Rev

Rev 2597 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 2597 Rev 2618
Line 55... Line 55...
55 
	reply_name = CoovaChilli-Max-Total-Octets
 55 
	reply_name = CoovaChilli-Max-Total-Octets
56 
	key = User-Name
 56 
	key = User-Name
57 
	reset = monthly
 57 
	reset = monthly
58 
	query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
 58 
	query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
59 
}
 59 
}
- 
 
 60 
 
- 
 
 61 
sqlcounter counterCoovaChilliMaxAllTotalOctets {
- 
 
 62 
	sql_module_instance = sql
- 
 
 63 
	counter_name = CoovaChilli-Max-All-Total-Octets
- 
 
 64 
	check_name = CoovaChilli-Max-Total-Octets
- 
 
 65 
	counter_type = data
- 
 
 66 
	reply_name = CoovaChilli-Max-Total-Octets
- 
 
 67 
	key = User-Name
- 
 
 68 
	reset = never
- 
 
 69 
	query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}'"
- 
 
 70 
}