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