(RADIATOR) 2.18.3: ORA-00911: invalid character

Thu Aug 30 13:39:46 CDT 2001

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

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