Community discussions

MikroTik App
Cartman
Member Candidate
Member Candidate
Topic Author
Posts: 104
加入: Wed Jul 23, 2008 6:14 pm

How do I pass more than one attribute with sqlcounter

Tue Oct 29, 2013 7:50 pm

Hello world !!!

I want to limit the transferred volume of data for my hotspot users to 5GB.
In counter.conf I have :
Code:Select all
sqlcounter volumecounter{ counter-name = Max-All-Octets check-name = Mikrotik-Total-Limit reply-name = Mikrotik-Xmit-Limit sqlmod-inst = sql key = User-Name reset = never query = "select ifnull(sum(acctinputoctets),0) from radacct WHERE UserName='%{%k}'" }
This only conpares to Mikrotik-Total-Limit and returns only Mikrotik-Xmit-Limit. What do I need to do
相关的返回值d Gigawords values ?
Is it possible to get both values from one counter or do I need a second one?

I have seen that the problem was often discussed here, the answers were always "use ...-Gigawords", but
no one had a solution how to implement it.

Any hints ?

TIA
Top
Cartman
Member Candidate
Member Candidate
Topic Author
Posts: 104
加入: Wed Jul 23, 2008 6:14 pm

Re: How do I pass more than one attribute with sqlcounter

Wed Nov 06, 2013 6:01 pm

Anyone ?
Top

Who is online

Users browsing this forum:Bing [Bot],kravemirand 2 guests