Davis, Jared Scott wrote:
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
I am using PHP on SuSE and connecting to Oracle databases fine via
unixODBC and installing the unixODBC drivers from Oracle. Have you
tried that route?
--
--Moby
They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. -- Benjamin Franklin
First they came for the Jews and I did not speak out because I was not a Jew.
Then they came for the Communists and I did not speak out because I was not a Communist.
Then they came for the trade unionists and I did not speak out because I was not a trade unionist.
Then they came for me and there was no one left to speak out for me. -- Pastor Martin Niemöller
--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
