#36355 [Opn->Fbk]: OCIEnvNlsCreate() failed.

ID: 36355 Updated by: tony2001@php.net Reported By: jnavratil at houston dot rr dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Fedora Core 4.2 PHP Version: 6CVS-2006-02-10 (snap) New Comment: How do you set ORACLE_HOME and did you set any other environment variables? Is ORACLE_HOME dir readable by the user httpd uses for its childs? What do you mean by "patched oci8.c"? Previous Comments: ------------------------------------------------------------------------ [2006-02-10 16:12:48] jnavratil at houston dot rr dot com Description: ------------ OCIEnvNlsCreate() failed. Message asks to check that ORACLE_HOME is set correctly. I've downloaded the latest snapshot ('php5.1-200602101330') and patched oci8.c to report getenv("ORACLE_HOME") into the error_log and verified that it is correct. CLI version will properly connect, php5_module through Apache will not. Configuration script to build php is: ./configure \ --cache-file=../config.cache \ --with-config-file-path=/etc \ --with-config-file-scan-dir=/etc/php.d \ --disable-debug \ --disable-rpath \ --with-bz2 \ --with-curl \ --with-gd --with-freetype-dir=/usr --with-png-dir=/usr --with-jpeg-dir=/usr --enable-gd-native-ttf \ --with-gettext \ --with-gmp \ --with-iconv \ --with-openssl --with-kerberos \ --with-pspell=/usr \ --with-pcre-regex=/usr \ --with-zlib \ --with-layout=GNU \ --enable-exif \ --enable-ftp \ --enable-magic-quotes \ --enable-sockets \ --enable-sysvsem \ --enable-sysvshm \ --enable-sysvmsg \ --enable-shmop \ --enable-wddx \ --with-pear=/usr/share/pear \ --enable-ucd-snmp-hack \ --enable-memory-limit \ --enable-calendar \ --with-mime-magic=/etc/httpd/conf/magic \ --without-sqlite \ --with-libxml-dir=/usr \ --with-xml \ --with-apxs2=/usr/sbin/apxs \ --without-mysql \ --without-odbc \ --disable-dba \ --with-oci8=/opt/app/oracle/product/10.2.0/db_1 Reproduce code: --------------- $dbh = OCILogon('my-user', 'my-pwd', 'my-db'); Expected result: ---------------- I expect a valid database resource Actual result: -------------- $dbh is boolean false. Error_log contains: [Fri Feb 10 08:58:58 2006] [error] [client 127.0.0.1] PHP Warning: ocilogon() [<a href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/www/html/listViews.php on line 3 [Fri Feb 10 08:58:58 2006] [error] [client 127.0.0.1] PHP Warning: ocilogon() [<a href='function.ocilogon'>function.ocilogon</a>]: /opt/app/oracle/product/10.2.0/db_1 in /opt/www/html/listViews.php on line 3 Note: '/opt/app/oracle/product/10.2.0/db_1' is my correct ORACLE_HOME and is reported using getenv("ORACLE_HOME"). ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36355&edit=1