update

[Jed Gainer]

  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 at freeradius.org> wrote:

>
> 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
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131208/0a8749a2/attachment.html>