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