Anyone have advice/input? N White wrote:
I'm having trouble setting up the noresetcounter(Max-All-Session). I'm running freeradius 1.0.4(Debian). I have compiled and added the rlm_sqlcounter.so files to the proper folder in Debian, and freeradius -X shows the module starting up(I have renamed it "hotspotcounter"). If you would like to see the full output of either the request or startup let me know. I'd really like to tackle this thing, so any help/pointers are appreciated.
freeradius -X |grep sqlcounter Config: including file: /etc/freeradius/sqlcounter.conf sqlcounter: counter-name = "Max-All-Session-Time" sqlcounter: check-name = "Max-All-Session" sqlcounter: key = "User-Name" sqlcounter: sqlmod-inst = "sql" sqlcounter: query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" sqlcounter: reset = "never" rlm_sqlcounter: Counter attribute Max-All-Session-Time is number 1671 rlm_sqlcounter: Check attribute Max-All-Session is number 1672 rlm_sqlcounter: Current Time: 1123455447 [2005-08-07 15:57:27], Next reset 0 [2005-08-07 15:00:00] rlm_sqlcounter: Current Time: 1123455447 [2005-08-07 15:57:27], Prev reset 0 [2005-08-07 15:00:00] Module: Instantiated sqlcounter (hotspotcounter)
I keep getting this result on debug(NTRadping and Chillispot):
rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair
Here is what is in radcheck database(00-0B-6A-65-95-B8 is the username):
699 00-0B-6A-65-95-B8 User-Password := password 700 00-0B-6A-65-95-B8 Max-All-Session := 1800
Here is sqlcounter.conf:
sqlcounter hotspotcounter { counter-name = Max-All-Session-Time check-name = Max-All-Session sqlmod-inst = sql key = User-Name reset = never query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" }
Here is radius.conf:
modules { $INCLUDE ${confdir}/sql.conf $INCLUDE ${confdir}/sqlcounter.conf }
authorize{ sql hotspotcounter }
Thanks!