Help with Oracle client support in PHP

[Davis, Jared Scott]

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 at redhat.com [mailto:redhat-list-bounces at redhat.com] 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 at redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list