You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Neil Marjoram <n....@vam.ac.uk> on 2003/07/01 16:23:59 UTC

[users@httpd] Apache / Oracle / PHP problems

Can anyone help?


We have a PHP site that connects to Oracle using unix-odbc /
oracle-odbc-driver (ex of Easysoft)

We are finding that connections to the database are not closed when the
odbc_close is sent. PHP thinks the connection is closed, but the oracle
process remains. However when apache is restarted the oracle connections
are all terminated correctly. It is of course not practical to keep
restarting apache, can anyone suggest a solution?

OS : Redhat 7.3
PHP : 4.1.2
Apache : 1.3.27
Oracle : 8.1.7
oracle-odbc : 0.51

Thanks for your 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 / Oracle / PHP problems

Posted by Robert Andersson <ro...@profundis.nu>.
Neil Marjoram wrote:
> We are finding that connections to the database are not closed when the
> odbc_close is sent. PHP thinks the connection is closed, but the oracle
> process remains. However when apache is restarted the oracle
> connections are all terminated correctly.

This is likely an issue with PHP. We had similar problems a while ago, but
with MySQL connections.

> can anyone suggest a solution?

Upgrade PHP. I think this issue was resolved with version 4.3.1.

Regards,
Robert Andersson





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