Hotspot - Mikrotik-Total-Limit - Volume Limits

RouterOS General
1

For those that wonder of the Total Limit is supported, Yes it is. I got it working with freeradius and MT 3.22

ADD these linesdictionary.mikrotik

ATTRIBUTE Mikrotik-Total-Limit 17 integer
ATTRIBUTE Mikrotik-Total-Limit-Gigawords 18 integer

In radius.conf

sqlcounter monthlybytecounter {
counter-name = Monthly-Total-Max-Octets
check-name = Max-Monthly-Octets
reply-name = Mikrotik-Total-Limit
sqlmod-inst = sql
key = User-Name
reset = monthly
query = “SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM radacct WHERE UserName=‘%{%k}’
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > ‘%b’”

Make sure to set Volume limits in user profile.

Max-Monthly-Octets
ChilliSpot-Max-Total-Octets

Use EZradius radius configuration and sql.conf

Satlizard

2

I have found that it only counts the user’s Total bytes when you login.

Once the user is logged in the Hotspot will only disconnect the user once his current session reaches the limit set by Mikrotik-Total-Limit.

If some one has this working correctly could they please post the SQL radreply and radcheck attribute that is setup for the user.

3

it’s solved by add
ATTRIBUTE Mikrotik-Total-Limit 17 integer
ATTRIBUTE Mikrotik-Total-Limit-Gigawords 18 integer
to dictionary.mikrotik lines (thanks to satlizard26)
but now i have another problem…
when i use 192.168.2.2 for radius client ip,user can log in and appear on hotspot active user but didn’t appear at admin dashboard (i use access manager for radius management) so his/her balance not reducing
but when i use 192.168.10.1 for radius client ip,request got rejected because freeradius read request coming from 192.168.2.2,not from 192.168.10.1

how to make freeradius read request coming from 192.168.10.1 not from 192.168.2.2?

thanks for all your help…

PS. sorry for my bad english…