(RADIATOR) 2.18.3: ORA-00911: invalid character

Hugh Irvine hugh at open.com.au
Thu Aug 30 19:28:23 CDT 2001


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: 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 ''
> From owner-radiator at open.com.au Thu Aug 30 17:51:57 2001
Received: (from majordomo at localhost)
	by server1.open.com.au (8.11.0/8.11.0) id f7UMpvT05719
	for radiatorzz-list; Thu, 30 Aug 2001 17:51:57 -0500
X-Authentication-Warning: server1.open.com.au: majordomo set sender to owner-radiator at open.com.au using -f
Received: from entoo.connect.com.au (entoo.connect.com.au [192.189.54.8])
	by server1.open.com.au (8.11.0/8.11.0) with ESMTP id f7UMpu305716
	for <radiator at open.com.au>; Thu, 30 Aug 2001 17:51:56 -0500
Received: from hugo (acc19-ppp236.mel.dialup.connect.net.au [210.10.138.236])
	by entoo.connect.com.au (Postfix) with SMTP
	id AB285DFCFD; Fri, 31 Aug 2001 10:36:04 +1000 (EST)
From: Hugh Irvine <hugh at open.com.au>
Reply-To: hugh at open.com.au
Organization: Open System Consultants
To: "Derek Buttineau" <derek.buttineau at csolve.net>,
   "Derek Buttineau" <derek at csolve.net>, <radiator at open.com.au>
Subject: Re: (RADIATOR) SQL configuration
Date: Fri, 31 Aug 2001 10:04:24 +1000
X-Mailer: KMail [version 1.1.99]
Content-Type: text/plain;
  charset="iso-8859-1"
References: <002201c1319d$62b8f6c0$8850a4cf at csolve.net>
In-Reply-To: <002201c1319d$62b8f6c0$8850a4cf at csolve.net>
MIME-Version: 1.0
Message-Id: <0108311004241J.00948 at hugo>
Content-Transfer-Encoding: 8bit
Sender: owner-radiator at open.com.au
Precedence: bulk
List-Id: <radiator.list-id.open.com.au>


Hello Derek -

Could you please send me a trace 4 debug from Radiator showing everything 
from startup onwards.

thanks

Hugh

On Friday 31 August 2001 07:47, Derek Buttineau wrote:
> Good Day,
>
> I'm having an odd situation here... we were testing with Radiator 2.18.2
> Trial version and it was working fine with the configuration below... when
> we purchased our license the live version was Radiator 2.18.3... with this
> new version the following configuration does not work..
>
> All I get when doing the perl test on it is:
>
> Thu Aug 30 17:34:43 2001: ERR: Attribute number 48943 (vendor 429) is not
> defined in your dictionary
> Thu Aug 30 17:34:43 2001: ERR: Attribute number 38999 (vendor 429) is not
> defined in your dictionary
>
> Even though there's not yet any radius packets coming to it.
>
> Could anyone tell me what I'm doing wrong (this config is to authenticate
> packets coming from our main Radius server which is still running a 3com
> radius product [switching it over once we've run the product on this realm
> for awhile])..
>
> Thanks,
>
> Derek Buttineau
> Internet Systems Administrator
> Compu-SOLVE Internet Services
>
> --------------------------------------
>
> Foreground
> LogStdout
> LogDir          /var/log
> DbDir           /usr/local/etc/raddb
>
> # You will probably want to change this to suit your site.
> <Client DEFAULT>
>         Secret  Hum69Mer
>         DupInterval 0
> </Client>
>
> # You can put client details in a database table
> # and get their details from there with something like this:
> <ClientListSQL>
>         DBSource        dbi:mysql:radius
>         DBUsername      radius
>         DBAuth          **password**
> </ClientListSQL>
>
> # This will authenticate users from SUBSCRIBERS
> <Realm DEFAULT>
>     <AuthBy SQL>
>         # Adjust DBSource, DBUsername, DBAuth to suit your DB
>
>         DBSource        dbi:mysql:radius
>         DBUsername      radius
>         DBAuth          csrox
>
>         # You may want to tailor these for your ACCOUNTING table
>         # You can add your own columns to store whatever you like
>         AccountingTable ACCOUNTING
>         AcctColumnDef   USERNAME,User-Name
>         AcctColumnDef   TIME_STAMP,Timestamp,integer
>         AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
>         AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
>         AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
>         AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
>         AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
>         AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
>         AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
>         AcctColumnDef   NASIDENTIFIER,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.
>
> ===
> 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.
>
> ===
> 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.
NAS-Identifier
>         AcctColumnDef   NASPORT,NAS-Port,integer
>         AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
>
>         # You can arrange to log accounting to a file if the
>         # SQL insert fails with AcctFailedLogFileName
>         # That way you could recover from a broken SQL
>         # server
>         #AcctFailedLogFileName %D/missedaccounting
>     </AuthBy>
>
> ===
> 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.


More information about the radiator mailing list