ID: 19129
Comment by: p dot m at iol dot it
Reported By: dante dot lorenso at atmosenergy dot com
Status: No Feedback
Bug Type: OCI8 related
Operating System: RedHat Linux 7.3
PHP Version: 4.2.1
New Comment:
I experienced the identical problem with Oracle 8.1.5 and various
PHP/apache combinations (in particular RedHat9 + Apache 2.0.47 + PHP
4.3.3).
My solution is to place in the loop a (failing) call to
OCINLogon(sameuser,samepass)
**with no SID argument**
after *every* failed logon attempt.
My opinion is that for some reason PHP uses the previous SID/tnsnames
arguments without noticing they are changed.
If you omit them PHP is forced to try the (undefined) ORACLE_SID
environment variable and after getting the error:
****ocinlogon(): OCISessionBegin: ORA-07200:****
****slsid: oracle_sid not set****
it has cleaned his memory.
Hope this helps.
Previous Comments:
------------------------------------------------------------------------
[2002-10-08 21:43:44] [EMAIL PROTECTED]
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
------------------------------------------------------------------------
[2002-09-13 11:59:11] [EMAIL PROTECTED]
plz send me a minimal _SELF_CONTAINED_ (= complete) script
that i can run on my dev-box.
------------------------------------------------------------------------
[2002-09-12 09:20:11] dante dot lorenso at atmosenergy dot com
I can't let you inside the firewall to see the problem first-hand, but
I'll run any tests you want. Here is some phpinfo() for you:
----------
System
----------
Linux dfw1wu19 2.4.18-5 #1 Mon Jun 10 15:31:48 EDT 2002 i686 unknown
----------
Build Date
----------
Jul 10 2002 11:11:19
----------
Configure Command
----------
'./configure' '--with-oracle=/opt/app/oracle/product/8.1.5'
'--with-oci8=/opt/app/oracle/product/8.1.5' '--enable-sigchild'
'--with-ldap' '--with-gd'
'--with-config-file-path=/www/apache/conf/php'
'--with-apache=../apache_1.3.26/' '--enable-track-vars'
'--enable-bcmath' '--enable-ftp'
----------
Server API
----------
Apache
----------
Virtual Directory Support
----------
disabled
----------
Configuration File (php.ini) Path
----------
/www/apache-1.3.26_ssl/conf/php/php.ini
----------
Debug Build
----------
no
----------
Thread Safety
----------
disabled
------------------------------------------------------------------------
[2002-09-12 04:58:12] [EMAIL PROTECTED]
seems to work for me (oracle 9.2.0.1)
any chance i could get a login on your box to see the
problem?
------------------------------------------------------------------------
[2002-09-12 04:58:12] [EMAIL PROTECTED]
seems to work for me (oracle 9.2.0.1)
any chance i could get a login on your box to see 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/19129
--
Edit this bug report at http://bugs.php.net/?id=19129&edit=1
