Fedora 9-->10 ..now "oracle connect error"

Oracle Connect Error
just upgraded Fedora 9->10

using new php.ini file containing:

;;;;
; Note: packaged extension modules are now loaded via the .ini files
; found in the directory /etc/php.d; these are loaded by default.
;;;;

I tried entering a file oracle.ini containing:


; Enable mysql extension module
extension=oci8.so exists also in php.ini

...so files are where they ought to be

mysql works with php as before update









--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fedora 9-->10 ..now "oracle connect error"

Fred Silsbee wrote:
> Oracle Connect Error

What error? What Oracle client libraries do you have? Where
are they located

> just upgraded Fedora 9->10
>
> using new php.ini file containing:
>
> ;;;;
> ; Note: packaged extension modules are now loaded via the .ini files
> ; found in the directory /etc/php.d; these are loaded by default.
> ;;;;
>
> I tried entering a file oracle.ini containing:
>
>
> ; Enable mysql extension module
> extension=oci8.so exists also in php.ini
>
> ..so files are where they ought to be

Which is where?

What is extension_dir set to?

What is LD_LIBRARY_PATH set it in the "Environment" (not the "Apache
Environment") of phpinfo() output?

>
> mysql works with php as before update
>
>
>
>
>
>
>
>
>

--
Blog: http://blogs.oracle.com/opal
Twitter: http://twitter.com/ghrd

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fedora 9-->10 ..now "oracle connect error"

--- On Thu, 8/13/09, Fred Silsbee wrote:=0A=
=0A> From: Fred Silsbee =0A> Subject: Re: [PHP-DB] F=
edora 9-->10 ..now "oracle connect error"=0A> To: "Christopher Jones" stopher.jones@oracle.com>=0A> Date: Thursday, August 13, 2009, 11:36 PM=0A>=
after working for nearly 9 months, =0A> =0A> "oracle connect error"=0A> =
=0A> LMKIII (root) ~ [999]>lsa /etc|grep -i php=0A> drwxr-xr-x  =A02 ro=
ot=A0   =A0root=A0 =A0   =A04096=0A> 2009-08-13 04:46 php.d/=0A> -r=
w-r--r--  =A01 root=A0   =A0root=A0 =A0 =A0 45812=0A> 2009-08-13 12=
:32 php.ini=0A> -rw-r--r--  =A01 root=A0   =A0root=A0 =A0 =A0 45804=
=0A> 2009-04-17 02:44 php.ini.rpmnew=0A> -rw-r--r--  =A01 root=A0 =A0=
  root=A0 =A0 =A0 45533=0A> 2009-08-13 03:54 phpini.save=0A> =0A> copie=
d php.ini.rpmnew to php.ini=0A> =0A> made changes (new php.ini attached)=0A=
> =0A> =0A> > > Oracle Connect Error =0A> > =0A> > What error?=A0 What Orac=
le client libraries do you=0A> > have?=A0 Where=0A> > are they located=0A> =
> =0A> LMKIII (root) ~ [1000]>locate oci8.so=0A> /home/oracle/oci8/oci8-1.3=
...4/.libs/oci8.so=0A> /home/oracle/oci8/oci8-1.3.4/modules/oci8.so=0A> /home=
/oracle/oci8/oci8-1.3.5/.libs/oci8.so=0A> /home/oracle/oci8/oci8-1.3.5/modu=
les/oci8.so=0A> /usr/lib/php/modules/oci8.so=0A> =0A> > > just upgraded Fed=
ora 9->10=0A> > > =0A> > > using new php.ini file containing:=0A> > > =0A> =
> > ;;;;=0A> > > ; Note: packaged extension modules are now loaded=0A> via=
=0A> > the .ini files=0A> > > ; found in the directory /etc/php.d; these ar=
e=0A> loaded=0A> > by default.=0A> > > ;;;;=0A> > > =0A> > > I entered a fi=
le oracle.ini into /etc/php.d=0A> containing:=0A> =0A> ; Enable mysql exte=
nsion module=0A> extension=3Doci8.so=A0 =A0 =A0 =A0   > > =A0   =A0=
this line exists also in php.ini=0A> > > =0A> > > ..so files are where they=
ought to be=0A> > =0A> > Which is where?=0A> > =0A> > What is extension_di=
r set to?=0A> ; Directory in which the loadable extensions (modules)=0A> re=
side.=0A> extension_dir =3D "/usr/lib/php/modules"=0A> ;extension_dir =3D "=
/home/oracle/oci8/oci8-1.3.4/modules"=0A> =0A> > =0A> > What is LD_LIBRARY_=
PATH set it in the "Environment"=0A> (not=0A> > the "Apache=0A> > Environme=
nt") of phpinfo() output?=0A> LMKIII (root) /etc [1001]>echo $PATH=0A> /usr=
/lib/qt4/bin:/usr/lib/qt4:/usr/lib:/usr/lib/qt-3.3/bin:/usr/ kerberos/sbin:/=
usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/ bin:/sbin:/bin:=
/usr/sbin:/usr/bin:/root/bin:.=0A> =0A> in /etc/httpd/conf/httpd.conf=0A> =
=0A> SetEnv ORACLE_HOSTNAME localhost.localdomain=0A> SetEnv TNS_ADMIN=0A> =
/u01/app/oracle/product/11.1.0/db_1/network/admin=0A> SetEnv ORACLE_BASE /u=
01/app/oracle=0A> SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1=0A=
> SetEnv ORACLE_SID lmkiiiGDNSID=0A> SetEnv ORACLE_TERM xterm=0A> SetEnv LD=
_LIBRARY_PATH /u01/app/oracle/product/11.1.0/db_1/lib=0A> =0A> =0A> > =0A> =
> > =0A> > > mysql works with php as before update=0A> > > =0A> > > =0A> > =
> =0A> > > =0A> > > =0A> > > =0A> > >=A0 =A0     > > > =0A> > =0A> =
> -- Blog: http://blogs.oracle.com/opal=0A> > Twitter:=A0 http://twitter.co=
m/ghrd=0A> >=0A> =0A> =0A> =A0 =A0 =A0 =0A


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fedora 9-->10 ..now "oracle connect error"

Fred Silsbee wrote:
>> in /etc/httpd/conf/httpd.conf
>>
>> SetEnv ORACLE_HOSTNAME localhost.localdomain
>> SetEnv TNS_ADMIN
>> /u01/app/oracle/product/11.1.0/db_1/network/admin
>> SetEnv ORACLE_BASE /u01/app/oracle
>> SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
>> SetEnv ORACLE_SID lmkiiiGDNSID
>> SetEnv ORACLE_TERM xterm
>> SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/11.1.0/db_1/lib

From experience, using Apache's SetEnv directive is sometimes
insufficient to set the environment. See "Where do I set Oracle
environment variables?" in http://wiki.oracle.com/page/PHP+Oracle+FAQ

Also see page 105 onwards in
http://www.oracle.com/technology/tech/php/underground-php-or acle-manual.html

On RHEL and Oracle EL I put the environment variables in
/etc/sysconfig/httpd (as shown on page 108).

Chris


--
Blog: http://blogs.oracle.com/opal
Twitter: http://twitter.com/ghrd

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fedora 9-->10 ..now "oracle connect error"

since I copied httpd.conf.rpmnew into httpd.conf I had to set the list=
en port to 8080 since my ISP blocks port 80 now phpinfo.php works=
! now oracle php works! Thanks! soon I'll be switching Fedor=
a 10-->Fedora 11 and prob have to make the change again --=
- On Fri, 8/14/09, Christopher Jones wrote:=
> From: Christopher Jones =0A> Subject:=
Re: [PHP-DB] Fedora 9-->10 ..now "oracle connect error"=0A> To: "Fred Sils=
bee" =0A> Cc: php-db@lists.php.net=0A> Date: Friday,=
August 14, 2009, 12:05 AM=0A> =0A> Fred Silsbee wrote:=0A> >> in /etc/http=
d/conf/httpd.conf=0A> >>=0A> >> SetEnv ORACLE_HOSTNAME localhost.localdomai=
n=0A> >> SetEnv TNS_ADMIN=0A> >> /u01/app/oracle/product/11.1.0/db_1/networ=
k/admin=0A> >> SetEnv ORACLE_BASE /u01/app/oracle=0A> >> SetEnv ORACLE_HOME=
=0A> /u01/app/oracle/product/11.1.0/db_1=0A> >> SetEnv ORACLE_SID lmkiiiGDN=
SID=0A> >> SetEnv ORACLE_TERM xterm=0A> >> SetEnv LD_LIBRARY_PATH=0A> /u01/=
app/oracle/product/11.1.0/db_1/lib=0A> =0A> From experience, using Apache's=
SetEnv directive is=0A> sometimes=0A> insufficient to set the environment.=
=A0 See "Where do I=0A> set Oracle=0A> environment variables?" in http://wi=
ki.oracle.com/page/PHP+Oracle+FAQ=0A> =0A> Also see page 105 onwards in=0A>=
http://www.oracle.com/technology/tech/php/underground-php-or acle-manual.ht=
ml=0A> =0A> On RHEL and Oracle EL I put the environment variables in=0A> /e=
tc/sysconfig/httpd (as shown on page 108).=0A> =0A> Chris=0A> =0A> =0A> -- =
Blog: http://blogs.oracle.com/opal=0A> Twitter:=A0 http://twitter.com/ghrd=
=0A> =0A


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php