[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Fwd: stack allowances
From:       Jed Gainer <jedgainer () gmail ! com>
Date:       2013-02-26 23:15:19
Message-ID: CAJc1nurSB3XXfBoJL2rU3mevaaxihZA5OMrVQjC=ukWf-YW=0w () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Did anyone get this?

---------- Forwarded message ----------
From: Jed Gainer <jedgainer@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 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
            key = User-Name
            reset = daily
            query = "SELECT IFNULL((SUM(AcctInputOctets +
AcctOutputOctets)),0) FROM radacct WHERE UserName='%{%k}' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
    }

    sqlcounter counterChilliSpotMaxTotalOctetsAll {
            counter-name = ChilliSpot-Max-Total-Octets
            check-name = CS-Total-Octets
            counter-type = data
            reply-name = ChilliSpot-Max-Total-Octets
            sqlmod-inst = sql
            key = User-Name
            reset = never
            query = "SELECT IFNULL((SUM(AcctInputOctets +
AcctOutputOctets)),0) FROM radacct WHERE UserName='%{%k}' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
    }

I use CS-Total-Octets-Daily to give staff a daily limit and CS-Total-Octets
to give guests a "jump start".

Guests can buy more bandwidth via PayPal and it is appended to their
CS-Total-Octets which works great.

Problem is when a staff member buys more they all of a sudden have
CS-Total-Octets and CS-Total-Octets-Daily in their radcheck which locks
them out because their bandwidth usage is over CS-Total-Octets.

Does anyone see a solution to my problem other than staff using 2 accounts?

[Attachment #5 (text/html)]

<div dir="ltr">Did anyone get this?<br><div><br><div class="gmail_quote">---------- \
Forwarded message ----------<br>From: <b class="gmail_sendername">Jed Gainer</b> \
<span dir="ltr">&lt;<a \
                href="mailto:jedgainer@gmail.com">jedgainer@gmail.com</a>&gt;</span><br>
                
Date: Fri, Feb 22, 2013 at 12:24 PM<br>Subject: stack allowances<br>To: FreeRadius \
users mailing list &lt;<a \
href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>&gt;<br><br><br><div \
dir="ltr"> <div><div>freeradius 2.2.0-3<br><br>    sqlcounter \
counterChilliSpotMaxTotalOctetsDaily {<br>            counter-name = \
ChilliSpot-Max-Total-Octets-Daily<br>            check-name = \
CS-Total-Octets-Daily<br>  counter-type = data<br>            reply-name = \
ChilliSpot-Max-Total-Octets<br>            sqlmod-inst = sql<br>            key = \
User-Name<br>            reset = daily<br>            query = &quot;SELECT \
IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE \
UserName=&#39;%{%k}&#39; AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime &gt; \
&#39;%b&#39;&quot;<br>

    }<br><br>    sqlcounter counterChilliSpotMaxTotalOctetsAll {<br>            \
counter-name = ChilliSpot-Max-Total-Octets<br>            check-name = \
CS-Total-Octets<br>            counter-type = data<br>            reply-name = \
ChilliSpot-Max-Total-Octets<br>

            sqlmod-inst = sql<br>            key = User-Name<br>            reset = \
never<br>            query = &quot;SELECT IFNULL((SUM(AcctInputOctets + \
AcctOutputOctets)),0) FROM radacct WHERE UserName=&#39;%{%k}&#39; AND \
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime &gt; &#39;%b&#39;&quot;<br>

    }<br><br></div>I use CS-Total-Octets-Daily to give staff a daily limit and \
CS-Total-Octets to give guests a &quot;jump start&quot;.<br><br>Guests can buy more \
bandwidth via PayPal and it is appended to their CS-Total-Octets which works \
great.<br>

<br>Problem is when a staff member buys more they all of a sudden have \
CS-Total-Octets and CS-Total-Octets-Daily in their radcheck which locks them out \
because their bandwidth usage is over CS-Total-Octets.<br><br></div> Does anyone see \
a solution to my problem other than staff using 2 accounts?<br> <div><br></div></div>
</div><br></div></div>



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

[prev in list] [next in list] [prev in thread] [next in thread]