(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