I've been wading through everything I can find regarding the installation
and configuration of the rlm_sqlcounter module using 0.8.1. It seems to me
that some changes were made to the distribution and the docs haven't
caught up. What I'd like to do is two-fold:
1. sketch out the approach I intend to try and solicit comments (see
below),
2. prepare an updated replacement doc and annotated .conf file for
distribution.
Here's what I think will work, based on existing docs/files/etc, and
assuming the sql module is installed and in use:
a. configure/compile freeradius using --with-rlm_sqlcounter
b. create etc/raddb/sqlcounter.conf using info from doc/rlm_sqlcounter and
etc/raddb/experimental.conf, e.g.,
monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "blahblahblah"
}
c. add to etc/radiusd.conf in the modules section:
$INCLUDE ${confdir}/sqlcounter.conf
d. add to etc/radiusd.conf in the authorize section:
sqlcounter {
monthlycounter
}
e. add to the radcheck or radgroupcheck tables the appropriate check-name
a/v pairs
This seems to me that it *should* work, but I've been known to be a moron
at times, so I'd appreciate any feedback and any clue-by-4 whacking that
I need.
Jim
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
