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