Re: [PHP-DB] 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 H!
--- On Wed, 11/19/08, Jack van Zanen <[EMAIL PROTECTED]> wrote:
> From: Jack van Zanen <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache
> environment
> To: [EMAIL PROTECTED]
> Cc: "Christopher Jones" <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
>
> > 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
> <[EMAIL PROTECTED]>
> > wrote:
> >
> > > From: Christopher Jones
> <[EMAIL PROTECTED]>
> > > Subject: Re: [PHP-DB] what sets the ORACLE_HOME
> variable and sets
> > PHP/Apache environment
> > > To: [EMAIL PROTECTED]
> > > 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: [EMAIL PROTECTED] Tel: +1
> 650 506
> > > 8630
> > > Twitter: http://twitter.com/ghrdFree 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
Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
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: [EMAIL PROTECTED] Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] 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 <[EMAIL PROTECTED]> wrote:
> From: Christopher Jones <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache
> environment
> To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED] Tel: +1 650 506
> 8630
> Twitter: http://twitter.com/ghrdFree PHP Book:
> http://tinyurl.com/f8jad
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] 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 <[EMAIL PROTECTED]> wrote: > From: Christopher Jones <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache > environment > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] Tel: +1 650 506 > 8630 > Twitter: http://twitter.com/ghrdFree PHP Book: > http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
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: [EMAIL PROTECTED] Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
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: [PHP-DB] 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 <[EMAIL PROTECTED]> wrote: > From: Chris <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache > environment > To: [EMAIL PROTECTED] > 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: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
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: [PHP-DB] 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 <[EMAIL PROTECTED]> wrote: > From: Chris <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache > environment > To: [EMAIL PROTECTED] > Cc: php-db@lists.php.net > Date: Wednesday, November 19, 2008, 1:43 AM > Fred Silsbee wrote: > > oci8 > > OCI8 Supportenabled > > Version 1.3.4 > > Revision$Revision: 1.269.2.16.2.38.2.20 $ > > Active Persistent Connections 0 > > Active Connections 0 > > Compile-time ORACLE_HOMEno 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: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
Fred Silsbee wrote: oci8 OCI8 Supportenabled Version 1.3.4 Revision$Revision: 1.269.2.16.2.38.2.20 $ Active Persistent Connections 0 Active Connections 0 Compile-time ORACLE_HOMEno 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
[PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment
oci8 OCI8 Supportenabled Version 1.3.4 Revision$Revision: 1.269.2.16.2.38.2.20 $ Active Persistent Connections 0 Active Connections 0 Compile-time ORACLE_HOMEno value < Libraries Used no value Temporary Lob support enabled Collections support enabled Directive Local Value Master Value oci8.connection_class no valueno value oci8.default_prefetch 100 100 oci8.events Off Off oci8.max_persistent -1 -1 oci8.old_oci_close_semanticsOff 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
