rlm_sqlcounter noresetcounter

classic Classic list List threaded Threaded
2 messages Options
| Threaded
Open this post in threaded view
|

rlm_sqlcounter noresetcounter

N White
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!

--
---------------------------
| Nick White              |
| [hidden email]     |
---------------------------

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
| Threaded
Open this post in threaded view
|

Re: rlm_sqlcounter noresetcounter

N White
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!
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html