sqlcounter counter_octets_daily {
        sql_module_instance = "sql"
        key = "User-Name"
        query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
        reset = "daily"
        counter_name = "ChilliSpot-Max-Total-Octets-Daily"
        check_name = "CS-Total-Octets-Daily"
        reply_name = "ChilliSpot-Max-Total-Octets"
  }
/etc/raddb/mods-enabled/sql_counter[1]: Configuration item 'reply_name' cannot be a VSA
/etc/raddb/mods-enabled/sql_counter[1]: Instantiation failed for module "counter_octets_daily"



On Sun, Dec 1, 2013 at 2:24 AM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:

On 1 Dec 2013, at 03:24, Jed Gainer <jedgainer@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@freeradius.org>
FreeRADIUS Development Team

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