counters logic?

Periko Support pheriko.support at gmail.com
Fri Jan 4 19:26:46 CET 2013


Interesting, I'm debugging fr2 with mysql, I turn on mysql log, still
haven't seen this query in my logs, I trying to setup a hotspot with
fr2.
Wondering how fr2 is calculating users time available and where he
saves each user amount of time value.

Thanks Jed.

On Thu, Jan 3, 2013 at 9:38 AM, Jed Gainer <jedgainer at gmail.com> wrote:
>         query = "SELECT SUM(acctsessiontime - \
>                  GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)) \
>                  FROM radacct WHERE username = '%{%k}' AND \
>                  UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'"
>
> On Thu, Jan 3, 2013 at 6:57 AM, Periko Support
> <pheriko.support at gmail.com> wrote:
>> Hi.
>>
>> I'm trying to understand the logic fr2 for counters, I'm working with
>> modules counter and sql_counter.
>>
>> a) Once u setup a user:
>>
>> Max-Daily-Session := 900
>>
>> Where he saves this info?
>>
>> b) What formula he use to calculate the user time available?
>>
>> Any info about will be appreciated, thanks!!!
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


More information about the Freeradius-Users mailing list