Thanks for your help.

> U can specify the sql "query" for the counter:
> counter maxinput {
>        filename = ${logdir}/db.maxinput
>        key = User-Name
>        count-attribute = Acct-Input-Octets
>        reset = never
>        counter-name = Input-Octets
>        check-name = ChilliSpot-Max-Input-Octets
>        query = "SELECT
> SUM(Acct-Input-Octets+Acct-Output-Octets) FROM radacct
> where UserName='%{%k}'"
> }

Ok, sounds reasonable, but I forgot to mention that I am not using
SQL, I am using just the simple counter module which uses files and I
suppose I can't use the query. At least it didn't work.

And another thing I forgot to mention .. I am using a Debian Woody
(yes, I know, it is pretty much outdated ...) with Freeradius
FreeRADIUS Version 1.0.2.

I suppose it would be a good idea to update our system :-)

best regards
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to