update

[Arran Cudbard-Bell]

On 1 Dec 2013, at 03:24, Jed Gainer <jedgainer at gmail.com> wrote:

> I did a system upgrade and my silly disto upgraded FreeRADIUS to 3.0.0 so I am reconfiguring it from scratch because of the changes. I have managed to get SQL up and running but am having troubles getting my sqlcounters to work.
> 
> After putting the following in /etc/raddb/mods-config/sql/counter/mysql/queries.conf
> 
> sqlcounter counter_octets_daily {
>         sql_module_instance = sql
> 
>         counter_name = ChilliSpot-Max-Total-Octets-Daily
>         check_name = CS-Total-Octets-Daily
>         reply-name = ChilliSpot-Max-Total-Octets
> 
>         key = User-Name
>         reset = daily
>         query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }

The examples are wrong, they got accidentally moved into that folder during the reorganisation, most likely because of the incorrect header lines.

> I put "counter_octets_daily" in the authorize{} block after "sql" in /etc/raddb/sites-available/default
> 
> but when I try and boot radiusd I get:

Make a file in /etc/raddb/mods-available/sql_counter move that section in there, link it to /etc/raddb/mods-enabled/sql_counter.

-Arran

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS Development Team