hello friends .. i have some problem with reset parameter .. i use this setting for data limit and traffic limitation .. If reset parameter is one of this value : " weekly, monthly ,never " counter work fine and user disconnect in exact usage of limitatin ... but like in this setting reset = daily or hourly user not disconnect in exact usage !!! how can in solve this problem ? sqlcounter monthlytrafficcounter { counter-name = Monthly-Traffic check-name = Max-Monthly-Traffic reply-name = Mikrotik-Xmit-Limit sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) > '%b'" } ==== regards
SORROW wrote:
i use this setting for data limit and traffic limitation .. If reset parameter is one of this value : " weekly, monthly ,never " counter work fine and user disconnect in exact usage of limitatin ...
OK...
but like in this setting reset = daily or hourly user not disconnect in exact usage !!! how can in solve this problem ?
That should work. Can you provide more information other than it doesn't work? Maybe a simple test case? Alan DeKok.
participants (2)
-
Alan DeKok -
SORROW