Php, Oracle on Mac, with strange behaviour

am 13.03.2009 08:48:00 von Mark Halling-Brown

Dear List,

I have a puzzler, which I can't seem to fix.
To summarise, I have installed PHP, apache from source and the oracle
client (details below). I then construct a simple PHP script to
connect to my oracle database.
When I run the script from the command line, it works perfectly, and
returns rows from the database.

bash$ php oracle.php
Using : /opt/oracle/instanceclient, ORACLE_HOME=/opt/oracle/
instanceclient
Successfully connected to Oracle.

Buuuut, when I try to view this through a browser, it returns this
error:

Using : /opt/oracle/instanceclient, ORACLE_HOME=/opt/oracle/
instanceclient
Warning: ocilogon() [function.ocilogon]: 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/oracle.php on line 25
Oracle Connect Error

Here are the details of my installation and a few things I have tried:

Apache:
Installed apache (httpd-2.2.11) with the following configuration: --
prefix=/usr/local/apache --enable-module=so
No Errors

PHP
Installed PHP (php-5.2.9) with the following configuration:
--with-apxs2 -enable-cli --with-mysql=/usr/local/mysql/ --exec-
prefix=/usr --localstatedir=/var --libexecdir=/System/Library/Apache
/Modules --enable-shared=max --with-gd=/usr/local --with-zlib --
with-oci8=instantclient,/opt/oracle/instanceclient -enable-layout
=Darwin -enable-mods-shared=all --with-apxs2=/usr/local/apache2/bin/
apxs --with-config-file-path=/usr/local/apache2/conf --enable-si
gchild
No errors

Oracle Client
Installed Basic + all others in /opt/oracle/instanceclient
No errors

Oracle (Version 11g) is installed on a different server

I will paste the PHP script I am using at the bottom of the mail.
Now, as I said, it is working fine through the command line, so
everything is setup fine, so I figure it must be a permissions problem.
Hence, I chmod -R 755 $ORACLE_HOME and have tried running apache as
lots of different users, but to no avail

Thanks in advance
Mark

##### PHP SCRIPT #####
putenv("ORACLE_SID=orcl");
putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");
$username = "#####";### I have hidden this for security
$passwd = "#####"; ### I have hidden this for security
echo("Using : ". getenv("LD_LIBRARY_PATH"));
echo ", ORACLE_HOME=".getenv("ORACLE_HOME");
$db="(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(HOST=########)(PORT=1521) ### I have hidden this for
security
)
(CONNECT_DATA=(SERVER=DEDICATED)(SID=orcl)
(SERVICE_NAME=orcl))
)";

