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
}