Re: sqlcounter help

Dear Sir this is the log in debugging mode , in query in using query = "SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM radacct WHERE UserName='%{%k}'" it works just fine Waking up in 5 seconds... rad_recv: Access-Request packet from host 192.168.22.2:52098, id=20, length=114 Serv

Re: sqlcounter help

Mordor Networks wrote: > It is disconnecting the user if limit is reached but user can connect > again like it is not stopping the account, now if i replace the query > with #query = "SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM > radacct WHERE UserName='%{%k}'" that will disconnect the

sqlcounter help

Dear Gentlemen I'm having a problem with my daily count : sqlcounter chillispot_max_bytes_daily { counter-name = ChilliSpot-Max-Total-Octets check-name = ChilliSpot-Max-Total-Octets reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(AcctInp