[MacPorts] #39393: Oracle - Add path to Apache envvars

[MacPorts]

#39393: Oracle - Add path to Apache envvars
------------------------------------------------+--------------------------
  Reporter:  jkorchok@…                         |      Owner:  ryandesign@…
      Type:  enhancement                        |     Status:  new
  Priority:  Low                                |  Milestone:
 Component:  ports                              |    Version:  2.1.3
Resolution:                                     |   Keywords:
      Port:  php5-oracle, oracle-instantclient  |
------------------------------------------------+--------------------------
Changes (by ryandesign@…):

 * owner:  macports-tickets@… => ryandesign@…


Old description:

> 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?

New description:

 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?

--

Comment:

 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.
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/39393#comment:1>
MacPorts <http://www.macports.org/>
Ports system for OS X