Yes I am. I done absolutely like this.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of john
zurowski
Sent: Saturday, March 15, 2003 10:25 PM
To: [EMAIL PROTECTED]
Subject: Re: Problem in starting radius with sqlcounter
You mention you added sqlcounter.conf to radius.conf
did you add it like this :
modules {
..... all the other modules ....
$INCLUDE ${confdir}/sqlcounter.conf
}
This configuration works for me
>From: Eric <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Problem in starting radius with sqlcounter
>Date: Sat, 15 Mar 2003 16:50:15 +0500
>
>I'm compiled freeradius-snapshot-2003-03-13 with experimental modules
>support.
>I create sqlcounter.conf file and include it to radiusd.conf
>
>#############sqlcounter.conf####################
>noresetcounter {
> 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}'"
> }
>
>dailycounter {
> counter-name = Daily-Session-Time
> check-name = Max-Daily-Session
> sqlmod-inst = sqlcca3
> key = User-Name
> reset = daily
> query = "SELECT SUM(AcctSessionTime - MAX((%b -
>UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND
>UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>
>monthlycounter {
> counter-name = Monthly-Session-Time
> check-name = Max-Monthly-Session
> sqlmod-inst = sqlcca3
> key = User-Name
> reset = monthly
> query = "SELECT SUM(AcctSessionTime - MAX((%b -
>UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND
>UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>weeklycounter {
> counter-name = Weekly-Session-Time
> check-name = Max-Weekly-Session
> sqlmod-inst = sqlcca3
> key = User-Name
> reset = 1w
> query = "SELECT SUM(AcctSessionTime - MAX((%b -
>UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND
>UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>alltimecounter {
> counter-name = All-Time
> check-name = Max-All-Time
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT UNIX_TIMESTAMP() -
>MIN(UNIX_TIMESTAMP(AcctStartTime)) FROM radacct WHERE UserName='%{%k}'"
> }
>
>octetcounter {
> counter-name = Max-User-Octets
> check-name = Max-Octets
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(AcctOutputOctets) -
>SUM(AcctInputOctets)
>FROM radacct WHERE UserName='%{%k}'"
> }
>########authorize section of radiusd.conf##########################
>
>authorize {
> suffix
> sql
> files
> noresetcounter
> dailycounter
> monthlycounter
> weeklycounter
> alltimecounter
>octetcounter
>}
>
>############radius debug############################
>.............................
>..............................
>Module: Instantiated pap (pap)
>Module: Loaded realm
> realm: format = "suffix"
> realm: delimiter = "@"
>Module: Instantiated realm (suffix)
>Module: Loaded files
> files: usersfile = "/etc/radius/users"
> files: acctusersfile = "/etc/radius/acct_users"
> files: preproxy_usersfile = "/etc/radius/preproxy_users"
> files: compat = "no"
>Module: Instantiated files (files)
>radiusd.conf[1] Failed to link to module 'rlm_noresetcounter': file not
>found
>
>why???
>
>
>
>
>-
>List info/subscribe/unsubscribe? See
>http://www.freeradius.org/list/users.html
_________________________________________________________________
MSN Messenger - fast, easy and FREE! http://messenger.msn.co.uk
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
