what sets the ORACLE_HOME variable and sets PHP/Apache environment

oci8
OCI8 Support enabled
Version 1.3.4
Revision $Revision: 1.269.2.16.2.38.2.20 $
Active Persistent Connections 0
Active Connections 0
Compile-time ORACLE_HOME no value <<<<<<<<<<<<<<<<<<<<<
Libraries Used no value
Temporary Lob support enabled
Collections support enabled

Directive Local Value Master Value
oci8.connection_class no value no value
oci8.default_prefetch 100 100
oci8.events Off Off
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics Off Off
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20







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

Re: what sets the ORACLE_HOME variable and sets PHP/Apacheenvironment

Fred Silsbee wrote:
> oci8
> OCI8 Support enabled
> Version 1.3.4
> Revision $Revision: 1.269.2.16.2.38.2.20 $
> Active Persistent Connections 0
> Active Connections 0
> Compile-time ORACLE_HOME no value <<<<<<<<<<<<<<<<<<<<<

/etc/apache2/envvars

(or /etc/httpd/envvars depending on the o/s)

use is:

export ORACLE_HOME=/path/to/oracle/home

You'll need to do a full apache restart, a HUP won't make it read this file.

--
Postgresql & php tutorials
http://www.designmagick.com/


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

Re: what sets the ORACLE_HOME variable and sets PHP/Apache environment

there is a file /etc/httpd/conf/httpd.conf

I tried putting the ORACLE_HOME in this file but it failed


--- On Wed, 11/19/08, Chris wrote:

> From: Chris
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
> To: fredsilsbee@yahoo.com
> Cc: php-db@lists.php.net
> Date: Wednesday, November 19, 2008, 1:43 AM
> Fred Silsbee wrote:
> > oci8
> > OCI8 Support enabled
> > Version 1.3.4
> > Revision $Revision: 1.269.2.16.2.38.2.20 $
> > Active Persistent Connections 0
> > Active Connections 0
> > Compile-time ORACLE_HOME no value
> <<<<<<<<<<<<<<<<<<<<<
>
> /etc/apache2/envvars
>
> (or /etc/httpd/envvars depending on the o/s)
>
> use is:
>
> export ORACLE_HOME=/path/to/oracle/home
>
> You'll need to do a full apache restart, a HUP
> won't make it read this file.
>
> -- Postgresql & php tutorials
> http://www.designmagick.com/





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

Re: what sets the ORACLE_HOME variable and sets PHP/Apacheenvironment

Fred Silsbee wrote:
> there is a file /etc/httpd/conf/httpd.conf
>
> I tried putting the ORACLE_HOME in this file but it failed

How did you put it in?

Try this method

http://httpd.apache.org/docs/2.0/mod/mod_env.html#setenv

--
Postgresql & php tutorials
http://www.designmagick.com/


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

Re: what sets the ORACLE_HOME variable and sets PHP/Apache environment

didn't work...sorry
errors:
OCI8 DEBUG: OCINlsEnvironmentVariableGet at (/tmp/oci8/oci8.c:1819)
OCI8 DEBUG L1: Got NO cached connection at (/tmp/oci8/oci8.c:1864)
OCI8 DEBUG: OCIEnvNlsCreate at (/tmp/oci8/oci8.c:2768)
OCI8 DEBUG L1: create_spool: (0) at (/tmp/oci8/oci8.c:2686)
Oracle Connect Error

added:


SetEnv ORACLE_HOSTNAME localhost.localdomain
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


to /etc/httpd/conf/httpd.conf




--- On Wed, 11/19/08, Chris wrote:

> From: Chris
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
> To: fredsilsbee@yahoo.com
> Cc: php-db@lists.php.net
> Date: Wednesday, November 19, 2008, 2:41 AM
> Fred Silsbee wrote:
> > there is a file /etc/httpd/conf/httpd.conf
> >
> > I tried putting the ORACLE_HOME in this file but it
> failed
>
> How did you put it in?
>
> Try this method
>
> http://httpd.apache.org/docs/2.0/mod/mod_env.html#setenv
>
> -- Postgresql & php tutorials
> http://www.designmagick.com/





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

Re: what sets the ORACLE_HOME variable and sets PHP/Apacheenvironment

