[rhn-users] Mod_jk and PHP+Oracle

[Bacher, William J]

I've got a method that will get you oci8 installed. Probably not the
most elegant, but it has worked for me (I've since blown away that
install, so I can't verify anything):

From Oracle, you'll need to get the oracle-instantclient rpms. I grabbed
all of them, just to be safe:
   oracle-instantclient-basic-10.2.0.3-1.i386.rpm
   oracle-instantclient-devel-10.2.0.3-1.i386.rpm
   oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
   oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

I installed these using rpm (rpm -i *.rpm)

then used yum to install the other packages

   yum install php-dba php-devel php-pear

using pecl (part of pear), I installed oci8

   pecl install oci8

You want to tell it you're using instantclient,and the location of the
libraries (/usr/lib/oracle/10.2.0.3/client/lib/ for my install)

You may need the php source RPM (php-5.1.6-7.el5.src.rpm for my install)
for this - my notes are a bit fuzzy there. 

next you'll need to create /etc/php.d/oci8.ini
    ; Enable oci8 extension module
    extension=oci8.so

then my notes indicate I had to make the libraries executable, not sure
about that now

    chmod +x /usr/lib/oracle/10.2.0.3/client/lib/*

I was trying to get it to work with SElinux enabled. Oracle Instant
Client needs the stack executable, something SELinux doesn't like. These
commands should make SELinux happy:

restorecon -v /usr/lib/php/modules/oci8.so
restorecon -v /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
chcon -t textrel_shlib_t /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
semodule -i myhttp.pp
chcon -t textrel_shlib_t /usr/lib/oracle/10.2.0.3/client/lib/*
setsebool -P httpd_disable_trans=1
setsebool -P allow_execheap=1



This was a do it once - prove it can work sort of thing. It worked, but
I won't swear that it's perfect.


Bill Bacher

On Wed, 2007-07-25 at 18:05 -0300, Carlos Bochnia wrote:
> Dear All 
> 
>    I'm installing a new Red Hat Enterprise 5 and have two problems. 
> 
>    I'm using http and tomcat but I can't find the mod_jk in any channel.
> 
>    The other problem is that I need to use php with oracle (oci) and my
> doubt
> is if I can do that only compiling php or there is another way.
> 
>    Thank's for any help.
> 
> 
> With kind regards
> 
> 
> Carlos Eduardo Bochnia
> IT Manager
> Curitiba - Pr
> Brasil
> 
> 
> _______________________________________________
> rhn-users mailing list
> rhn-users at redhat.com
> https://www.redhat.com/mailman/listinfo/rhn-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2149 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/rhn-users/attachments/20070725/6c1dd1c9/attachment.bin>