[PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g

2010-03-02 Thread Andre LAGADEC 

Hello,

I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with
Apache2, Mysql6 and Oracle10g
with success.

But when I want to connect to Oracle database I get a core dump.

I use this code
?php
$c=ocilogon('bceconsulter','bce','BCE');
print_r($c);
Resource id #1
ocilogoff($c);
?

and I run it with the command /usr/local/apache2_php5_2_9/bin/php -a

I recompile PHP with --enable-debug and I run gdb to get a backtrace. I
get this
serveur7#/usr/local/apache2_php5_2_9/bin/php -a
Interactive mode enabled

?php
$c=ocilogon('scott','tigger','DB1');
Erreur de segmentation (core dumped)
serveur7#gdb /usr/local/apache2_php5_2_9/bin/php ./core
GNU gdb 6.8
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later
http://gnu.org/licenses/gpl.html
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type show copying
and show warranty for details.
This GDB was configured as i386-pc-solaris2.10...
Reading symbols from /usr/lib/libcrypt_d.so.1...done.
Loaded symbols for /usr/lib/libcrypt_d.so.1
Reading symbols from /usr/local/imap-2007e/lib/libc-client.so...done.
Loaded symbols for /usr/local/imap-2007e/lib/libc-client.so
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libexslt.so.0...done.
Loaded symbols for /usr/lib/libexslt.so.0
Reading symbols from /usr/local/lib/libtidy-0.99.so.0...done.
Loaded symbols for /usr/local/lib/libtidy-0.99.so.0
Reading symbols from /usr/lib/librt.so.1...done.
Loaded symbols for /usr/lib/librt.so.1
Reading symbols from
/usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16...done.
Loaded symbols for
/usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16
Reading symbols from /usr/local/lib/libmcrypt.so.4...done.
Loaded symbols for /usr/local/lib/libmcrypt.so.4
Reading symbols from /usr/local/lib/libltdl.so.7...done.
Loaded symbols for /usr/local/lib/libltdl.so.7
Reading symbols from /usr/lib/libldap.so.5...done.
Loaded symbols for /usr/lib/libldap.so.5
Reading symbols from /usr/lib/libpam.so.1...done.
Loaded symbols for /usr/lib/libpam.so.1
Reading symbols from /usr/local/lib/libintl.so.8...done.
Loaded symbols for /usr/local/lib/libintl.so.8
Reading symbols from /usr/local/lib/libiconv.so.2...done.
Loaded symbols for /usr/local/lib/libiconv.so.2
Reading symbols from /usr/lib/libsec.so.1...done.
Loaded symbols for /usr/lib/libsec.so.1
Reading symbols from /usr/lib/libc.so.1...done.
Loaded symbols for /usr/lib/libc.so.1
Reading symbols from /usr/sfw/lib/libfreetype.so.6...done.
Loaded symbols for /usr/sfw/lib/libfreetype.so.6
Reading symbols from /usr/lib/libpng12.so.0...done.
Loaded symbols for /usr/lib/libpng12.so.0
Reading symbols from /usr/lib/libjpeg.so.62...done.
Loaded symbols for /usr/lib/libjpeg.so.62
Reading symbols from /usr/local/ssl/lib/libssl.so.0.9.8...done.
Loaded symbols for /usr/local/ssl/lib/libssl.so.0.9.8
Reading symbols from /usr/local/ssl/lib/libcrypto.so.0.9.8...done.
Loaded symbols for /usr/local/ssl/lib/libcrypto.so.0.9.8
Reading symbols from /usr/lib/libresolv.so.2...done.
Loaded symbols for /usr/lib/libresolv.so.2
Reading symbols from /usr/lib/libm.so.2...done.
Loaded symbols for /usr/lib/libm.so.2
Reading symbols from /usr/lib/libnsl.so.1...done.
Loaded symbols for /usr/lib/libnsl.so.1
Reading symbols from /usr/lib/libsocket.so.1...done.
Loaded symbols for /usr/lib/libsocket.so.1
Reading symbols from /usr/lib/libxml2.so.2...done.
Loaded symbols for /usr/lib/libxml2.so.2
Reading symbols from /usr/lib/libkstat.so.1...done.
Loaded symbols for /usr/lib/libkstat.so.1
Reading symbols from /usr/lib/libgen.so.1...done.
Loaded symbols for /usr/lib/libgen.so.1
Reading symbols from /usr/lib/libdl.so.1...done.
Loaded symbols for /usr/lib/libdl.so.1
Reading symbols from /usr/lib/libsched.so.1...
warning: Lowest section in /usr/lib/libsched.so.1 is .dynamic at 0074
done.
Loaded symbols for /usr/lib/libsched.so.1
Reading symbols from
/produits/oracle/product/10.2.0/lib32/libclntsh.so.10.1...done.
Loaded symbols for /produits/oracle/product/10.2.0/lib32/libclntsh.so.10.1
Reading symbols from /usr/lib/libthread.so.1...
warning: Lowest section in /usr/lib/libthread.so.1 is .dynamic at 0074
done.
Loaded symbols for /usr/lib/libthread.so.1
Reading symbols from /usr/lib/libxslt.so.1...done.
Loaded symbols for /usr/lib/libxslt.so.1
Reading symbols from /usr/sfw/lib/libgcc_s.so.1...done.
Loaded symbols for /usr/sfw/lib/libgcc_s.so.1
Reading symbols from /usr/lib/libpthread.so.1...
warning: Lowest section in /usr/lib/libpthread.so.1 is .dynamic at 0074
done.
Loaded symbols for /usr/lib/libpthread.so.1
Reading symbols from /usr/lib/libaio.so.1...done.
Loaded symbols for /usr/lib/libaio.so.1
Reading symbols from /usr/lib/libmd.so.1...done.
Loaded symbols for /usr/lib/libmd.so.1
Reading symbols from /usr/lib/libcmd.so.1...done.
Loaded symbols for

Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g

2010-03-02 Thread andre . lagadec 
Hi,

My LD_LIBRARY_PATH was
/produits/oracle/product/10.2.0/lib32:/produits/oracle/product/10.2.0/network/lib32:/usr/local/lib:/usr/lib:/usr/sfw/lib


If I execute the command ldd
-d /produits/oracle/product/10.2.0/lib32/libclntsh.so.10.1
I get this result
libnnz10.so =   /produits/oracle/product/10.2.0/lib32/libnnz10.so
libkstat.so.1 = /usr/lib/libkstat.so.1
libnsl.so.1 =   /usr/lib/libnsl.so.1
libsocket.so.1 =/usr/lib/libsocket.so.1
libgen.so.1 =   /usr/lib/libgen.so.1
libdl.so.1 =/usr/lib/libdl.so.1
libsched.so.1 = /usr/lib/libsched.so.1
libaio.so.1 =   /usr/lib/libaio.so.1
librt.so.1 =/usr/lib/librt.so.1
libm.so.2 = /usr/lib/libm.so.2
libc.so.1 = /usr/lib/libc.so.1
libmp.so.2 =/usr/lib/libmp.so.2
libmd.so.1 =/usr/lib/libmd.so.1
libscf.so.1 =   /usr/lib/libscf.so.1
libdoor.so.1 =  /usr/lib/libdoor.so.1
libuutil.so.1 = /usr/lib/libuutil.so.1

But, if I execute ldd -d ldd
-d /produits/oracle/product/10.2.0/lib32/libnnz10.so
I get these errors messages.
symbole introuvable : __ctype_mask
(/produits/oracle/product/10.2.0/lib32/libnnz10.so)
symbole introuvable : h_errno
(/produits/oracle/product/10.2.0/lib32/libnnz10.so)
symbole introuvable : __iob
(/produits/oracle/product/10.2.0/lib32/libnnz10.so)
symbole introuvable : nltrc_entry
(/produits/oracle/product/10.2.0/lib32/libnnz10.so)
symbole introuvable : nltrc_exit
(/produits/oracle/product/10.2.0/lib32/libnnz10.so)
symbole introuvable : nzdacvalue
(/produits/oracle/product/10.2.0/lib32/libnnz10.so)

So there is something wrong in library.

Any idea ?

I continue to search on Google...

-Christopher Jones christopher.jo...@oracle.com a écrit : -

A : Andre LAGADEC andre.laga...@education.gouv.fr
De : Christopher Jones christopher.jo...@oracle.com
Date : 02/03/2010 17:58
cc: php-db@lists.php.net
Objet : Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9
and Oracle 10g


At a guess, there is a clash with the SSL libraries or it is a libpthread
problem - google around for background.

Chris

Andre LAGADEC wrote:
 Hello,

 I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with
 Apache2, Mysql6 and Oracle10g
 with success.

 But when I want to connect to Oracle database I get a core dump.

 I use this code
 ?php
 $c=ocilogon('bceconsulter','bce','BCE');
 print_r($c);
 Resource id #1
 ocilogoff($c);
 ?

 and I run it with the command /usr/local/apache2_php5_2_9/bin/php -a

 I recompile PHP with --enable-debug and I run gdb to get a backtrace. I
 get this
 serveur7#/usr/local/apache2_php5_2_9/bin/php -a
 Interactive mode enabled

 ?php
 $c=ocilogon('scott','tigger','DB1');
 Erreur de segmentation (core dumped)
 serveur7#gdb /usr/local/apache2_php5_2_9/bin/php ./core
 GNU gdb 6.8
 Copyright (C) 2008 Free Software Foundation, Inc.
 License GPLv3+: GNU GPL version 3 or later
 http://gnu.org/licenses/gpl.html
 This is free software: you are free to change and redistribute it.
 There is NO WARRANTY, to the extent permitted by law.  Type show
copying
 and show warranty for details.
 This GDB was configured as i386-pc-solaris2.10...
 Reading symbols from /usr/lib/libcrypt_d.so.1...done.
 Loaded symbols for /usr/lib/libcrypt_d.so.1
 Reading symbols from /usr/local/imap-2007e/lib/libc-client.so...done.
 Loaded symbols for /usr/local/imap-2007e/lib/libc-client.so
 Reading symbols from /usr/lib/libz.so.1...done.
 Loaded symbols for /usr/lib/libz.so.1
 Reading symbols from /usr/lib/libexslt.so.0...done.
 Loaded symbols for /usr/lib/libexslt.so.0
 Reading symbols from /usr/local/lib/libtidy-0.99.so.0...done.
 Loaded symbols for /usr/local/lib/libtidy-0.99.so.0
 Reading symbols from /usr/lib/librt.so.1...done.
 Loaded symbols for /usr/lib/librt.so.1
 Reading symbols from
 /usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16...done.


 Loaded symbols for
 /usr/local/mysql-connector-c-6.0.2-solaris10-x86-32bit/lib/libmysql.so.16
 Reading symbols from /usr/local/lib/libmcrypt.so.4...done.
 Loaded symbols for /usr/local/lib/libmcrypt.so.4
 Reading symbols from /usr/local/lib/libltdl.so.7...done.
 Loaded symbols for /usr/local/lib/libltdl.so.7
 Reading symbols from /usr/lib/libldap.so.5...done.
 Loaded symbols for /usr/lib/libldap.so.5
 Reading symbols from /usr/lib/libpam.so.1...done.
 Loaded symbols for /usr/lib/libpam.so.1
 Reading symbols from /usr/local/lib/libintl.so.8...done.
 Loaded symbols for /usr/local/lib/libintl.so.8
 Reading symbols from /usr/local/lib/libiconv.so.2...done.
 Loaded symbols for /usr/local/lib/libiconv.so.2
 Reading symbols from /usr/lib/libsec.so.1...done.
 Loaded symbols for /usr/lib/libsec.so.1
 Reading symbols from /usr/lib/libc.so.1...done.
 Loaded symbols for /usr/lib/libc.so.1
 Reading symbols from /usr/sfw/lib

[PHP-DB] Probleme accents

2013-03-03 Thread ANDRE LAGADEC 
Hi,

On my application PHP with Oracle database, all work fine but sometimes the 
caracters like 'éèàù' become 'eau' or '?', and after make apachectl stop/start
it become normal.

Here are my configuration :
   - Apache2.2.21 
   - Php-5.2.13 with PDO Oracle
   - Client Oracle 11.2.0.1 
   - Base Oracle 9.2.0.7
On my Web server, I have set :
ORACLE_BASE
ORACLE_HOME
TNS_ADMIN
NLS_LANG = French_France.WE8ISO8859P1
LANG=C
LC_COLLATE=fr_FR.ISO8859-1
LC_CTYPE=fr_FR.ISO8859-1
LC_MESSAGES=fr
LC_MONETARY=fr_FR.ISO8859-1
LC_NUMERIC=fr_FR.ISO8859-1
LC_TIME=fr_FR.ISO8859-1

In HTML headers of page, there is
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN 
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; 
 html xmlns=http://www.w3.org/1999/xhtml; xml:lang=fr lang=fr 
 head 
  meta http-equiv=Content-Type content=text/html; charset=utf-8 / 
  meta name=language content=fr / 
 
And on my Oracle Dababase server, I have
NLS_CHARACTERSET=WE8ISO8859P1
NLS_NCHAR_CHARACTERSET= AL16UTF16

Can somebody explain me how I can lost my accents in 'éèàùç', and how I can 
repair this ?
 
Thanks for your help.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php