Hello Colin, Hello All -
As mentioned in another email, there is a bug in the Radiator 2.18.3
distribution which will be fixed later today.
The bug is not the definition of the the query shown below, rather it is the
call to format_special() later in the code that does not pass the correct
arguments to expand %0 and %1.
Our apologies to everyone who has had a problem.
regards
Hugh
On Friday 31 August 2001 05:09, Colin D. Easton wrote:
> Further localized to SessSQL.pm in
>
> /usr/local/lib/perl5/site_perl/5.005/Radius
>
> and made the mod' as follows (like the 2.8.2 code:
>
> $self->{DeleteQuery} = "delete from RADONLINE where
> NASIDENTIFIER='%N' and NASPORT=0%{NAS-Port}";
>
> But still getting the following 'ERR' message after the change above in
> the Radius log:
>
> Thu Aug 30 19:02:37 2001: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='%0' and NASPORT='%2'': ORA-01722: invalid n
> umber (DBD ERROR: OCIStmtExecute)
> Thu Aug 30 19:02:37 2001: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='%0' and NASPORT='%2'': ORA-01722: invalid n
> umber (DBD ERROR: OCIStmtExecute)
>
> Thoughts/comments/feedback welcome.
>
> Colin
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
> Behalf Of Colin D. Easton
> Sent: Thursday, August 30, 2001 11:45 AM
> To: 'Pavel A Crasotin'; Radiator
> Subject: RE: (RADIATOR) 2.18.3: ORA-00911: invalid character
>
> I have the same thing. Looks like there's a bug in the Sqldm.pm code
> release for Radiator 2.8.3:
>
> lab1.yml# ./radpwtst -user <user-name> -password <password>
> sending Access-Request...
> OK
> sending Accounting-Request Start...
> DBD::Oracle::db do failed: ORA-00911: invalid character (DBD ERROR:
> OCIStmtExecute) at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
> line 232.
> DBD::Oracle::db do failed: ORA-00911: invalid character (DBD ERROR:
> OCIStmtExecute) at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
> line 232.
> DBD::Oracle::db do failed: ORA-00001: unique constraint
> (RADIUS15.RADONLINE_PK) violated (DBD ERROR: OCIStmtExecute) at
> /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 232.
> OK
> sending Accounting-Request Stop...
> OK
>
>
> Please advise.
>
> Colin
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
> Behalf Of Pavel A Crasotin
> Sent: Thursday, August 30, 2001 4:28 AM
> To: [EMAIL PROTECTED]
> Subject: (RADIATOR) 2.18.3: ORA-00911: invalid character
>
> Hi,
>
> I've just installed Radiator 2.18.3.
> In the logfile I see ERR message like this:
>
> Thu Aug 30 12:12:37 2001: DEBUG: Handling request with Handler ''
> Thu Aug 30 12:12:37 2001: DEBUG: SessDB Adding session for MARGO,
> x.x.x.2, 4
> Thu Aug 30 12:12:37 2001: DEBUG: do query is: delete from RADONLINE
> where NASIDENTIFIER='%0' and NASPORT=0%2
> Thu Aug 30 12:12:37 2001: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='%0' and NASPORT=0%2': ORA-00911: invalid character
> (DBD ERROR: OCIStmtExecute)
> Thu Aug 30 12:12:43 2001: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='%0' and NASPORT=0%2': ORA-00911: invalid character
> (DBD ERROR: OCIStmtExecute)
> Thu Aug 30 12:12:43 2001: DEBUG: do query is: insert into RADONLINE
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS, NASPORTTYPE,SERVICETYPE) values ('MARGO', 'x.x.x.2',
> 04, '000011C9', 999159157, '', 'Async', 'Framed-User')
> Thu Aug 30 12:12:45 2001: ERR: do failed for 'insert into RADONLINE
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS, NASPORTTYPE,SERVICETYPE) values ('MARGO', 'x.x.x.2',
> 04, '000011C9', 999159157, '', 'Async', 'Framed-User')': ORA-00001:
> unique constraint (RADIUS.RADONLINE_I) violated (DBD ERROR:
> OCIStmtExecute)
>
> Can you help me to correct this bug?
>
>
> With respect,
> Pavel A Crasotin
> ____________________________________
> OJSC SeverTransCom
> 40/13 Sobinova, Yaroslavl, 150000, Russia
> Tel/Fax: +7 (0852) 47-71-70, 47-69-49
> +7 (0852) 72-17-28, 72-17-38
>
> ===
> 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.
>
> ===
> 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.
>
> ===
> 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.
