RE [PHP-INSTALL] OCIEnvNlsCreate() failed

When you su root to start apache check your environment variables, i usually log in as oracle user then i use su command so the root user still possess the env variables needed, but right now i have an issue that LD_LIBRARY_PATH is simply erased when i su, i don't know why and this block me from being able to use PDO_OCI or oci8, so i edited apache2ctl script and added the line 'export LD_LIBRARY_PATH=/path/to/oracle/libs/:$LD_LIBRARY_PATH' That allowed to be able to use oci8 but i am still stucked with PDO_OCI for 3 weeks already complaining about OCI_INVALID_HANDLE error message. I hope the method i explained will help you Jerôme Kaluza Service du Sang Service Informatique Croix-Rouge de Belgique rue de Stalle 96 - 5e étage B-1180 Bruxelles Tél. : + 32 (0)2 371 35 27 Fax : + 32 (0)2 371 35 23 j.kaluza@redcross-transfusion.be http://www.transfusion.be P.S.: Le temps de lire ce mail, 1 personne aura eu besoin d?une transfusion en Belgique pour survivre. Alors, n'oublions pas : une vie est irremplaçable, pas le sang ! Plus d'infos, sur http://www.transfusion.be. ahmed nabel <a_n_alazzawi@hotmail.com> 20/06/2008 13:05 A <php-install@lists.php.net> cc Objet [PHP-INSTALL] OCIEnvNlsCreate() failed Hi A problem with connecting to remote oracle db via php. The error message is: Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in /Library/WebServer/Documents/test.php on line 14 Oracle connection failed. The phpinfo shows: Apache Environment ... ... PATH /usr/bin:/bin:/usr/sbin:/sbin ... oci8 OCI8 Support enabled Version 1.2.4 Revision $Revision: 1.269.2.16.2.38 $ Active Persistent Connections 0 Active Connections 0 Oracle Instant Client Version 10.2 Temporary Lob support enabled Collections support enabled Directive Local Value Master Value oci8.default_prefetch 10 10 oci8.max_persistent -1 -1 oci8.old_oci_close_semantics 0 0 oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20 ... Environment Variable Value PATH /usr/bin:/bin:/usr/sbin:/sbin ... ... Any ideas? PS: php 5.2.5 Apache 2.2.8 Mac OS X 10.5.2 _________________________________________________________________ http://clk.atdmt.com/UKM/go/msnnkmgl0010000009ukm/direct/01/