5.1.2 woes

I downloaded PHP-5.1.2 and tried it with an application I normally use.
Application connects to Oracle 10.2. Here is the result:

[Thu Jan 12 19:26:11 2006] [notice] Apache/2.0.54 (Unix) PHP/5.1.2
configured -- resuming normal operations [Thu Jan 12 19:26:20 2006]
[error] [client 127.0.0.1] PHP Warning: ocilogon() [<a
href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate() failed.
There is something wrong with your system - please check that ORACLE_HOME
is set and points to the right directory in
/usr/local/PHP/adodb/drivers/adodb-oci8.inc.php on line 228, referer:
http://localhost/dba/dba_helper.php

When I downgraded to 5.1.1 - it worked like a charm. Version 5.1.2 is
still a little bit rough around the edges, isn't it?

--
http://www.mgogala.com

re: 5.1.2 woes

Mladen Gogala wrote:[color=blue]
> I downloaded PHP-5.1.2 and tried it with an application I normally use.
> Application connects to Oracle 10.2. Here is the result:
>
> [Thu Jan 12 19:26:11 2006] [notice] Apache/2.0.54 (Unix) PHP/5.1.2
> configured -- resuming normal operations [Thu Jan 12 19:26:20 2006]
> [error] [client 127.0.0.1] PHP Warning: ocilogon() [<a
> href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate() failed.
> There is something wrong with your system - please check that ORACLE_HOME
> is set and points to the right directory in
> /usr/local/PHP/adodb/drivers/adodb-oci8.inc.php on line 228, referer:
> http://localhost/dba/dba_helper.php
>
> When I downgraded to 5.1.1 - it worked like a charm. Version 5.1.2 is
> still a little bit rough around the edges, isn't it?
>
> --
> http://www.mgogala.com[/color]

Are you sure the extension was compiled correctly?

re: 5.1.2 woes

On Thu, 12 Jan 2006 18:01:16 -0800, Chung Leong wrote:
[color=blue]
> Are you sure the extension was compiled correctly?[/color]

Yes, I am. ORACLE_HOME was set and here is the configure command I used:

../configure --with-apxs2=/opt/apache/bin/apxs --with-xmlrpc --with-zlib --with-bz2 --with-ttf --with-gd --enable-gd-native-ttf --with-freetype-dir --with-jpeg-dir --with-png-dir --with-config-file-path=/usr/local/lib/php --enable-sigchild --without-sqlite --disable-mysql --disable-pdo --with-oci8

Nothing fancy, nothing out of ordinary. I've seen the same type of
behavior with DBI-1.50 and DBD::Oracle 1.16 (another language, but the
problem looks exactly the same). The error message is exactly the
same, in both cases. No compilations errors were reported, in either
case.


--
http://www.mgogala.com

re: 5.1.2 woes

On Thu, 12 Jan 2006 18:01:16 -0800, Chung Leong wrote:
[color=blue]
>
> Are you sure the extension was compiled correctly?[/color]

I found the problem: I shouldn't have disabled PDO. With PDO and PDO_OCI
compiled in, it works like a charm. Funny thing that those two extensions
are interdependent.

--
http://www.mgogala.com

re: 5.1.2 woes

On Fri, 13 Jan 2006 01:09:00 GMT, Mladen Gogala <gogala@sbcglobal.net> wrote:
[color=blue]
>I downloaded PHP-5.1.2 and tried it with an application I normally use.
>Application connects to Oracle 10.2. Here is the result:
>
>[Thu Jan 12 19:26:11 2006] [notice] Apache/2.0.54 (Unix) PHP/5.1.2
>configured -- resuming normal operations [Thu Jan 12 19:26:20 2006]
>[error] [client 127.0.0.1] PHP Warning: ocilogon() [<a
>href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate() failed.
>There is something wrong with your system - please check that ORACLE_HOME
>is set and points to the right directory in
>/usr/local/PHP/adodb/drivers/adodb-oci8.inc.php on line 228, referer:
>http://localhost/dba/dba_helper.php
>
>When I downgraded to 5.1.1 - it worked like a charm. Version 5.1.2 is
>still a little bit rough around the edges, isn't it?[/color]

Any warnings during "configure"? Did the OCI8 bit look like it picked up
Oracle?

I've set up 5.1.2 on Linux and Windows, both connecting to Oracle to try out
the new version of the OCI8 extension - no issues in either case. The new
features seem to work well from a brief first test - the timeout on persistent
connections is a welcome addition, and it seems to work.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

re: 5.1.2 woes

On Fri, 13 Jan 2006 19:18:35 +0000, Andy Hassall wrote:
[color=blue]
> Any warnings during "configure"? Did the OCI8 bit look like it picked up
> Oracle?[/color]

Nope, no warnings. It seems that it needs something from PDO_OCI.
Strange.

--
http://www.mgogala.com

re: 5.1.2 woes

On Fri, 13 Jan 2006 21:40:53 GMT, Mladen Gogala <gogala@sbcglobal.net> wrote:
[color=blue]
>On Fri, 13 Jan 2006 19:18:35 +0000, Andy Hassall wrote:
>[color=green]
>> Any warnings during "configure"? Did the OCI8 bit look like it picked up
>> Oracle?[/color]
>
>Nope, no warnings. It seems that it needs something from PDO_OCI.
>Strange.[/color]

Just tried it with --disable-pdo. Same result. Yep, strange.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

re: 5.1.2 woes

Warning: oci_new_connect() [function.oci-new-connect]: OCIEnvNlsCreate()
failed. There is something wrong with your system - please check that
ORACLE_HOME is set and points to the right directory in
/wwwroot/htdocs/test.php on line 8


I am having this dump on my recent suse 10/oracle 10.2/apache
2.2.0/php5.1.2. Any ideas i pritty much used a uber basic.

apache cfg line
$ ./configure --prefix=/wwwroot --enable-so

php cfg line
'./configure' '--prefix=/wwwroot/php' '--with-apxs2=/wwwroot/bin/apxs'
'--with-config-file-path=/wwwroot/php'
'--with-oci8=/opt/oracle/product/10gR2' '--with-curl=/usr/local/lib'
'--with-mcrypt' '--with-xmlrpc'


Any one see were i fuxed up.


--
YeCkeL

re: 5.1.2 woes

I am experiencing the same error message. I can produce this message
by connecting quickly about four times - the first three times works
and then this error message is thrown:

"PHP Warning: ocilogon() [<a
href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate()
failed. There is something wrong with your system - please check that
ORACLE_HOME is set and points to the right directory in ..."

Here's my phpinfo configuration:

'./configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux'
'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--cache-file=../config.cache'
'--with-libdir=lib' '--with-config-file-path=/etc'
'--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic'
'--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin'
'--with-freetype-dir=/usr' '--with-png-dir=/usr'
'--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp'
'--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png'
'--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr'
'--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp'
'--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars'
'--enable-trans-sid' '--enable-yp' '--enable-wddx'
'--with-pear=/usr/share/pear' '--with-kerberos'
'--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr'
'--enable-memory-limit' '--enable-shmop' '--enable-calendar'
'--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic'
'--without-sqlite' '--with-libxml-dir=/usr' '--with-xml'
'--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd'
'--without-odbc' '--disable-dom' '--disable-dba'

PHP Version 5.0.4

Any ideas?