Re: Problem in starting radius with sqlcounter

Sat, 15 Mar 2003 09:24:37 -0800


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

Reply via email to