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      HMMMM!







--- 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: [email protected]
> > > 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/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