Counter Attribute Mikrotik-Total-Limit Must be Integer64
Hi, Trying to prevent authorization of users after usage limited data. I have set sqlcounter for this but debug mode showing this error "counter Attribute Mikrotik-Total-Limit Must be Integer64". Inserted "Mikrotik-Total-Limit" in radcheck. I have set other counter but those were working fine. Searched google but no luck. I also check default Mikrotik dictionary, Mikrotik-Total-Limit exist there with interger and id 17. Should I changed that or how can I update attribute? I am using Ubuntu 18.4 and Freeradius 3.0.16 Thank
Hi, I've solved the same problem with a perl example in the book "FreeRadius The Beginners Guide by Dirk Van Der Walt". There's a few typos in the code, but you'll figure it out. The sqlcounter module is not the best for these purposes as stated in the book. Uchenna Nebedum On Thu, Mar 7, 2019, 20:06 One Zero Art <onezeroartapps@gmail.com> wrote:
Hi,
Trying to prevent authorization of users after usage limited data. I have set sqlcounter for this but debug mode showing this error "counter Attribute Mikrotik-Total-Limit Must be Integer64".
Inserted "Mikrotik-Total-Limit" in radcheck.
I have set other counter but those were working fine. Searched google but no luck. I also check default Mikrotik dictionary, Mikrotik-Total-Limit exist there with interger and id 17. Should I changed that or how can I update attribute?
I am using Ubuntu 18.4 and Freeradius 3.0.16
Thank - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi Uchenna, Thank you, I will definitely check that out but I need some quick fix now. Is there any other way to fix this? thank you On Fri, Mar 8, 2019 at 1:15 AM Uchenna Nebedum <nebeduch@gmail.com> wrote: > Hi, I've solved the same problem with a perl example in the book > "FreeRadius The Beginners Guide by Dirk Van Der Walt". There's a few typos > in the code, but you'll figure it out. The sqlcounter module is not the > best for these purposes as stated in the book. > > Uchenna Nebedum > > On Thu, Mar 7, 2019, 20:06 One Zero Art <onezeroartapps@gmail.com> wrote: > > > Hi, > > > > Trying to prevent authorization of users after usage limited data. > > I have set sqlcounter for this but debug mode showing this error "counter > > Attribute Mikrotik-Total-Limit Must be Integer64". > > > > Inserted "Mikrotik-Total-Limit" in radcheck. > > > > I have set other counter but those were working fine. Searched google but > > no luck. I also check default Mikrotik dictionary, Mikrotik-Total-Limit > > exist there with interger and id 17. Should I changed that or how can I > > update attribute? > > > > I am using Ubuntu 18.4 and Freeradius 3.0.16 > > > > > > Thank > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html
On Mar 7, 2019, at 2:06 PM, One Zero Art <onezeroartapps@gmail.com> wrote:
Trying to prevent authorization of users after usage limited data. I have set sqlcounter for this but debug mode showing this error "counter Attribute Mikrotik-Total-Limit Must be Integer64".
That's because you tried to use that attribute in sqlcounter. Don't do that. The attribute used for the counter should be one that doesn't exist already. That is, the counter is just a counter, and that's what it means. You can't use Mikrotik-Total-Limit as a counter, because it already has a well-defined meaning. Set the configuration to use something like: counter_name = Total-Daily-Limit
Inserted "Mikrotik-Total-Limit" in radcheck.
I have set other counter but those were working fine. Searched google but no luck. I also check default Mikrotik dictionary, Mikrotik-Total-Limit exist there with interger and id 17. Should I changed that or how can I update attribute?
Don't edit the dictionaries. All of those attributes have pre-defined meanings. Changing them is wrong. Alan DeKok.
participants (3)
-
Alan DeKok -
One Zero Art -
Uchenna Nebedum