I have a working FreeRadius installation used for PPPOE clients using a Mikrotik NAS (Essentialy Linux)
I am using Freeradius to limit data a user can send/receive within a month and automatically reset it every month. I used an example from chilliuspot hotspot for this. However what im noticing is sometimes a customer gets denied access because he has exceeded he's monthly allowance, however when I check the Db this is not the case cause it's the beginning of month. This only happens sometimes so im lost! I use sqlcounter.conf for the counter part of things and INCLUDE this from radius.conf. sqlcounter monthlytraffic { counter-name = Monthly-Traffic check-name = Max-Monthly-Traffic reply-name = Mikrotik-Xmit-Limit-Gigawords sqlmod-inst = sql key = User-Name reset = monthly query = "SELECT SUM(AcctInputOctets - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0))+ SUM(AcctOutputOctets -GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" } Anybody for input? I would greately appreciate help here! A Work around is to simply increase he's allowance till he is allowed to connect!
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html