Hello everyone
I configure freeradius for authentication my users also work authentication fine but when my users hit the bandwidth per month (1G) those are not disconnect automatically…!!!
But if the PPPoE connection’s are disconnect other than cann’t connect.
My problem is when the customers is bandwith is hits are connections is not disconect.
I make a sqlcounter in counter.conf:
sqlcounter poyrazwifi_Limit{
counter-name = Mikrotik-Total-Limit
check-name = Mikrotik-Total-Limit
reply-name = Session-Timeout
sqlmod-inst = sql
key = User-Name
reset = never
query = "select (sum(acctinputoctets) + sum(acctoutputoctets)) from radacct where username = '%{%k}';"
}
and this Cods on site-enable/default ~ authorize
poyrazwifi_Limit{
reject = 1
}
if(reject){
ok
reject
update reply {
Reply-Message := "Your account has expired, %{User-Name} your bandwidth is limited "
}
}
And in the radcheck mysql database:
insert into radcheck (username,attribute,op,value) values('test','Mikrotik-Total-Limit',':=','1073741824')