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@gmail.com> wrote:
query = "SELECT SUM(acctsessiontime - \ GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)) \ FROM radacct WHERE username = '%{%k}' AND \ UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'"
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
On Thu, Jan 3, 2013 at 6:57 AM, Periko Support <pheriko.support@gmail.com> wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html