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