Fred Silsbee wrote:
> didn't work...sorry
> errors:
> OCI8 DEBUG: OCINlsEnvironmentVariableGet at (/tmp/oci8/oci8.c:1819)
> OCI8 DEBUG L1: Got NO cached connection at (/tmp/oci8/oci8.c:1864)
> OCI8 DEBUG: OCIEnvNlsCreate at (/tmp/oci8/oci8.c:2768)
> OCI8 DEBUG L1: create_spool: (0) at (/tmp/oci8/oci8.c:2686)
> Oracle Connect Error
>
> added:
>
>
> SetEnv ORACLE_HOSTNAME localhost.localdomain
> 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
>
>
> to /etc/httpd/conf/httpd.conf

Do these show up in phpinfo() (should be under environment variables) ?

--
Postgresql & php tutorials
http://www.designmagick.com/


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

Re: what sets the ORACLE_HOME variable and sets PHP/Apacheenvironment

Fred Silsbee wrote:
> there is a file /etc/httpd/conf/httpd.conf
>
> I tried putting the ORACLE_HOME in this file but it failed

What failed and how?

How was it set?

[phpinfo output of]
>>> Compile-time ORACLE_HOME no value

The lack of a value here is an artifact aka buglet of installing from
the PECL package. I'll add it to the todo list of issues to look at.

Chris

--
Email: christopher.jones@oracle.com Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/f8jad

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

Re: what sets the ORACLE_HOME variable and sets PHP/Apache environment

GREAT!!!!!!!!!! but how!

http://us.php.net/manual/en/oci8.setup.php


--- On Wed, 11/19/08, Christopher Jones wrote:

> From: Christopher Jones
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
> To: fredsilsbee@yahoo.com
> Cc: php-db@lists.php.net
> Date: Wednesday, November 19, 2008, 5:27 AM
> Fred Silsbee wrote:
> > there is a file /etc/httpd/conf/httpd.conf
> >
> > I tried putting the ORACLE_HOME in this file but it
> failed
>
> What failed and how?
>
> How was it set?
>
> [phpinfo output of]
> >>> Compile-time ORACLE_HOME no value
>
> The lack of a value here is an artifact aka buglet of
> installing from
> the PECL package. I'll add it to the todo list of
> issues to look at.
>
> Chris
>
> -- Email: christopher.jones@oracle.com Tel: +1 650 506
> 8630
> Twitter: http://twitter.com/ghrd Free PHP Book:
> http://tinyurl.com/f8jad





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

Re: what sets the ORACLE_HOME variable and sets PHP/Apache environment

here is where the error occurs:oci8.c
/* use NLS_LANG if no or invalid charset specified */
if (!charsetid) {
size_t rsize = 0;
sword result;
// here
PHP_OCI_CALL_RETURN(result, OCINlsEnvironmentVariableGet, (&charsetid_nls_lang, 0, OCI_NLS_CHARSET_ID, 0, &rsize));
if (result != OCI_SUCCESS) {
charsetid_nls_lang = 0;
}
smart_str_append_unsigned_ex(&hashed_details, charsetid_nls_lang, 0);
}

doesn't anybody know how this stuff works!

I connected to MySQL the very FIRST try! I didn't have to search their "C" code





--- On Wed, 11/19/08, Christopher Jones wrote:

> From: Christopher Jones
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
> To: fredsilsbee@yahoo.com
> Cc: php-db@lists.php.net
> Date: Wednesday, November 19, 2008, 5:27 AM
> Fred Silsbee wrote:
> > there is a file /etc/httpd/conf/httpd.conf
> >
> > I tried putting the ORACLE_HOME in this file but it
> failed
>
> What failed and how?
>
> How was it set?
>
> [phpinfo output of]
> >>> Compile-time ORACLE_HOME no value
>
> The lack of a value here is an artifact aka buglet of
> installing from
> the PECL package. I'll add it to the todo list of
> issues to look at.
>
> Chris
>
> -- Email: christopher.jones@oracle.com Tel: +1 650 506
> 8630
> Twitter: http://twitter.com/ghrd Free PHP Book:
> http://tinyurl.com/f8jad





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

Re: what sets the ORACLE_HOME variable and sets PHP/Apacheenvironment

Fred Silsbee wrote:
> GREAT!!!!!!!!!! but how!

How what?

> http://us.php.net/manual/en/oci8.setup.php

