Re: what the php guys need to do
| From: | Fred Silsbee | Date: | Wed, 19 Nov 2008 00:27:22 +0000 |
| Subject: | Re: what the php guys need to do | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45653@lists.php.net to get a copy of this message | ||
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 L1: create_spool: (0) at (/tmp/oci8/oci8.c:2686)
Oracle Connect Error
using this and 10000 other combinations:
the OCI8 section of php.ini is:
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
--- On Tue, 11/18/08, Christopher Jones <christopher.jones@oracle.com> wrote:
> From: Christopher Jones <christopher.jones@oracle.com>
> Subject: Re: [PHP-DB] what the php guys need to do
> To: fredsilsbee@yahoo.com, "PHP DB" <php-db@lists.php.net>
> Date: Tuesday, November 18, 2008, 11:46 PM
> I'm CCing php-db again.
>
> Fred Silsbee wrote:
> > This worked:
> >> sqlplus hr/hr@LMKIIIGD
>
> > 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:
> sqlplus hr/hrpwd@LMKIIIGDNSID
> then use
> $c = oci_connect("hr", "hrpwd",
> "LMKIIIGDNSID");
>
> Since you have a different password and SID, your code
> would be:
>
> $c = oci_connect("hr", "hr",
> "LMKIIIGD");
>
> This assume Apache (or the PHP command line) has the same
> environment
> as SQL*Plus - your post didn't mention whether it does
> or not.
>
> Also, running
>
> <?php
> phpinfo();
> ?>
>
> will show you where your php.ini file is. Edit php.ini and
> set
> display_errors=On for purposes of debugging (don't
> leave it on in
> production applications)
>
> Chris
>
> -- Email: christopher.jones@oracle.com Tel: +1 650 506
> 8630
> Twitter: http://twitter.com/ghrd Free PHP Book:
> http://tinyurl.com/f8jad