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. [EMAIL PROTECTED] 1-701-355-5727 --
. . .
Fri Nov 22 09:27:15 2002: DEBUG: Packet dump:
*** Received from 216.235.160.45 port 52901 ....
Code: Access-Request
Identifier: 181
Authentic: 1234567890123456
Attributes:
User-Name = "[EMAIL PROTECTED]"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
NAS-Port-Type = Async
User-Password = "<....>"
Fri Nov 22 09:27:15 2002: DEBUG: Rewrote user name to [EMAIL PROTECTED]
Fri Nov 22 09:27:15 2002: DEBUG: Rewrote user name to [EMAIL PROTECTED]
Fri Nov 22 09:27:15 2002: DEBUG: Handling request with Handler ''
Fri Nov 22 09:27:15 2002: DEBUG: SessionDB Deleting session for
[EMAIL PROTECTED], 203.63.154.1, 1234
Fri Nov 22 09:27:15 2002: DEBUG: do query is: BEGIN
radius.deleteRADOnline('[EMAIL PROTECTED]','216.235.160.45', 1234); END;
Fri Nov 22 09:27:15 2002: DEBUG: Handling with Radius::AuthGROUP
Fri Nov 22 09:27:15 2002: DEBUG: Handling with Radius::AuthLDAP2: BTICheckLDAP
Fri Nov 22 09:27:15 2002: INFO: Connecting to ds1v.btinet.net, port 389
Fri Nov 22 09:27:15 2002: INFO: Attempting to bind with cn=proxyagent,ou=people,o=bti,
<....> (server ds1v.btinet.net:389)
Fri Nov 22 09:27:15 2002: DEBUG: LDAP got result for
uid=jsignal,ou=people,o=clientfactor.com,o=bti
Fri Nov 22 09:27:15 2002: DEBUG: LDAP got userPassword: {crypt}<....>
Fri Nov 22 09:27:15 2002: DEBUG: LDAP got bticheckattr: Simultaneous-Use=1
Fri Nov 22 09:27:15 2002: DEBUG: LDAP got btireplyattr: Service-Type = Framed-User,
Framed-Protocol = PPP
Fri Nov 22 09:27:15 2002: DEBUG: Radius::AuthLDAP2 looks for match with
[EMAIL PROTECTED]
Fri Nov 22 09:27:15 2002: DEBUG: Radius::AuthLDAP2 REJECT: Bad Encrypted password
Fri Nov 22 09:27:15 2002: DEBUG: Handling with Radius::AuthPLSQL
Fri Nov 22 09:27:15 2002: DEBUG: Handling with Radius::AuthPLSQL: BTICheckDB
Fri Nov 22 09:27:15 2002: DEBUG: Query is: BEGIN
radius.getUser('[EMAIL PROTECTED]',:passwd,:check_item,:reply_item); END;
Fri Nov 22 09:27:16 2002: DEBUG: Radius::AuthPLSQL looks for match with
[EMAIL PROTECTED]
Fri Nov 22 09:27:16 2002: DEBUG: Radius::AuthPLSQL REJECT: Bad Encrypted password
Fri Nov 22 09:27:16 2002: INFO: Access rejected for [EMAIL PROTECTED]: Bad
Encrypted password
Fri Nov 22 09:27:16 2002: DEBUG: do query is: BEGIN
radius.logAppAction('[EMAIL PROTECTED]','rad','LOGIN FAILED (nstest1):
[EMAIL PROTECTED] ('Bad Encrypted password')','error','216.235.160.45'); END;
Fri Nov 22 09:27:16 2002: ERR: do failed for 'BEGIN
radius.logAppAction('[EMAIL PROTECTED]','rad','LOGIN FAILED (nstest1):
[EMAIL PROTECTED] ('Bad Encrypted password')','error','216.235.160.45'); END;':
ORA-06550: line 1, column 112:
PLS-00103: Encountered the symbol "BAD" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in mod not range rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like
between is null is not || is dangling (DBD ERROR: OCIStmtExecute)
Fri Nov 22 09:27:16 2002: ERR: do failed for 'BEGIN
radius.logAppAction('[EMAIL PROTECTED]','rad','LOGIN FAILED (nstest1):
[EMAIL PROTECTED] ('Bad Encrypted password')','error','216.235.160.45'); END;':
ORA-06550: line 1, column 112:
PLS-00103: Encountered the symbol "BAD" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in mod not range rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like
between is null is not || is dangling (DBD ERROR: OCIStmtExecute)
Fri Nov 22 09:27:16 2002: DEBUG: Packet dump:
*** Sending to 216.235.160.45 port 52901 ....
Code: Access-Reject
Identifier: 181
Authentic: 1234567890123456
Attributes:
Reply-Message = "Request Denied"
Fri Nov 22 09:27:20 2002: DEBUG: Monitor received command: STATS .
Fri Nov 22 09:27:20 2002: DEBUG: Monitor received command: STATS .
Fri Nov 22 09:27:23 2002: DEBUG: Monitor received command: ID
. . .
