ID: 36545
User updated by: jistanidiot at gmail dot com
Reported By: jistanidiot at gmail dot com
Status: Bogus
Bug Type: OCI8 related
Operating System: RHEL4
PHP Version: 5.1.2
New Comment:
The 5.0.x was probably with Oracle 9i. All of the 5.1.x have been with
Oracle 10g.
I strongly object to this being labled as bogus. This is not an Oracle
issue as Oracle works just fine. This is clearly a PHP issue as PHP
does not work fine. PHP needs to meet the requirements of Oracle if it
is going to use Oracle. Until it can meet the requirements PHP has a
bug.
Previous Comments:
------------------------------------------------------------------------
[2006-02-28 10:30:40] [EMAIL PROTECTED]
Oracle libraries have certain requirements and this is not PHP or OCI8
issue.
------------------------------------------------------------------------
[2006-02-27 23:56:27] cjbj at hotmail dot com
Can you verify that the same version of Oracle was used in yours tests
with PHP 5.0.3 and 5.1.x? Oracle 10.2 defaults to a stricter set of
directory permissions than previous versions of Oracle. The only time
I've seen this problem has been when the version of Oracle changed.
------------------------------------------------------------------------
[2006-02-27 18:19:59] jistanidiot at gmail dot com
Description:
------------
When any oci_connect is called an error message about OCIEnvNlSCreate()
failing is produced.
Workaround: add the apache user to the oracle group. This only occurs
in 5.2.1. Previous versions of PHP which I've tried (5.0.3 and 5.1.0)
did not have this problem. Obviously this is a security issue as the
apache user now has a lot more things it can use to wreak havoc.
Oracle version 10.2.0.1.0. Apache version 2.0.52.
OS: Red Hat Enterprise Linux ES 4.
Reproduce code:
---------------
$conn = oci_connect('user', 'pass', 'db');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
Expected result:
----------------
Expect to actually connect to the database
Actual result:
--------------
[error] PHP Warning: oci_connect() [<a
href='function.oci-connect'>function.oci-connect</a>]:
OCIEnvNlsCreate() failed. There is something wrong with your system -
please check that ORACLE_HOME is set and points to the right directory
in <scriptname> on line <linenum>
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36545&edit=1
