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 <jedgai...@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.supp...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html