(RADIATOR) 2.18.3: ORA-00911: invalid character

[Mariano Absatz]

Hi,

I didn't download the new version... but looking at Pavel's message, what it 
seems is that the %0 and %2 arguments have not been replaced by the correct 
vaules... in runtime (i.e. when the log is generated), %0 should be replaced 
by the NAS-Identifier and %2 with the NAS-Port attributes...

Mike?

It seems I'll wait a couple more days before installing it :-)


El 30 Aug 2001, a las 14:39, Colin D. Easton escribió:

> Hi all,
> 
> Ok digging deeper into the code it appears it's not SqlDb.pm that is the
> problem but rather SessSQL.pm:
> 
> 
> SessSQL.pm:    $self->{DeleteQuery} = "delete from RADONLINE where
> NASIDENTIFIER='%0' and NASPORT=0%2";
> 
> Note the missing tick "'" where the zero is "0" above.
> 
> Hmm shouldn't this have been caught in the alpha or beta test cycle?
> 
> Come on guys.
> 
> Colin
> 
> -----Original Message-----
> From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] 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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
> Behalf Of Pavel A Crasotin
> Sent: Thursday, August 30, 2001 4:28 AM
> To: radiator at open.com.au
> 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
> 

--
Mariano Absatz
El Baby
----------------------------------------------------------
This isn't an office. It's Hell with fluorescent lighting.

===
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.