| /conf/freeradius-web/sql.attrmap |
|---|
| 56,4 → 56,3 |
| checkItem Alcasar-Expire-After Alcasar-Expire-After |
| checkItem CoovaChilli-Max-Total-Octets-Daily CoovaChilli-Max-Total-Octets-Daily |
| checkItem CoovaChilli-Max-Total-Octets-Monthly CoovaChilli-Max-Total-Octets-Monthly |
| checkItem CoovaChilli-Max-Total-Octets CoovaChilli-Max-Total-Octets |
| /conf/radius/alcasar |
|---|
| 59,13 → 59,6 |
| reject |
| } |
| counterCoovaChilliMaxAllTotalOctets { reject = 1 } |
| if (reject) { |
| update reply { |
| Reply-Message := "Your maximum usage volume has been reached" |
| } |
| reject |
| } |
| counterCoovaChilliMaxTotalOctetsMonthly { reject = 1 } |
| if (reject) { |
| update reply { |
| /conf/radius/alcasar-with-ldap |
|---|
| 59,13 → 59,6 |
| reject |
| } |
| counterCoovaChilliMaxAllTotalOctets { reject = 1 } |
| if (reject) { |
| update reply { |
| Reply-Message := "Your maximum usage volume has been reached" |
| } |
| reject |
| } |
| counterCoovaChilliMaxTotalOctetsMonthly { reject = 1 } |
| if (reject) { |
| update reply { |
| /conf/radius/sqlcounter |
|---|
| 57,14 → 57,3 |
| 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}}'" |
| } |