[PHP-DB] what the php guys need to do

2008-11-18 Thread Fred Silsbee
provide some detailed instructions for oc8/linux install that leave no gaps instructions that work for newbies I've never heard of : # LD_PRELOAD # NLS_LANG For example: You should install OCI8 by yourself. Here is how: 1) Do this as user oracle: cd /tmp; pecl bundle oci8. The output

Re: [PHP-DB] what the php guys need to do

2008-11-18 Thread Christopher Jones
Fred Silsbee wrote: provide some detailed instructions for oc8/linux install that leave no gaps instructions that work for newbies For newbies we recommend installing Zend Core for Oracle. Are you the same person as person who has been posting to the OTN forum, e.g. this post

Re: [PHP-DB] what the php guys need to do

2008-11-18 Thread Christopher Jones
I'm CCing the php-db list. Fred Silsbee wrote: install Zend?...never! I have Fedora 9 and 11g1 Enterprise I have Apache working and Oracle 11g1 installed and working! Zend installs both of these and could screw up my working system. Zend Core for Oracle will use your existing Apache. It

Re: [PHP-DB] what the php guys need to do

2008-11-18 Thread Christopher Jones
I'm CCing php-db again. Fred Silsbee wrote: This worked: sqlplus hr/[EMAIL PROTECTED] so I tried: (didn't work) if ($conn=oci_connect('hr', 'hr', '//localhost/LMKIIIGD')) Excuse me repeating the example PHP code I gave earlier for this SQL*Plus case: Or if you connect like:

Re: [PHP-DB] what the php guys need to do

2008-11-18 Thread Fred Silsbee
sorry I forgot last time to cc PHP-DB Fred Silsbee wrote: This worked on the command line: sqlplus hr/[EMAIL PROTECTED] so I tried: (it didn't work) if ($conn=oci_connect('hr', 'hr','//localhost/LMKIIIGD')) yes this suggestion is clear and I've tried dozens of combinations Since

Re: [PHP-DB] what the php guys need to do

2008-11-18 Thread Fred Silsbee
looking at the results of phpinfo, I have : /etc/php.ini with display_errors = On I get : 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

[PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Fred Silsbee
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

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Chris
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

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Fred Silsbee
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

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Chris
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

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Fred Silsbee
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

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Chris
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

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-18 Thread Christopher Jones
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