On Wed, Nov 03, 2004 at 07:27:18PM +0100, Roberto Re wrote:
> hi,
> 
> I have applied the patch yesterday only, but the problem still exists.
> The cursors are allocated and they continuously increase up to the maximum
> limit imposed by Oracle to the db.
> 
> I have analysed some of the queries allocating the cursors: there are some
> query to RADGROUPCHECK and RADGROUPREPLY tables, which are _*empty*_.
> Could it be those ones raising the problem?
> 
> As we are not using those 2 tables , would it be possible to modify the
> cfg of Freeradius, so that it does no longer use them?
> 
> I will also try to insert some dummy-values in the two RADGROUP...
> 
> Thanks and regards
> Roberto
>

I am not using RADGROUPCHECK and RADGROUPREPLY either so I have
commented out all the relevant lines for them (including the queries)
in oraclesql.conf. I haven't noticed any problem with cursor
allocating in oracle 8i. Our DBA told me that there are database
parameters you can tune that could help (look at cursor_sharing and
instead of the value EXACT use FORCE (for 8i) or SIMILAR (for 9i)). 

Kostas
 
> 
> 
> > On Thu, Oct 14, 2004 at 11:13:40AM +0200, Roberto Re wrote:
> >>
> >>
> >> Kostas Zorbadelos wrote:
> >>
> >> >On Wed, Oct 13, 2004 at 06:25:25PM +0200, Roberto Re wrote:
> >> >
> >> >>First of all thanks for your attention, Alan
> >> >>
> >> >>My problem however seems to be more like this:
> >> >>http://lists.cistron.nl/pipermail/freeradius-devel/2002-December/004052.html
> >> >>
> >> >>I had already checked the working code, which includes that patch and
> >> it
> >> >>is exactly the following one:
> >> >>
> >> >>http://www.freeradius.org/cvs-log/radiusd/src/modules/rlm_sql/drivers/rlm_sql_oracle/sql_oracle.c
> >> >>
> >> >The code in this url does not include the patch Alan is reffering
> >> >to. Of course the patch in
> >> >http://bugs.freeradius.org/show_bug.cgi?id=128 addresses the
> >> >freeradius crash in case of Oracle errors in sql queries. This happens
> >> >with the Oracle 8i client libraries. I was told that Oracle 9 client
> >> >libs do not cause the freeradius crash (not tested my self).
> >>
> >> In my experience with Oracle 9 client (on a Linux RedHat Enterprise) the
> >> freeRADIUS dont crash, it dont realease cursors on the oracle side.
> >>
> >> Roberto
> >>
> >
> > OK, if the crashes do not happen on successive Oracle errors, try the
> > patch and let us know if it also solves your problem.
> 
> 
> 
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> 

-- 
  Kostas Zorbadelos
  Systems Developer, Otenet SA 
  mailto: [EMAIL PROTECTED]
  
  Out there in the darkness, out there in the night
  out there in the starlight, one soul burns brighter
  than a thousand suns.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to