if ($c = OCILogon($username,$passwd,$db)) {
echo "Successfully connected to Oracle.n";
$s = OCIParse($c, "select * from COMPOUNDS WHERE rownum=1");
OCIExecute($s, OCI_DEFAULT);
print '

421.4983 td>

421.4983

C23 H27 N5 O3

';
while ($row = oci_fetch_array($s, OCI_RETURN_NULLS)) {
print '';
foreach ($row as $item) {
print '';
}
print '';
}
OCILogoff($c);
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text]. " ".
$err[message];
}
echo("
\n");

##### END #####
_____________________________

Mark Halling-Brown
Higher Scientific Officer,
Computational Biology & Chemogenomics, Cancer Therapeutics,
The Institute of Cancer Research
15 Cotswold Road
Belmont, Surrey SM2 5NG, UK
Tel: (+44)-20-8722-4300 (ext: 4659)
Email: mhallingbrown@icr.ac.uk
Web: http://www.markyhb.co.uk

"A cynic is what an idealist calls a realist"

The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer and network.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 15.03.2009 22:41:35 von dmagick

> Warning: ocilogon() [function.ocilogon]: 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/oracle.php on line 25
> Oracle Connect Error

> putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");

I'd guess you probably need this in apache's start up script, not in php
(where that is on a mac setup I have no idea).

You could also try it in your virtual host:

http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv

SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 02:26:50 von Christopher Jones

Chris wrote:
>> Warning: ocilogon() [function.ocilogon]: 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/oracle.php on line 25
>> Oracle Connect Error
>
>
>
>> putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");
>
> I'd guess you probably need this in apache's start up script, not in php
> (where that is on a mac setup I have no idea).
>
> You could also try it in your virtual host:
>
> http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv
>
> SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
>

I agree that using putenv() for Environment variables in scripts is bad.
On Mac, I think you need DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH.
See http://www.oracle.com/technology/pub/articles/bibbs-php-leop ard.html

Chris

--
Email: christopher.jones@oracle.com Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/UGPOM

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 08:51:12 von Mark Halling-Brown

Thanks for your replies.
In my desperation, I declared those environment variables in as many
places as I could think of. The script (Although I know I shouldnt),
php.ini and also the apache httpd.conf file:

SetEnv ORACLE_HOME /opt/oracle/instanceclient
SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient
SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
SetEnv ORACLE_BASE /opt/oracle/instanceclient

But given that it works on the command line, but not through the
browser, I think that the environment variables must be set correctly.

Cheers
Mark

On 16 Mar 2009, at 1:26 AM, Christopher Jones wrote:

>
>
> Chris wrote:
>>> Warning: ocilogon() [function.ocilogon]: 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/oracle.php
>>> on line 25 Oracle Connect Error
>>
>>> putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");
>> I'd guess you probably need this in apache's start up script, not
>> in php (where that is on a mac setup I have no idea).
>> You could also try it in your virtual host:
>> http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv
>> SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
>
> I agree that using putenv() for Environment variables in scripts is
> bad.
> On Mac, I think you need DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH.
> See http://www.oracle.com/technology/pub/articles/bibbs-php-leop ard.html
>
> Chris
>
> --
> Email: christopher.jones@oracle.com Tel: +1 650 506 8630
> Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/UGPOM

_____________________________

Mark Halling-Brown
Higher Scientific Officer,
Computational Biology & Chemogenomics, Cancer Therapeutics,
The Institute of Cancer Research
15 Cotswold Road
Belmont, Surrey SM2 5NG, UK
Tel: (+44)-20-8722-4300 (ext: 4659)
Email: mhallingbrown@icr.ac.uk
Web: http://www.markyhb.co.uk

"A cynic is what an idealist calls a realist"

The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer and network.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 09:23:21 von dmagick

On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown
wrote:
> Thanks for your replies.
> In my desperation, I declared those environment variables in as many places
> as I could think of. The script (Although I know I shouldnt), php.ini and
> also the apache httpd.conf file:
>
> SetEnv ORACLE_HOME /opt/oracle/instanceclient
> SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient
> SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
> SetEnv ORACLE_BASE /opt/oracle/instanceclient
>
> But given that it works on the command line, but not through the browser, I
> think that the environment variables must be set correctly.

Did you restart apache after doing this?

The env variables are set correctly for your user, but not apache's
(which is the problem).

Does the mac have an /etc/environment file? That should cover all users.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 09:37:02 von Mark Halling-Brown

--Apple-Mail-158--960098727
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

>
> Did you restart apache after doing this?

Yes, many times

>
> The env variables are set correctly for your user, but not apache's
> (which is the problem).

Indeed, I have removed the putenv declarations in the php script and
inserted this:
echo("Using LD_LIBRARY_PATH: ". getenv("LD_LIBRARY_PATH"));
echo ", ORACLE_HOME=".getenv("ORACLE_HOME");
echo(", DYLD_LIBRARY_PATH: ". getenv("DYLD_LIBRARY_PATH"));

And it prints to the screen (browser) correctly:
Using LD_LIBRARY_PATH: /opt/oracle/instanceclient, ORACLE_HOME=/opt/
oracle/instanceclient, DYLD_LIBRARY_PATH: /opt/oracle/instanceclient

For completeness, I have also put the variables is /etc/profile, /etc/
bash_profile etc

So it seems that the variables are set up for sure (unless this is
just for php, but I do have these variables in the apache httpd.conf)

This is a puzzler
Cheers
Mark

>
>
> Does the mac have an /etc/environment file? That should cover all
> users.
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/

_____________________________

Mark Halling-Brown
Higher Scientific Officer,
Computational Biology & Chemogenomics, Cancer Therapeutics,
The Institute of Cancer Research
15 Cotswold Road
Belmont, Surrey SM2 5NG, UK
Tel: (+44)-20-8722-4300 (ext: 4659)
Email: mhallingbrown@icr.ac.uk
Web: http://www.markyhb.co.uk

"A cynic is what an idealist calls a realist"

The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer and network.
--Apple-Mail-158--960098727--

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 11:27:53 von Grant Croker

On/El 16/03/09 09:23, chris smith wrote/escribió:
> On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown
> wrote:
>
>> Thanks for your replies.
>> In my desperation, I declared those environment variables in as many places
>> as I could think of. The script (Although I know I shouldnt), php.ini and
>> also the apache httpd.conf file:
>>
>> SetEnv ORACLE_HOME /opt/oracle/instanceclient
>> SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient
>> SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
>> SetEnv ORACLE_BASE /opt/oracle/instanceclient
>>
>> But given that it works on the command line, but not through the browser, I
>> think that the environment variables must be set correctly.
>>
>
> Did you restart apache after doing this?
>
> The env variables are set correctly for your user, but not apache's
> (which is the problem).
>
>
> Does the mac have an /etc/environment file? That should cover all users.

Unfortunately not although with the stock/supplied Apache web server
there is a plist file you can edit to add environment settings. Edit
|/System/Library/LaunchDaemons/org.apache.httpd.plist, adding the
relevant environment variable key/value information:|

"http://www.apple.com/DTDs/PropertyList-1.0.dtd">

EnvironmentVariables

DYLD_LIBRARY_PATH
path goes here
ORACLE_HOME
path goes here
ORACLE_BASE
path goes here

Label
org.apache.httpd
.
.
.

Then you use PassEnv in Apache to pass these values through to PHP. The
SetEnv directive in Apache is not the same as "setenv" or "export" in
csh/bash/etc. Apache maintains its own symbol table for environment
variables. Unless the OCI8 extension calls apache_getenv those
declarations will have no effect.

regards

grant

--
Grant Croker - Ingres PHP and Ruby maintainer
http://blogs.planetingres.org/grant
Generally, old media don't die. They just have to grow old gracefully.
Guess what, we still have stone masons. They haven't been the primary
purveyors of the written word for a while now of course, but they still
have a role because you wouldn't want a TV screen on your headstone.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 12:13:02 von Mark Halling-Brown

--Apple-Mail-159--950738599
Content-Type: text/plain;
charset=ISO-8859-1;
format=flowed;
delsp=yes
Content-Transfer-Encoding: quoted-printable

Hi=20Grant,

Thanks=20to=20your=20instructions,=20I=20am=20making=20a=20b it=20of=20prog=
ress.
I=20have=20entered=20the=20PassEnv=20commands=20into=20the=2 0https.conf.:
SetEnv=20DYLD_LIBRARY_PATH=20/opt/oracle/instanceclient
SetEnv=20LD_LIBRARY_PATH=20/opt/oracle/instanceclient
PassEnv=20DYLD_LIBRARY_PATH
PassEnv=20LD_LIBRARY_PATH

It=20now=20seems=20that=20this=20variable=20is=20passed=20th rough=20correc=
tly,=20but=20it=20is
not=20as=20I=20set=20it.=20Instead=20it=20states:
DYLD_LIBRARY_PATH:=20/usr/local/apache2/lib:

I=20restart=20apache=20as=20root=20user=20(sudo=20/usr/local /apache2/bin/a=
pachectl
restart)=20and=20it=20complains=20that:
[Mon=20Mar=2016=2011:08:53=202009]=20[warn]=20PassEnv=20vari able=20LD_LIBR=
ARY_PATH=20was
undefined

So=20I=20am=20guessing=20that=20root=20has=20not=20pic ked=20up=20any=
=20of=20the=20environment
variables=20that=20I=20have=20set=20in=20various=20places=20 around=20my=20=
system.=20I=20have
put=20DYLD_LIBRARY_PATH=20in=20/etc/bashrc=20~/.bash_profile etc,=20but=20I=
=20still
seems=20root=20doesn't=20know=20about=20them.

Have=20you=20any=20idea=20where=20I=20need=20to=20set=20thes e=20variables=20=
(Is=20there=20a=20root
home=20directory=20I=20can=20edit=20a=20.bash_profile=20or=2 0something?)

I=20did=20edit=20the=20/System/Library/LaunchDaemons/org.apa che.httpd.plis=
t
file,=20but=20the=20apache=20I=20am=20using=20was=20compiled =20from=20sour=
ce,=20so=20I=20fear=20it
wont=20work=20list=20that=20plist?

Thanks=20for=20all=20your=20help
Mark

On=2016=20Mar=202009,=20at=2010:27=20AM,=20Grant=20Croker=20 wrote:

>=20On/El=2016/03/09=2009:23,=20chris=20smith=20wrote/escrib i=F3:
>>=20On=20Mon,=20Mar=2016,=202009=20at=206:51=20PM,=20Mark=2 0Halling-Brown=

>>=20 wrote:
>>
>>>=20Thanks=20for=20your=20replies.
>>>=20In=20my=20desperation,=20I=20declared=20those=20enviro nment=20variab=
les=20in=20as
>>>=20many=20places
>>>=20as=20I=20could=20think=20of.=20The=20script=20(Althoug h=20I=20know=20=
I=20shouldnt),
>>>=20php.ini=20and
>>>=20also=20the=20apache=20httpd.conf=20file:
>>>
>>>=20SetEnv=20ORACLE_HOME=20/opt/oracle/instanceclient
>>>=20SetEnv=20DYLD_LIBRARY_PATH=20/opt/oracle/instanceclien t
>>>=20SetEnv=20LD_LIBRARY_PATH=20/opt/oracle/instanceclient
>>>=20SetEnv=20ORACLE_BASE=20/opt/oracle/instanceclient
>>>
>>>=20But=20given=20that=20it=20works=20on=20the=20command=2 0line,=20but=20=
not=20through=20the
>>>=20browser,=20I
>>>=20think=20that=20the=20environment=20variables=20must=20 be=20set=20cor=
rectly.
>>>
>>
>>=20Did=20you=20restart=20apache=20after=20doing=20this?
>>
>>=20The=20env=20variables=20are=20set=20correctly=20for=20y our=20user,=20=
but=20not=20apache's
>>=20(which=20is=20the=20problem).
>>
>> =20Does=20the=20mac=20have=20an=20/etc/environment=2 0file?=20That=20=
should=20cover=20all
>>=20users.
>
>=20Unfortunately=20not=20although=20with=20the=20stock/supp lied=20Apache=20=
web=20server
>=20there=20is=20a=20plist=20file=20you=20can=20edit=20to=20 add=20environm=
ent=20settings.=20Edit
>=20|/System/Library/LaunchDaemons/org.apache.httpd.plist,=2 0adding=20the=20=
=20
>=20relevant=20environment=20variable=20key/value=20informat ion:|
>
>=20
>=20 ://www.apple.com/DTDs/PropertyList-1.0.dtd=20
>=20">
>=20
>=20
>=20EnvironmentVariables
>=20
>=20DYLD_LIBRARY_PATH
>=20path=20goes=20here
>=20ORACLE_HOME
>=20path=20goes=20here
>=20ORACLE_BASE
>=20path=20goes=20here
>=20
>=20Label
>=20org.apache.httpd
> .
> .
> .
>=20
>=20
>
>
>=20Then=20you=20use=20PassEnv=20in=20Apache=20to=20pass=20t hese=20values=20=
through=20to=20PHP.
>=20The=20SetEnv=20directive=20in=20Apache=20is=20not=20the= 20same=20as=20=
"setenv"=20or
>=20"export"=20in=20csh/bash/etc.=20Apache=20maintains=20its =20own=20symbo=
l=20table=20for
>=20environment=20variables.=20Unless=20the=20OCI8=20extensi on=20calls=20a=
pache_getenv
>=20those=20declarations=20will=20have=20no=20effect.
>
>=20regards
>
>=20grant
>
>=20--=20
>=20Grant=20Croker=20-=20Ingres=20PHP=20and=20Ruby=20maintai ner
>=20http://blogs.planetingres.org/grant
>=20Generally,=20old=20media=20don't=20die.=20They=20just=20 have=20to=20gr=
ow=20old=20gracefully.
>=20Guess=20what,=20we=20still=20have=20stone=20masons.=20Th ey=20haven't=20=
been=20the=20primary
>=20purveyors=20of=20the=20written=20word=20for=20a=20while= 20now=20of=20c=
ourse,=20but=20they
>=20still
>=20have=20a=20role=20because=20you=20wouldn't=20want=20a=20 TV=20screen=20=
on=20your=20headstone.
>

_____________________________

Mark=20Halling-Brown
Higher=20Scientific=20Officer,
Computational=20Biology=20&=20Chemogenomics,=20Cancer=20Ther apeutics,
The=20Institute=20of=20Cancer=20Research
15=20Cotswold=20Road
Belmont,=20Surrey=20SM2=205NG,=20UK
Tel:=20(+44)-20-8722-4300=20(ext:=204659)
Email:=20mhallingbrown@icr.ac.uk
Web:=20http://www.markyhb.co.uk

"A=20cynic=20is=20what=20an=20idealist=20calls=20a=20realist "

The=20Institute=20of=20Cancer=20Research:=20Royal=20Cancer=2 0Hospital,=20a=
=20charitable=20Company=20Limited=20by=20Guarantee,=20Regist ered=20in=20En=
gland=20under=20Company=20No.=20534147=20with=20its=20Regist ered=20Office=20=
at=20123=20Old=20Brompton=20Road,=20London=20SW7=203RP.

This=20e-mail=20message=20is=20confidential=20and=20for=20us e=20by=20the=20=
addressee=20only. If=20the=20message=20is=20received=20 by=20anyone=20=
other=20than=20the=20addressee,=20please=20return=20the=20me ssage=20to=20t=
he=20sender=20by=20replying=20to=20it=20and=20then=20delete= 20the=20messag=
e=20from=20your=20computer=20and=20network.
--Apple-Mail-159--950738599--

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 12:53:13 von Grant Croker

--------------010104050308020808080306
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi Mark,

you are right /System/Library/LaunchDaemons/org.apache.httpd.plist will
not work in your case, it's for the Mac OS X supplied Apache. In your
case you can edit /usr/local/apache2/bin/apachectl adding the following:

DYLD_LIBRARY_PATH=/opt/oracle/instanceclient
LD_LIBRARY_PATH=/opt/oracle/instanceclient
ORACLE_BASE=/opt/oracle/instanceclient
ORACLE_HOME=/opt/oracle/instanceclient
export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME

(note: As Chris Jones mentioned LD_LIBRARY_PATH is not used on OS X,
however there is no harm in having it set)

Place the above some where near the top of apachectl, I cannot tell you
exactly since fink will not install and MacPorts does not build SQLite3.
Restart apache and you should see the correct values in getenv() or
phpinfo().

regards

grant

On/El 16/03/09 12:13, Mark Halling-Brown wrote/escribió:
> Hi Grant,
>
> Thanks to your instructions, I am making a bit of progress.
> I have entered the PassEnv commands into the https.conf.:
> SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient
> SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
> PassEnv DYLD_LIBRARY_PATH
> PassEnv LD_LIBRARY_PATH
>
> It now seems that this variable is passed through correctly, but it is
> not as I set it. Instead it states:
> DYLD_LIBRARY_PATH: /usr/local/apache2/lib:
>
> I restart apache as root user (sudo /usr/local/apache2/bin/apachectl
> restart) and it complains that:
> [Mon Mar 16 11:08:53 2009] [warn] PassEnv variable LD_LIBRARY_PATH was
> undefined
>
> So I am guessing that root has not picked up any of
> the environment variables that I have set in various places around my
> system. I have put DYLD_LIBRARY_PATH in /etc/bashrc
> ~/.bash_profileetc, but I still seems root doesn't know about them.
>
> Have you any idea where I need to set these variables (Is there a root
> home directory I can edit a bash_profile or something?)
>
> I did edit the /System/Library/LaunchDaemons/org.apache.httpd.plist
> file, but the apache I am using was compiled from source, so I fear it
> wont work list that plist?
>
> Thanks for all your help
> Mark
>

--
Grant Croker - Ingres PHP and Ruby maintainer
http://blogs.planetingres.org/grant
It was so much easier to blame it on Them. It was bleakly depressing to think that They were Us. If it was Them, then nothing was anyone's fault. If it was us, what did that make Me? After all, I'm one of Us. I must be. I've certainly never thought of myself as one of Them. No one ever thinks of themselves as one of Them. We're always one of Us. It's Them that do the bad things.
-- Terry Pratchett, Jingo

--------------010104050308020808080306--

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 13:03:49 von Mark Halling-Brown

Grant,=20thank=20you=20very=20much.=20You=20are=20a=20life=2 0saver.=20This=
=20worked=20perfectly.

Thanks=20again
Mark

On=2016=20Mar=202009,=20at=2011:53=20AM,=20Grant=20Croker=20 wrote:

>=20Hi=20Mark,
>
>=20you=20are=20right=20/System/Library/LaunchDaemons/org.ap ache.httpd.pli=
st
>=20will=20not=20work=20in=20your=20case,=20it's=20for=20the =20Mac=20OS=20=
X=20supplied=20Apache.
>=20In=20your=20case=20you=20can=20edit=20/usr/local/apache2 /bin/apachectl=
=20adding
>=20the=20following:
>
>=20DYLD_LIBRARY_PATH=3D/opt/oracle/instanceclient
>=20LD_LIBRARY_PATH=3D/opt/oracle/instanceclient
>=20ORACLE_BASE=3D/opt/oracle/instanceclient
>=20ORACLE_HOME=3D/opt/oracle/instanceclient
>=20export=20DYLD_LIBRARY_PATH=20LD_LIBRARY_PATH=20ORACLE_BA SE=20ORACLE_HO=
ME
>
>=20(note:=20As=20Chris=20Jones=20mentioned=20LD_LIBRARY_PAT H=20is=20not=20=
used=20on=20OS=20X,
>=20however=20there=20is=20no=20harm=20in=20having=20it=20se t)
>
>=20Place=20the=20above=20some=20where=20near=20the=20top=20 of=20apachectl=
,=20I=20cannot=20tell
>=20you=20exactly=20since=20fink=20will=20not=20install=20an d=20MacPorts=20=
does=20not=20build
>=20SQLite3.=20Restart=20apache=20and=20you=20should=20see=2 0the=20correct=
=20values=20in
>=20getenv()=20or=20phpinfo().
>
>=20regards
>
>=20grant
>
>
>=20On/El=2016/03/09=2012:13,=20Mark=20Halling-Brown=20wrote /escribi=F3:
>>=20Hi=20Grant,
>>
>>=20Thanks=20to=20your=20instructions,=20I=20am=20making=20 a=20bit=20of=20=
progress.
>>=20I=20have=20entered=20the=20PassEnv=20commands=20into=20 the=20https.co=
nf.:
>>=20SetEnv=20DYLD_LIBRARY_PATH=20/opt/oracle/instanceclient
>>=20SetEnv=20LD_LIBRARY_PATH=20/opt/oracle/instanceclient
>>=20PassEnv=20DYLD_LIBRARY_PATH
>>=20PassEnv=20LD_LIBRARY_PATH
>>
>>=20It=20now=20seems=20that=20this=20variable=20is=20passed =20through=20c=
orrectly,=20but=20it
>>=20is=20not=20as=20I=20set=20it.=20Instead=20it=20states:
>>=20DYLD_LIBRARY_PATH:=20/usr/local/apache2/lib:
>>
>>=20I=20restart=20apache=20as=20root=20user=20(sudo=20/usr/ local/apache2/=
bin/=20
>>=20apachectl=20restart)=20and=20it=20complains=20that:
>>=20[Mon=20Mar=2016=2011:08:53=202009]=20[warn]=20PassEnv=2 0variable=20LD=
_LIBRARY_PATH
>>=20was=20undefined
>>
>>=20So=20I=20am=20guessing=20that=20root=20has=20not=20pick ed=20up=20any=20=
of=20the=20environment
>>=20variables=20that=20I=20have=20set=20in=20various=20plac es=20around=20=
my=20system.=20I
>>=20have=20put=20DYLD_LIBRARY_PATH=20in=20/etc/bashrc=20~/. bash_profileet=
c,=20but=20I
>>=20still=20seems=20root=20doesn't=20know=20about=20them.
>>
>>=20Have=20you=20any=20idea=20where=20I=20need=20to=20set=2 0these=20varia=
bles=20(Is=20there=20a
>>=20root=20home=20directory=20I=20can=20edit=20a=20bash_pro file=20or=20so=
mething?)
>>
>>=20I=20did=20edit=20the=20/System/Library/LaunchDaemons/or g.apache.httpd=
..plist
>>=20file,=20but=20the=20apache=20I=20am=20using=20was=20com piled=20from=20=
source,=20so=20I=20fear
>>=20it=20wont=20work=20list=20that=20plist?
>>
>>=20Thanks=20for=20all=20your=20help
>>=20Mark
>>
>
>
>=20--=20
>=20Grant=20Croker=20-=20Ingres=20PHP=20and=20Ruby=20maintai ner
>=20http://blogs.planetingres.org/grant
>=20It=20was=20so=20much=20easier=20to=20blame=20it=20on=20T hem.=20It=20wa=
s=20bleakly=20depressing
>=20to=20think=20that=20They=20were=20Us.=20If=20it=20was=20 Them,=20then=20=
nothing=20was
>=20anyone's=20fault.=20If=20it=20was=20us,=20what=20did=20t hat=20make=20M=
e?=20After=20all,=20I'm
>=20one=20of=20Us.=20I=20must=20be.=20I've=20certainly=20nev er=20thought=20=
of=20myself=20as=20one
>=20of=20Them.=20No=20one=20ever=20thinks=20of=20themselves= 20as=20one=20o=
f=20Them.=20We're
>=20always=20one=20of=20Us.=20It's=20Them=20that=20do=20the= 20bad=20things=
..
> --=20Terry=20Pratchett,=20Jingo
>

_____________________________

Mark=20Halling-Brown
Higher=20Scientific=20Officer,
Computational=20Biology=20&=20Chemogenomics,=20Cancer=20Ther apeutics,
The=20Institute=20of=20Cancer=20Research
15=20Cotswold=20Road
Belmont,=20Surrey=20SM2=205NG,=20UK
Tel:=20(+44)-20-8722-4300=20(ext:=204659)
Email:=20mhallingbrown@icr.ac.uk
Web:=20http://www.markyhb.co.uk

"A=20cynic=20is=20what=20an=20idealist=20calls=20a=20realist "

The=20Institute=20of=20Cancer=20Research:=20Royal=20Cancer=2 0Hospital,=20a=
=20charitable=20Company=20Limited=20by=20Guarantee,=20Regist ered=20in=20En=
gland=20under=20Company=20No.=20534147=20with=20its=20Regist ered=20Office=20=
at=20123=20Old=20Brompton=20Road,=20London=20SW7=203RP.

This=20e-mail=20message=20is=20confidential=20and=20for=20us e=20by=20the=20=
addressee=20only. If=20the=20message=20is=20received=20 by=20anyone=20=
other=20than=20the=20addressee,=20please=20return=20the=20me ssage=20to=20t=
he=20sender=20by=20replying=20to=20it=20and=20then=20delete= 20the=20messag=
e=20from=20your=20computer=20and=20network.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 16.03.2009 13:15:44 von Grant Croker

On/El 16/03/09 13:03, Mark Halling-Brown wrote/escribió:
> Grant, thank you very much. You are a life saver. This worked perfectly.
>
> Thanks again
> Mark
>
No problem,

g

--
Grant Croker - Ingres PHP and Ruby maintainer
http://blogs.planetingres.org/grant
It was so much easier to blame it on Them. It was bleakly depressing to think that They were Us. If it was Them, then nothing was anyone's fault. If it was us, what did that make Me? After all, I'm one of Us. I must be. I've certainly never thought of myself as one of Them. No one ever thinks of themselves as one of Them. We're always one of Us. It's Them that do the bad things.
-- Terry Pratchett, Jingo

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Php, Oracle on Mac, with strange behaviour

am 17.03.2009 00:10:00 von Christopher Jones

Grant Croker wrote:
> DYLD_LIBRARY_PATH=/opt/oracle/instanceclient
> LD_LIBRARY_PATH=/opt/oracle/instanceclient
> ORACLE_BASE=/opt/oracle/instanceclient
> ORACLE_HOME=/opt/oracle/instanceclient
> export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME
>
> (note: As Chris Jones mentioned LD_LIBRARY_PATH is not used on OS X,
> however there is no harm in having it set)

Thanks for your help getting this resolved.

FWIW, I just merged a change to the originally reported "Warning:
ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed." message.
On Mac OS X this now mentions DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH:
http://cvs.php.net/viewvc.cgi/pecl/oci8/oci8.c?r1=1.269.2.16 .2.38.2.31&r2=1.269.2.16.2.38.2.32

This fix is incorporated into OCI8 1.3.5 downloadable from
http://pecl.php.net/package/oci8 It will be available with PHP 5.3
(whenever that comes out). Users of older versions of PHP including
PHP 5.2 are encouraged to upgrade OCI8 using PECL.

Chris

--
Email: christopher.jones@oracle.com Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/UGPOM

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

'.($item?
htmlentities($item):' ').'