Fwd: (RADIATOR) Problems with SqlDB.pm module.

[Julio Cesar Pinto]

Hi Mike,

The radiator works ok approximately 15 min, but always it dies with same
log.

I'm working with DBI-1.38.tar.gz and DBD-Oracle-1.14.tar.gz.

The oracle version are 8.1.72

Thanks,

JC

On Sun, 2003-09-07 at 18:40, Mike McCauley wrote:
> HelloJulio,
> 
> 
> On Mon, 8 Sep 2003 09:10 am, Hugh Irvine wrote:
> 
> >
> > Begin forwarded message:
> > > From: Julio Cesar Pinto <jc at ifx.com.co>
> > > Date: Sun Sep 7, 2003  10:51:45 Australia/Melbourne
> > > 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.
> 
> Hmmm, I suspect that the problem may have been triggered earlier in your log 
> file. Can we see some more of the logfile, inlcluding the previous few 
> requests?
> 
> Does it always die on the first request?
> What version of DBD-Oracle and DBI are you using. Have you upgraded them 
> recently too? What version of Oracle?
> 
> Cheers.
> 
> > >
> > >
> > > 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
> > >
> > > ===
> > > 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.
> >
> > NB: have you included a copy of your configuration file (no secrets),
> > together with a trace 4 debug showing what is happening?
-- 
Julio Cesar Pinto <jc at ifx.com.co>
IFX NETWORKS

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