-----Original Message----- From: Ryan Schmidt [mailto:ryandesign@macports.org] Sent: Sunday, December 09, 2007 11:41 AM To: John Korchok Cc: macports-users@lists.macosforge.org Subject: Re: Oracle support in PHP?
On Nov 21, 2007, at 21:01, John Korchok wrote:
I was recently required to start connecting to Oracle databases for some of the pages I serve. I was wondering if we ever might see an -oci8 variant that installs the Oracle library for php4/php5?
John and I have been communicating about this off-list, and I've just committed a new port "oracle-instantclient" and also added a variant "+oracle" to the php5 port. (Would naming the variant "+oci8" have been better?)
There's a ticket filed for this enhancement request:
http://trac.macports.org/projects/macports/ticket/13530
Check the ticket for information on fetch failures you might encounter and what to do about them.
I don't have an Oracle server to test with, so I'll be relying on John and anyone else who uses Oracle to send me feedback. Thanks.
Note that this is for PowerPC Macs only. Blame Oracle.
You may need to follow some of the setup instructions here; I'm not sure:
You should not, however, need to set LD_LIBRARY_PATH (or its Mac OS X equivalents DYLD_LIBRARY_PATH and DYLD_FALLBACK_LIBRARY_PATH). That should already be adequately taken care of by the oracle- instantclient port.
I had no errors or other problems installing the "oracle-instantclient" port or the "php5 +oracle" port. Thanks Ryan! I am assuming I still need to modify php.ini to point at oci8.so, but I can't find it (oci8.o is there). I did find the libraries under lib/oracle. http://www.php.net/oci8 is just baffling. It reads like a pile of potentially useful but untested information. Using the Instant Client (as they recommend) does not create an oracle user or group, as far as I can tell.