Hi Moby, thanks for your reply. How does the unixODBC driver work? Is it a package to install? Do I have to reconfigure PHP at all? Thanks, Jared Davis Internet Administrator Residential Life University of Missouri-Columbia 100 Pershing Hall (573) 884-3616 -----Original Message----- From: redhat-list-bounces@xxxxxxxxxx [mailto:redhat-list-bounces@xxxxxxxxxx] On Behalf Of Moby Sent: Tuesday, August 15, 2006 4:08 PM To: General Red Hat Linux discussion list Subject: Re: Help with Oracle client support in PHP 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 -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
