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

Reply via email to