RES: [rhn-users] Mod_jk and PHP+Oracle

[Carlos Bochnia]

 Bacher,

   Your documentation works perfectly.

  Just two little things if someone try. I don't need the php source RPM and
the libraries was already executable. The rest, just follow and you will get
there.

  Thank a lot.

  Somebody can help me with mod_jk ?



-----Mensagem original-----
De: rhn-users-bounces at redhat.com [mailto:rhn-users-bounces at redhat.com] Em
nome de Bacher, William J
Enviada em: quarta-feira, 25 de julho de 2007 18:37
Para: Discussions about Red Hat Network (rhn.redhat.com)
Assunto: Re: [rhn-users] Mod_jk and PHP+Oracle

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