What about it?

>> [phpinfo output of]
>>>>> Compile-time ORACLE_HOME no value
>> The lack of a value here is an artifact aka buglet of
>> installing from
>> the PECL package. I'll add it to the todo list of
>> issues to look at.

To make this very clear: This particular part of the phpinfo() output
is a message string constructed at compile time and doesn't matter
that it isn't showing a value at run time.

As explained in other messages forums, look for ORACLE_HOME in the
"Enviroment" section of phpinfo(). If that isn't set, find out how to
set environment variables for the Apache on your OS.

Chris

--
Email: christopher.jones@oracle.com Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/f8jad

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

Re: what sets the ORACLE_HOME variable and sets PHP/Apache environment

there is no problem with my 11g1 system

I also have a number of similar "impossible" unix/solaris/Linux installs under my belt!

right now I am editing my /etc/httpd/conf/httpd.conf file
________________

from a php site: http://us.php.net/manual/en/oci8.setup.php
ORACLE_HOME
ORACLE_SID
LD_PRELOAD ???
LD_LIBRARY_PATH
NLS_LANG ???

I have these: (still didn't work!
SetEnv ORACLE_HOSTNAME localhost.localdomain
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:/lib:/usr/lib


http://bugs.php.net/bug.php?id=31476 HMMMM!







--- On Wed, 11/19/08, Jack van Zanen wrote:

> From: Jack van Zanen
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
> To: fredsilsbee@yahoo.com
> Cc: "Christopher Jones"
> Date: Wednesday, November 19, 2008, 9:04 PM
> Well,
>
>
> It is very dificult to troubleshoot these things without
> actually sitting
> behind the console. We may make assumptions that may not
> neccessarily be
> true.
>
> I am an Oracle DBA and I have installed Oracle on UNIX more
> times than I
> care to remember so I can assume that my Oracle Setups are
> correct, yours I
> do not know. I have on occassions in the past used oracle
> as a backend
> database for php apps and it was as simple as MySQL. Succes
> on first
> attempt.
> I now use Oracle, Php and Apache on windows and have been
> using this for
> several years now and this is a bit more straightforward.
>
>
> Jack
>
> 2008/11/20 Fred Silsbee
>
> > here is where the error occurs:oci8.c
> > /* use NLS_LANG if no or invalid charset
> specified */
> > if (!charsetid) {
> > size_t rsize = 0;
> > sword result;
> > // here
> > PHP_OCI_CALL_RETURN(result,
> OCINlsEnvironmentVariableGet,
> > (&charsetid_nls_lang, 0, OCI_NLS_CHARSET_ID, 0,
> &rsize));
> > if (result != OCI_SUCCESS) {
> > charsetid_nls_lang = 0;
> > }
> >
> smart_str_append_unsigned_ex(&hashed_details,
> > charsetid_nls_lang, 0);
> > }
> >
> > doesn't anybody know how this stuff works!
> >
> > I connected to MySQL the very FIRST try! I didn't
> have to search their "C"
> > code
> >
> >
> >
> >
> >
> > --- On Wed, 11/19/08, Christopher Jones
>
> > wrote:
> >
> > > From: Christopher Jones
>
> > > Subject: Re: [PHP-DB] what sets the ORACLE_HOME
> variable and sets
> > PHP/Apache environment
> > > To: fredsilsbee@yahoo.com
> > > Cc: php-db@lists.php.net
> > > Date: Wednesday, November 19, 2008, 5:27 AM
> > > Fred Silsbee wrote:
> > > > there is a file /etc/httpd/conf/httpd.conf
> > > >
> > > > I tried putting the ORACLE_HOME in this file
> but it
> > > failed
> > >
> > > What failed and how?
> > >
> > > How was it set?
> > >
> > > [phpinfo output of]
> > > >>> Compile-time ORACLE_HOME no value
> > >
> > > The lack of a value here is an artifact aka
> buglet of
> > > installing from
> > > the PECL package. I'll add it to the todo
> list of
> > > issues to look at.
> > >
> > > Chris
> > >
> > > -- Email: christopher.jones@oracle.com Tel: +1
> 650 506
> > > 8630
> > > Twitter: http://twitter.com/ghrd Free PHP
> Book:
> > > http://tinyurl.com/f8jad
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> J.A. van Zanen





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