php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #35574 Error: OCILogon error::ORA-24327: need explicit attach before authenticating a
Submitted: 2005-12-06 19:24 UTC Modified: 2006-03-04 17:23 UTC
Votes:14
Avg. Score:4.8 ± 0.6
Reproduced:13 of 13 (100.0%)
Same Version:7 (53.8%)
Same OS:6 (46.2%)
From: scott dot zhao at usask dot ca Assigned:
Status: Closed Package: OCI8 related
PHP Version: 5.1.1 OS: SunOS
Private report: No CVE-ID: None
 [2005-12-06 19:24 UTC] 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


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-12-06 19:34 UTC] tony2001@php.net
Please try OCI8 from PECL CVS.
 [2005-12-07 18:09 UTC] 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-07 18:19 UTC] tony2001@php.net
Did you run ./buildconf --force after that?
 [2005-12-07 23:11 UTC] 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-08 10:50 UTC] tony2001@php.net
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.


 [2005-12-16 01:00 UTC] 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".
 [2006-01-10 18:51 UTC] thomas at hkey dot de
Same problem with PHP 5.0.4, SunOS 5.9, Oracle 9.2 and OCI8 Revision 1.257.2.6. Bug seems not be fixed in #29779.
 [2006-01-16 13:20 UTC] olostan at gmail dot com
Same problm under:
PHP Version 5.0.3
Linux 2.4.21-27 SMP

for now no solution found except apache restart
 [2006-01-16 13:29 UTC] tony2001@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip


 [2006-01-17 16:33 UTC] trade dot development at just dot fgov dot be
This Snapshot solve the same problem we had with 5.1.2 on our 

IBM eServer PPC64 RHAS4upd2 with Oracle 10.2g for POWERLinux

Linux edas-enav.just.fgov.be 2.6.9-22.0.1.EL #1 SMP Tue Oct 18 18:35:10 EDT 2005 ppc64
Build Date 	Jan 17 2006 14:29:04
Configure Command 	'./configure' '--prefix=/opt/WEB/php51-200601171130_compiled_81' '--with-apxs=/opt/WEB/apache-1.3.34_compiled_81/bin/apxs' '--with-oci8=/opt/Oracle_10g/oracle/product/10.2.0-cli/db_2' '--without-mysql' '--enable-sigchild' '--enable-memory-limit' '--with-libxml-dir=/opt/WEB/libxml2-2.6.19_compiled'
 [2006-01-18 17:50 UTC] rdc at rdcitsolutions dot co dot uk
I'm experiencing the same problem, but the latest snap didn't fix it.

5.1.3-dev (18/Jan/2006) contains OCI8 $Revision: 1.269.2.3 $

The scheme is the same as reported befire:

- Start Oracle (v9.2)
- Start Apache
- Everything ok
- Restart Oracle
- ORA-24327 Returned when trying to connect
 [2006-01-24 01:00 UTC] 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".
 [2006-02-02 17:10 UTC] rdc at rdcitsolutions dot co dot uk
Did anyone solve this?
 [2006-03-03 00:59 UTC] ohmybees at gmail dot com
I've been watching this issue (in various bug reports) for 
some time. I compiled today's snapshot php5.1-200603022330, 
and the bug is fixed (I triple checked just to make sure)! 
PHP 5.1.2 still exhibits the bug.

Thank you, thank you! I'm finally going to be able to switch 
to PHP 5 when 5.1.3 comes out.

For reference, I'm using PHP5.1.1/5.1.2 on OS X 10.3/10.4 
(both client and Server versions). PHP 4.3.11 has been solid 
for me.

Thanks again!
 [2006-03-04 17:23 UTC] tony2001@php.net
I'm afraid I din't commit any fixes that may affect this issue, so you just changed something in your environment, that fixed it.
But if the issue doesn't exist anymore, I close the report.
Feel free to reopen it, if you find some more info.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 11:01:30 2024 UTC