Help with Oracle client support in PHP
Davis, Jared Scott
DavisJar at missouri.edu
Tue Aug 15 20:55:48 UTC 2006
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