Kompilace PHP s oraclem

[Michael Mraka]

Radovan Raszka wrote:
% tak jsem prave zjistil, ze taky potrebuju poradit - klient Oracle je nainstalovany, PHP zkompilovane (--with-oci8=/home/oracle/OraHome1), ale Apache pri spousteni drzkuje:
% Cannot load ....libphp4.so into server: libclntsh.so.8.0: cannot load shared object file: No such file or directory
% Zjevne se libclntsh.so.8.0 hleda jinde, nez ve skutecnosti je (v /home/oracle/OraHome1/lib). 
% Promenna ORACLE_HOME=/home/oracle/OraHome1, ale podle dokumentace jich ma byt nastaveno vic (ORACLE_SID, LD_PRELOAD, LD_LIBRARY_PATH, NLS_LANG, ORA_NLS33). Potiz je v tom, ze vubec netusim jak by mely byt nastavene, nehlede k tomu, ze netusim jak je nastavit uzivateli Nobody, pod kterym apache bezi.
% Poradi nekdo?

Pred startem apache je dobre nastavit (napr. do /etc/rc.d/init.d/httpd):

export ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/8.0.5
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

plus  pripadne
export NLS_LANG='CZECH_CZECH REPUBLIC.EE8ISO8859P2'
export NLS_NUMERIC_CHARACTERS='. '
export NLS_DATE_FORMAT='DD.MM.YYYY'



ORACLE_SID pripadne TWO_TASK neni potreba nastavovat pokud to uvadite pri
spojeni do databaze explicitne.


--mm                                                            Michael Mráka