Re: free time

2013-03-09 Thread Jed Gainer
I would still like to be able to see what they use via my admin panel I just want FR to ignore it. On Sat, Mar 9, 2013 at 2:07 AM, a.l.m.bu...@lboro.ac.uk wrote: Hi, I would like to ignore bandwidth usage between 2 and 5 am. why not change things so you dont insert such bandwidth into

Re: free time

2013-03-09 Thread Jed Gainer
Why use a different DB? On Sat, Mar 9, 2013 at 4:28 PM, Fajar A. Nugraha l...@fajar.net wrote: On Sun, Mar 10, 2013 at 8:23 AM, Jed Gainer jedgai...@gmail.com wrote: I would still like to be able to see what they use via my admin panel I just want FR to ignore it. Then use different

free time

2013-03-08 Thread Jed Gainer
I would like to ignore bandwidth usage between 2 and 5 am. sqlcounter counterChilliSpotMaxTotalOctetsDaily { counter-name = ChilliSpot-Max-Total-Octets-Daily check-name = CS-Total-Octets-Daily counter-type = data

Unsubscribe

2013-03-06 Thread Jed Gainer
Unsubscribe - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Fwd: stack allowances

2013-02-26 Thread Jed Gainer
Did anyone get this? -- Forwarded message -- From: Jed Gainer jedgai...@gmail.com Date: Fri, Feb 22, 2013 at 12:24 PM Subject: stack allowances To: FreeRadius users mailing list freeradius-users@lists.freeradius.org freeradius 2.2.0-3 sqlcounter

stack allowances

2013-02-22 Thread Jed Gainer
freeradius 2.2.0-3 sqlcounter counterChilliSpotMaxTotalOctetsDaily { counter-name = ChilliSpot-Max-Total-Octets-Daily check-name = CS-Total-Octets-Daily counter-type = data reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst = sql

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

Re: Is there a way to renew pptp user information of a user connected mikrotik?

2012-12-23 Thread Jed Gainer
I do not understand your question. On Sun, Dec 23, 2012 at 9:35 PM, 조명산 k2...@nate.com wrote: mikrotik - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: sql counter Re:

2012-12-07 Thread Jed Gainer
I looked though the SQL database. I don't see anything related to %b. On Fri, Dec 7, 2012 at 4:03 AM, Alan DeKok al...@deployingradius.com wrote: Jed Gainer wrote: /etc/raddb/sql/mysql/counter.conf there is %b unix time value of beginning of reset period ... how would i get the value

Re: sql counter Re:

2012-12-07 Thread Jed Gainer
%b is the unix time stamp of 8am on current day. mktime(8, 0, 0) in PHP seems to generate the same value as %b if anyone has this same question. :) On Fri, Dec 7, 2012 at 9:11 AM, Jed Gainer jedgai...@gmail.com wrote: I looked though the SQL database. I don't see anything related to %b

[no subject]

2012-12-06 Thread Jed Gainer
Hello everyone, in /etc/raddb/sql/mysql/counter.conf there is %b unix time value of beginning of reset period which makes things like sqlcounter counterChilliSpotMaxTotalOctetsDaily { counter-name = ChilliSpot-Max-Total-Octets-Daily