The 'reset' parameter problem

[SORROW]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140121/cce73a2d/attachment.html>