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:
Excuse me please, is the last message automatic? Has there been any work done related to this bug (i.e. threaded apache + php5 + oracle) in the latest snapshot? I cannot easily recompile PHP at the moment and will do so only if it is justified. Previous Comments: ------------------------------------------------------------------------ [2005-03-07 22:04:03] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-02-16 04:44:34] subscription at nazarenko dot net 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. ------------------------------------------------------------------------ [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-13 01:27:24] [EMAIL PROTECTED] Please, try latest snapshot with non-threaded Apache. Are you still able to replicate the problem ? ------------------------------------------------------------------------ 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
