ID: 13030
Updated 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:
Please, upgrade to the latest release of PHP.
Previous Comments:
------------------------------------------------------------------------
[2004-03-25 08:51:41] gioppo at csi dot it
This bug represent itself on:
Apache Version Apache/1.3.29
Apache Release 10329100
Apache API Version 19990320
SERVER_SOFTWARE Apache/1.3.29 (Unix) PHP/4.3.2
Revision $Revision: 1.183.2.5 $
Oracle Version 8.1
Please check it out.
Luca
------------------------------------------------------------------------
[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
