Hello,
It doesn't work without it either. I think it will be some kind of Oracle
specific bug. Especially as the Simultaneous-Use check does not work with
Oracle in 0.7 either.
Felician
----- Original Message -----
From: "Randy Moore" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 17:14
Subject: Re: rlm_sqlcounter
> 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
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html