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
}