Oracle - Add path to Apache envvars

[jkorchok@…]

After installing the php5-oracle and oracle-instantclient ports on a number of machines, I have found by trial and error that these ports require the following line to be added to /opt/local/apache2/bin/envvars:

export DYLD_LIBRARY_PATH = "/opt/local/lib/oracle/:$DYLD_LIBRARY_PATH"

If this line is missing in envvars, you will see the following error in the Apache or PHP error log:

"PHP Warning: oci_connect: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that the DYLD_LIBRARY_PATH includes the directory with the Oracle Instant Client libraries in..."

Would it be possible to make the port installation add this line to envvars?

[ryandesign (Ryan Carsten Schmidt)]

No, the Apache envvars file is considered a configuration file, and MacPorts does not typically modify your configuration files for you.

Are you certain your ports are up to date? ("sudo port selfupdate" and "sudo port upgrade outdated") It was my understanding that with the current version of the port on OS X 10.5 and later it should no longer be necessary to do that, which is why on 10.5 and later the notes of the oracle-instantclient port currently read:

$ port notes oracle-instantclient
oracle-instantclient has the following notes:
  If you previously set DYLD_LIBRARY_PATH=/opt/local/lib/oracle in your environment, you can remove it; it is no longer needed with this version of oracle-instantclient.