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