Re: (RADIATOR) 2.18.3: ORA-00911: invalid character

2001-08-30 Thread Hugh Irvine 


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  -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-1: 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, '11C9', 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, '11C9', 999159157, '', 'Async', 'Framed-User')': ORA-1:
> 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, 15, 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/ra

Re: (RADIATOR) 2.18.3: ORA-00911: invalid character

2001-08-30 Thread 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: [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  -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-1: 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, '11C9', 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, '11C9', 999159157, '', 'Async', 'Framed-User')': ORA-1:
> > 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, 15, 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 [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.

RE: (RADIATOR) 2.18.3: ORA-00911: invalid character

2001-08-30 Thread 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: [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  -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-1: 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, '11C9', 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, '11C9', 999159157, '', 'Async', 'Framed-User')': ORA-1:
> 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, 15, 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

RE: (RADIATOR) 2.18.3: ORA-00911: invalid character

2001-08-30 Thread Colin D. Easton 

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  -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-1: 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, '11C9', 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, '11C9', 999159157, '', 'Async', 'Framed-User')': ORA-1:
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, 15, 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.

RE: (RADIATOR) 2.18.3: ORA-00911: invalid character

2001-08-30 Thread Colin D. Easton 

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: [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  -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-1: 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, '11C9', 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, '11C9', 999159157, '', 'Async', 'Framed-User')': ORA-1:
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, 15, 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.

RE: (RADIATOR) 2.18.3: ORA-00911: invalid character

2001-08-30 Thread Colin D. Easton 

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  -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-1: 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, '11C9', 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, '11C9', 999159157, '', 'Async', 'Framed-User')': ORA-1:
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, 15, 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.