(RADIATOR) FailureQuery quoted string

[Hugh Irvine]

Hello Jason -

There is a patch for this in the patches area.

If it doesn't fix the problem please let me know.

regards

Hugh


On Friday, Nov 22, 2002, at 09:35 Australia/Melbourne, Jason Signalness 
wrote:

> Hello,
>
> I tried to post this a few hours ago, but it didn't show up in the 
> list for whatever reason.  I apologize if it shows up twice.
>
> We make use of <AuthLog SQL> to log authentication failures to an SQL 
> database (Oracle).  After upgrading to Radiator v3.3.1, this fails.
>
> The reason is that we use a %1 in the FailureQuery parameter to log 
> the error.  The single quotes that are now a part of %1 (the quoted 
> reason string for the failure) messes up our SQL syntax.
>
> Is there any way to get just the reason string, without the quotes?
>
> Here's my <AuthLog SQL> clause:
>
> # Log authentication FAILURES to the database for  customers.
> <AuthLog SQL>
>         Identifier BTIAuthLoggerSQL
>         DBSource        dbi:Oracle:<hidden>
>         DBUsername      <hidden>
>         DBAuth          <hidden>
>
>         Timeout                 10
>         FailureBackoffTime      60
>
>         FailureQuery    BEGIN radius.logAppAction('%n','rad','LOGIN 
> FAILED (%h): %n (%1)','error','%c'); END;
> </AuthLog>
>
> Thanks in advance,
>
> -- 
> Jason Signalness, Systems Administrator
> Basin Telecommunications, Inc.
> jason at btiadmin.net 1-701-355-5727
> --
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.