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
