Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread 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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread chris smith
On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown mhallingbr...@icr.ac.uk 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:

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
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: .

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread 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 mhallingbr...@icr.ac.uk 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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Grant Croker
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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
Grant, thank you very much. You are a life saver. This worked perfectly. Thanks again Mark On 16 Mar 2009, at 11:53 AM, Grant Croker wrote: 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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread 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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-15 Thread Chris
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

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-15 Thread 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