[Fwd: RE: (RADIATOR) Problems with SqlDB.pm module.]

[Mike McCauley]

Hello Julio,


On Tue, 9 Sep 2003 09:16 am, Julio Cesar Pinto wrote:
> Hi Frank,
>
> The Oracle logs don't show nothing. And with the old version i dont have
> this problem.

Have you made any other changes in this system as part of your upgrade?

Would it be possible to see logs from your old working system and your new 
non-working system, so you can see if the patter of ORacle requests is 
different?

Cheers.

>
> Thanks,
> JC.
>
> On Mon, 2003-09-08 at 08:28, Frank Danielson wrote:
> > Hi Julio-
> >
> > It has been my experience that an ORA-01002 error happens when the
> > results of the query are no longer available, usually due to memory or
> > TEMP space limitations on the database server. Have a look in yor Oracle
> > server's error log when this happens and you should see one or more
> > additional errors that point to the root of the problem.
> >
> > -Frank
> >
> > -----Original Message-----
> > From: Julio Cesar Pinto [mailto:jc at ifx.com.co]
> > Sent: Saturday, September 06, 2003 8:52 PM
> > To: radiator at open.com.au
> > Subject: (RADIATOR) Problems with SqlDB.pm module.
> >
> >
> > Hi Guys.
> >
> > We are working with version 2.8 without problem. We are trying to
> > upgrade to version 3.6, but the daemon (radiusd) dies with the following
> > error:
> >
> > DBD::Oracle::db prepare failed: ORA-01002: fetch out of sequence (DBD
> > ERROR: OCIStmtExecute/Describe) [for Statement "select PASSWORD,
> > TO_CHAR(EXPIRATION,'YYYY-MM-DD'), CHECKATTR, REPLYATTR  from SUBSCRIBERS
> > where USERNAME='tadomenech' and ACTIVE=1"] at
> > /usr/lib/perl5/site_perl/5.6.1/Radius/SqlDb.pm line 180.
> >
> >
> > We're working with the following:
> > Linux RedHat Version 7.3.
> > Perl Version 5.6.1
> > Radiator Version 3.6 with the patches-3.6 applied.
> >
> > I thank for any information on the matter.
> >
> >
> > Regards,
>
> --
> Julio Cesar Pinto <jc at ifx.com.co>
> IFX NETWORKS

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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