Re: Oracle cursor leak

2004-11-11 Thread Alexander Serkin
Kostas Zorbadelos wrote: ... I resubmit the patch as a text file (output of diff sql_oracle.c.before_patch sql_oracle.c freeradius_oracle_patch) because from the web page I had problems applying it and I was forced to apply it partly by hand editing of the code... the same problem. I cannot

Re: Oracle cursor leak

2004-11-11 Thread Kostas Zorbadelos
On Thu, Nov 11, 2004 at 02:23:36PM +0300, Alexander Serkin wrote: OK here is the patched file. You can verify it if you diff it with the original file. Kostas Kostas Zorbadelos wrote: ... I resubmit the patch as a text file (output of diff sql_oracle.c.before_patch sql_oracle.c

Re: Oracle cursor leak

2004-11-04 Thread Kostas Zorbadelos
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

Re: Oracle cursor leak

2004-11-04 Thread Roberto Re
Kostas Zorbadelos writes: 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

Re: Oracle cursor leak

2004-11-03 Thread Roberto Re
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

Re: Oracle cursor leak

2004-10-14 Thread Kostas Zorbadelos
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

Re: Oracle cursor leak

2004-10-14 Thread Kostas Zorbadelos
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:

Re: Oracle cursor leak (Roberto Re)

2004-10-14 Thread Babar Shafiq
Hi List, I have some problem with Oracle too, when any error occured like index violation oracle just drop one connection, it says re-connect but I don't think it is not re-connecting, and in some days radiusd is out of connection and I got no more connection to Db , login denied message in

Re: Oracle cursor leak (Roberto Re)

2004-10-14 Thread Andrea Gabellini
Hi, apply the patch in the bug number 128. The 1.0.1 version doesn't contain it. This patch solves your problem and probably manages better the Oracle connection. Andrea At 17.49 14/10/2004, you wrote: Hi List, I have some problem with Oracle too, when any error occured like index violation

Re: Oracle cursor leak

2004-10-13 Thread Roberto Re
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:

Re: Oracle cursor leak

2004-10-13 Thread Alan DeKok
Roberto Re [EMAIL PROTECTED] wrote: I had already checked the working code, which includes that patch and it is exactly the following one: Ok. So are you *still* seeing a problem? If so, no one else has reported anything similar yet. Function: sql_free_result , does this function realease

Oracle cursor leak

2004-10-12 Thread Roberto Re
Hi, I've installed a FreeRADIUS version 1.0.0 on a Linux Red Hat Enterprise with Oracle Client 9.1, it never close any cursors it opened, leading to all sorts of interesting problems when the max-open-cursor limits were hit. How can I fix this problem ? Thanks in advance Roberto - List

Re: Oracle cursor leak

2004-10-12 Thread Alan DeKok
Roberto Re [EMAIL PROTECTED] wrote: I've installed a FreeRADIUS version 1.0.0 on a Linux Red Hat Enterprise with Oracle Client 9.1, it never close any cursors it opened, leading to all sorts of interesting problems when the max-open-cursor limits were hit. How can I fix this problem ?