(RADIATOR) 2.18.3: ORA-00911: invalid character

[Hugh Irvine]

Hello Mariano, Hello All -

Yes there is a bug in the Radiator 2.18.3 distribution that will be fixed 
later today.

Our apologies for any inconvenience.

regards

Hugh


On Friday 31 August 2001 05:47, Mariano Absatz wrote:
> 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.

-- 
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.