[users@httpd] Apache / PHP / UnixODBC / oracle

[Neil Marjoram <n....@vam.ac.uk>]

I have a small problem which is beginning to annoy me!

Can you help?

I have a PHP application connecting to an Oracle database on a seperate
server. The application works fine until we reach the maximum number of
connections to the database. We've been testing and found that the
odbc_close in PHP does not actually close the connection. 

In detail we know that PHP opens the connection, and sends the close to
the database, which then show no connected sessions, however we can see
an oracle process on the DB server, and also an 'estabilished'
connection from the netstat output on the apache server. The sql.log for
PHP shows a succesful close statement. 

The only way to go is to restart apache, which then drops all the open
connections to the other server.

Has anyone else seen this problem?

Versions tested all showing this problem :

RedHat 7.3
Apache 1.3.27
PHP 4.1.3  and also PHP 4.3.2
oracle-driver 0.5.1 (as from easysoft public licence)
unixODBC 2.2.0 and also unixODBC 2.2.2

Now atempting install with apache 2.0.47 and PHP 4.3.2 to see if I still
have the problem. (on RH 9.0)

Database is Oracle 8.1.7 on Solaris 8

Thanks for any help,

Neil.
-- 
Neil Marjoram <n....@vam.ac.uk>
Victoria & Albert Museum


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

Re: [users@httpd] Apache / PHP / UnixODBC / oracle

[Aaron Morris <aa...@mindspring.com>]

Neil Marjoram wrote:
> I have a small problem which is beginning to annoy me!
> 
> Can you help?
> 
> I have a PHP application connecting to an Oracle database on a seperate
> server. The application works fine until we reach the maximum number of
> connections to the database. We've been testing and found that the
> odbc_close in PHP does not actually close the connection. 

I seem to remember reading (after configuring PHP) that PHP with Oracle 
under Linux might have a problem killing processes.  I believe you need 
to compile with --enable-sigchild to fix.  Beyond that, you will 
probably have to ask someone on a PHP list.

-- 
Aaron W Morris <aa...@mindspring.com> (decep)


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org