I am using the rlm_sqlcounter module. According to the doc/rlm_sqlcounter
file, the sqlcounter.conf file their should be an A/V pair for the
monthlycounter {} directive that says 'sqlmod-inst = sqlcca3'. What is
this?
When I use it with 'sqlmod-inst = sqlcca3' I get an SQL error, however when
I change this value to 'sqlmod-inst = sql', everything works great.
Any reason why this should be 'sqlcca3' instead of how I got it below:
(sqlcounter.conf file):
sqlcounter monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
# sqlmod-inst = sqlcca3
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
Thanks,
Ed
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
