Re: counters logic?

2013-01-04 Thread Periko Support
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

counters logic?

2013-01-03 Thread Periko Support
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!!! -

Re: counters logic?

2013-01-03 Thread Jed Gainer
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