ID:               35574
 Updated by:       [EMAIL PROTECTED]
 Reported By:      scott dot zhao at usask dot ca
 Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: SunOS
 PHP Version:      5.1.1
 New Comment:

Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.




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

[2005-12-07 23:11:09] earl dot fogel at usask dot ca

Thanks, the buildconf helped somewhat.  Php builds properly now, and I
can load the module into apache, but now our apache children are
dying:

[Wed Dec  7 15:15:58 2005] [notice] child pid 29531 exit signal
Segmentation Fault (11)
[Wed Dec  7 15:16:47 2005] [notice] child pid 29545 exit signal
Segmentation Fault (11)
[Wed Dec  7 15:16:47 2005] [notice] child pid 29483 exit signal
Segmentation Fault (11)

We are using apache 1.3.33 with php 5.1.1 on Solaris 9.

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

[2005-12-07 18:19:18] [EMAIL PROTECTED]

Did you run ./buildconf --force after that?

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

[2005-12-07 18:09:06] earl dot fogel at usask dot ca

I downloaded the latest oci8 module from PECL CVS,
and replaced the ext/oci8 directory that came with
php 5.1.1 with the CVS version.

When I run 'make', it fails with lots of "undefined symbol"
errors, eg:

ild: (undefined symbol) zif_oci_pconnect -- referenced in the data
segment of ext/oci8/.libs/oci8.o
ild: (undefined symbol) zif_oci_connect -- referenced in the data
segment of ext/oci8/.libs/oci8.o
ild: (undefined symbol) zif_oci_field_type -- referenced in the data
segment of ext/oci8/.libs/oci8.o

Here's the configure line I used:

./configure --prefix=/usr/local/encap/php-5.1.1
--with-oci8=/oracle/product/9205 --with-xmlrpc --with-ldap
--with-curl=/usr/local/encap/curl-7.14.1 --without-pdo-sqlite
--with-apxs=/var/apache-test/sbin/apxs --enable-memory-limit

What do I do now?

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

[2005-12-06 19:34:18] [EMAIL PROTECTED]

Please try OCI8 from PECL CVS.

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

[2005-12-06 19:24:03] scott dot zhao at usask dot ca

Description:
------------
It appears that the Bug #29779 was not fixed in 5.1.1, but #29779 has
been closed. So I have to open a new one here for 5.1.1

The problem is:
After the backend Oracle bounced the "Error: OCILogon error::ORA-24327:
need explicit attach before authenticating a user" error ocuured. 

Enviorment:
PHP: 5.1.1
OS: SunOS 5.9
Oracle version: 9.2
OCI $Revision: 1.269.2.3 $





Reproduce code:
---------------
- Connect to an oracle database using PHP oci8 functions from within
Apache
- Knock that database offline
- Attempt to connect again using PHP oci8 functions within same
instance
of apache
- Put the database back online
- Again, attempt to connect to Oracle database from within apache
using
OCI8 functions


Actual result:
--------------
ORA-24327: need explicit attach before authenticating a user



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


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

Reply via email to