Help with Oracle client support in PHP

Davis, Jared Scott DavisJar at missouri.edu
Wed Aug 16 13:49:57 UTC 2006


Anyone else have any thoughts/suggestions?

Thanks,
 
Jared Davis
Internet Administrator
Residential Life
University of Missouri-Columbia
100 Pershing Hall
(573) 884-3616


-----Original Message-----
From: redhat-list-bounces at redhat.com [mailto:redhat-list-bounces at redhat.com] On Behalf Of Davis, Jared Scott
Sent: Tuesday, August 15, 2006 3:56 PM
To: redhat-list at redhat.com
Subject: Help with Oracle client support in PHP

I’ve been trying to get this to work for awhile, so please bear with me (this is going to be long :).  I need Oracle client support for my PHP installation; the problem is PHP was of course installed as an RPM.  Our server is RHEL4 and I have the following relevant packages installed:

 

httpd-2.0.52-22.ent

php-4.3.9-3.15

php-devel-4.3.9-3.15

oracle-instantclient-basic-10.2.0.1-1

oracle-instantclient-devel-10.2.0.1-1

 

One method I was given was to rebuild the PHP source RPM to include Oracle support, which would generate a php-oci8 RPM that could then install.

> up2date --get --download --src php
> rpm -Uvh /var/spool/up2date/php-4.3.9-3.12.src.rpm
> cd /usr/src/redhat/SPECS
> rpmbuild -bb --clean --define with-oci8=1 php.spec
 
I could never get this method to work (no php-oci8 RPM was ever generated), even with trying different options including: oracle=1, with-oci8=1, with_oci8=1.  No luck.
 
Even if I get this method to work, the problem is that I’ll have to rebuild and update the php-oci8 RPM every time I update PHP, which is a hassle.
 
Another method I was given was the following:
> Take a working Oracle installation CD of the standard client, install it
> Edit /etc/ld.so.conf.d/oracle.conf and add the following line /home/giulix/Oracle/10.2.0.1/client/lib
> Define ORACLE_HOME and all needed Oracle environment variables (TNS_ADMIN, etc.)
> Install php, php-pear and php-devel (for phpize)
> Download & install oci8-1.2.1.tgz, cd to it and run phpize. Then compile with
> ./configure --with-oci8=shared,$ORACLE_HOME
> make
> su
> make install
> Edit /etc/php.ini and add the following line to the Dynamic Extensions section: extension=oci8.so
 
I haven’t actually tried this, but I don’t know what phpize is or how to use it, and where do I get this oci8 file?  Will this work?
 

I’m fairly new to Linux system administration, and this is a production machine, so I was afraid to try to recompile PHP from source because I wasn’t sure about RPM compatibility issues (Apache is an RPM, etc.)

 

There has to be an easier way…Someone help!

 

Thanks,

 

Jared Davis

 





More information about the redhat-list mailing list