ID: 30412
User updated by: subscription at nazarenko dot net
Reported By: subscription at nazarenko dot net
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: SuSE Linux 8.2
PHP Version: 5.0.4-Dev
New Comment:
TNS_ADMIN is not used, since I do not utilize tnsnames.ora file. As you
can see from the code example I use the connection description string
directly in the script:
<?php
$db_conn = ocilogon( "user", "password",
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myoracle)(PORT=
1521)))(CONNECT_DATA=(SERVICE_NAME=CRPT)))");
?>
ORACLE_HOME is definitely set, otherwise there will be no successful
queries at all.
Previous Comments:
------------------------------------------------------------------------
[2005-02-10 21:34:05] [EMAIL PROTECTED]
Please check that you have set all environments variables (i.e.
ORACLE_HOME, TNS_ADMIN etc) properly.
------------------------------------------------------------------------
[2005-02-10 21:17:23] subscription at nazarenko dot net
Hello it is me again,
Tested both 5.0.3 release and the latest snapshot
php5-STABLE-200502101130 with both Apache 2.0.52 Prefork and Worker
MPMs.
5.0.3 and the snapshot behave identically.
Under Prefork MPM everything is 100% ok.
Under Worker the same problem as before: some page loads are
unsuccessful with no segfault. The browser just keeps waiting and
waiting and nothing happens. This happens on
average for 30% of page requests containing Oracle queries.
Don't know if you want to pursue this further as the Prefork works fine
now.
Many thanks for your time and effort!!
------------------------------------------------------------------------
[2005-01-21 01:00:08] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2005-01-13 01:27:24] [EMAIL PROTECTED]
Please, try latest snapshot with non-threaded Apache.
Are you still able to replicate the problem ?
------------------------------------------------------------------------
[2004-12-03 11:52:49] rathamahata at ehouse dot ru
Sorry, please ignore previous post. That was apache with
MPM=prefork + php compiled against apache with mpm=worker.
I don't know how did it work. After i recompiled php
against current apache problem had disappeared.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/30412
--
Edit this bug report at http://bugs.php.net/?id=30412&edit=1