ID:               13030
 Comment by:       [EMAIL PROTECTED]
 Reported By:      james dot mcininch at cereon dot com
 Status:           Closed
 Bug Type:         OCI8 related
 Operating System: Solaris 7
 PHP Version:      4.0.6
 New Comment:

It seems to have resurfaced again.. I keep on getting this
intermittenly on the following environment:

PHP v4.3.3
Apache v1.3.28
Solaris 8
Oracle client v8.1.7
Oracle database v9.2.0 (remote)

PHP configured with the following parameters:
--with-oci8=/export/home/oracle/app/oracle/product/8.1.7
--with-apxs=/export/home/apache_1.3.28/bin/apxs

APACHE configured with the following parameters:
--prefix=/export/home/apache_1.3.28 
--enable-module=most 
--enable-shared=max 

As noted before, just keep on pressing the reload button, it will fail
some of the time.

Thanks.


Previous Comments:
------------------------------------------------------------------------

[2002-04-13 08:51:02] [EMAIL PROTECTED]

This bug has been fixed in CVS.



------------------------------------------------------------------------

[2001-08-29 09:44:35] james dot mcininch at cereon dot com

Scripts that access oracle frequently fail to connect,
generating the error "OCISessionBegin: ORA-24327: need 
explicit attach before authenticating a user" when 
attempting OCIPLogon or OCINLogon. Accordin to the Oracle 
documentation, this message indicates that PHP attempted 
to open a connection on an invalid database handle.

Script:

<!-- keep reloading the page, it eventually dies -->
<?php
   $connection = OCIPLogon("user", "password", "database");
   if ($connection)
   {
      $sth = OCIParse($connection, "select table_name from 
all_tables");
      OCIExecute($sth);
      while (OCIFetchInto($sth, $result))
         echo "$result[0]<br>\n";
   }
?>

Modules:

'./configure' '--prefix=/usr/local' 
'--with-apxs=/usr/local/apache/bin/apxs' 
'--with-config-file-path=/usr/local/apache/conf' 
'--disable-xml' '--enable-bcmath' '--enable-calendar' 
'--enable-ftp' '--enable-shared' '--enable-sigchild' 
'--enable-sysvshm' '--enable-sysvsem' '--enable-shmop' 
'--enable-trans-sid' '--enable-yp' '--disable-xslt' 
'--enable-discard-path' '--enable-gd-native-ttf' 
'--enable-ucd-snmp-hack' '--enable-magic-quotes' 
'--with-bz2=/home/jjmcin' 
'--with-db3=/home/jjmcin/tmp/php' 
'--with-dom=/home/jjmcin/tmp/php' 
'--with-gd=/home/jjmcin/tmp/php' 
'--with-png-dir=/home/jjmcin/tmp/php' 
'--with-jpeg-dir=/home/jjmcin/tmp/php' 
'--with-t1lib=/home/jjmcin/tmp/php' 
'--with-tiff-dir=/home/jjmcin/tmp/php' 
'--with-ttf=/home/jjmcin/tmp/php' 
'--with-freetype-dir=/home/jjmcin/tmp/php' 
'--with-xpm-dir=/home/jjmcin/tmp/php' 
'--with-iconv=/home/jjmcin/tmp/php' 
'--with-ldap=/home/jjmcin/tmp/php' 
'--with-mysql=/home/jjmcin' '--with-oci8' 
'--with-openssl=/home/jjmcin/tmp/php' 
'--with-pgsql=/home/jjmcin/tmp/php' 
'--with-snmp=/home/jjmcin/tmp/php/snmp' 
'--with-zlib-dir=/home/jjmcin/tmp/php' 
'--with-zlib=/home/jjmcin/tmp/php' 
'--with-sablot=/home/jjmcin/tmp/php' 
'--with-xslt-sablot=/home/jjmcin/tmp/php' 
'--with-expat-dir=/home/jjmcin/tmp/php' 
'--with-pdflib=/home/jjmcin/tmp/php' 
'--with-mcrypt=/home/jjmcin/tmp/php' 
'--with-mhash=/home/jjmcin/tmp/php' 
'--with-curl=/home/jjmcin/tmp/php' 
'--with-java=/opt/share/java1.2/jdk1.2.2'

All extensions are statically linked except Oracle.

Oracle version is 8.1.6, load on the oracle server is
fairly low and server is setup with default settings for
Solaris. Apache version is 1.3.14 running as user "nobody"
There is no observed connectivity problems using sqlplus
or other oracle utilities.

Environment variables are set properly. and queries work 
properly at least 40% of the time (just click the reload 
button in the browser).




------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=13030&edit=1

Reply via email to