[Chilli] freeradius

Jed Gainer jedgainer at gmail.com
Fri Dec 7 03:19:44 UTC 2012


I know this isn't the place but I have no idea where else to ask.

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
                        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'"
        }

possible

how would i get the value of %b for a user from say PHP so i can calc
and show them how much bandwidth they have left


More information about the Chilli mailing list