At 03:18 PM 7/29/2002 +0200, you wrote:
>Hello,
>
>I'd like to use rlm_sqlcounter with freeradius 0.7 (using oracle backend),
>but it does not work. I have the following config:
>
> sqlcounter totalcounter {
> counter-name = Total-Session-Time
> check-name = Total-Time-Limit
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(AcctSessionTime) a FROM acct_internet
>WHERE UserName='%{%k}'"
> }
Hi, I'd guess you need to remove the extra 'a' in your query just before
"FROM acct_internet".
Randy Moore
Axion Information Technologies, Inc.
email [EMAIL PROTECTED]
phone 301-408-1200
fax 301-445-3947
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
