reibill wrote:
> HI
>
> I found a problem that , when I use nginx + php + php-fpm + oracle
> client , sometime I saw some error message in php-error-log,like this
> below
>
> [14-Jul-2009 06:34:06] PHP Warning: oci_connect() [<a
> href='function.oci-connect'>function.oci-connect</a>]: OCIEnvNlsCreate
> () fail
> ed. There is something wrong with your system - please check that
> ORACLE_HOME is set and points to the right directory in /home/mypath/
> to/test.php on line 411
>
> but I already set the oracle envionment variables
>
> export ORACLE_BASE=/usr/lib/oracle
> export ORACLE_HOME=$ORACLE_BASE/10.2.0.3/client
> export NLS_LANG=AMERICAN_AMERICA.US7ASCII
> export TNS_ADMIN=$ORACLE_HOME/network/admin
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
> export LD_ASSUME_KERNEL=2.6.9
> export ORACLE_SID=orcl
>
> export PATH=$HOME/local/rar:$HOME/local/php5.2.8-fcgi/bin/:$PATH
>
> then I use spawn-fcgi instead of php-fpm ,then the error message
> disappeared.
>
> so I think may be there is a bug in php-fpm that sometime some process
> could not got the envionment
>
> btw: I have config the php-fpm.conf as those below
>
> <value name="environment">
> <value name="HOSTNAME">$HOSTNAME</value>
> <value name="PATH">/usr/local/bin:/usr/bin:/bin</
> value>
> <value name="ORACLE_HOME">/usr/lib/oracle/10.2.0.3/
> client</value>
> <value name="TMP">/tmp</value>
> <value name="TMPDIR">/tmp</value>
> <value name="TEMP">/tmp</value>
> <value name="OSTYPE">$OSTYPE</value>
> <value name="MACHTYPE">$MACHTYPE</value>
> <value name="MALLOC_CHECK_">2</value>
>
> did someone have the same problems ?
Never tried Oroacle myself, but have you tried echoing ORACLE_HOME
variable with php-fpm and spawn-fcgi to see if the value differs?
