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.
[EMAIL PROTECTED] 1-701-355-5727
--
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
