(RADIATOR) FailureQuery quoted string

[Jason Signalness]

Hello again,

I applied the patches using the following procedure:
1) copied the patches archive into the Radiator_3.3.1 directory and 
gunzip/untarred it.
2) ran perl Makefile.PL
3) ran make test (everything ok)
4) ran make install
5) restarted radiator.  I noticed the radiusd file was updated during 
this process.

However, I still get the same exact problem.  I'll attach a piece of my 
radius log.

Thanks for the help,
Jason


Hugh Irvine wrote:
> 
> 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
--
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 11-22-2002-radius.log
URL: <http://www.open.com.au/pipermail/radiator/attachments/20021122/802030d3/attachment.ksh>