Perl 5.8.6 on HP-UX 11.11 with DBD::ORACLE 1.17 and Oracle 10g DB server

[HPP]

Procura,
Thank you very much for the reply.

I installed module DBD-Oracle-1.17 with Oracle 8i and perl 5.8.6 and my scripts works fine.

What you said was true that it was error caused my oracle 10g library. I will request our DBA to send this error to Oracle support and see what response we get.

Thanks again for all your help. Surely i will assign points.

[HPP]

Procura,
I installed DBD-Oracle 1.18 with Perl_32 (perl 5.8.8 from HP website) and ora10g/lib32. Same issue with script. Here is the output from gdb

# gdb /opt/perl_32/bin/perl core
HP gdb 5.4.0 for PA-RISC 1.1 or 2.0 (narrow), HP-UX 11.00
and target hppa1.1-hp-hpux11.00.
Copyright 1986 - 2001 Free Software Foundation, Inc.
Hewlett-Packard Wildebeest 5.4.0 (based on GDB) is covered by the
GNU General Public License. Type "show copying" to see the conditions to
change it and/or distribute copies. Type "show warranty" for warranty/support.
..(no debugging symbols found)...

warning: core file may not match specified executable file.
Core was generated by `test1.pl'.
Program terminated with signal 11, Segmentation fault.

(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...#0 0xc019afe8 in free+0x130 () from /usr/lib/libc.2
(gdb) where
#0 0xc019afe8 in free+0x130 () from /usr/lib/libc.2
#1 0xd031e710 in T_free+0x18 () from /ora10g/10.2.0/lib32/libnnz10.sl
#2 0xd0421a6c in R_free+0x10 () from /ora10g/10.2.0/lib32/libnnz10.sl
#3 0xd03f3df4 in BN_free+0x2c () from /ora10g/10.2.0/lib32/libnnz10.sl
#4 0xd042d7b8 in BN_MONT_CTX_free+0x18 () from /ora10g/10.2.0/lib32/libnnz10.sl
#5 0xc10d7260 in RSA_eay_public_decrypt+0x1b8 () from /opt/openssl/lib/libcrypto.sl
#6 0xc10d8c30 in RSA_public_decrypt+0x40 () from /opt/openssl/lib/libcrypto.sl
#7 0xc10d9774 in RSA_verify+0x17c () from /opt/openssl/lib/libcrypto.sl
#8 0xc0f63f38 in ssl3_get_key_exchange+0x928 () from /opt/openssl/lib/libssl.sl
#9 0xc0f61f70 in ssl3_connect+0x7b0 () from /opt/openssl/lib/libssl.sl
#10 0xc0f72350 in SSL_connect+0x38 () from /opt/openssl/lib/libssl.sl
#11 0xc0f6df70 in ssl23_get_server_hello+0x568 () from /opt/openssl/lib/libssl.sl
#12 0xc0f6d4ac in ssl23_connect+0x29c () from /opt/openssl/lib/libssl.sl
#13 0xc0f72350 in SSL_connect+0x38 () from /opt/openssl/lib/libssl.sl
#14 0xc64eeb94 in XS_Crypt__SSLeay__Conn_connect+0x2ec () from /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/Crypt/SSLeay/SSLeay.sl
#15 0x1370b4 in Perl_pp_entersub+0xc34 ()
#16 0x12bf78 in Perl_runops_standard+0x58 ()
#17 0x3f6f8 in S_run_body+0x36c ()
#18 0x3f2b4 in perl_run+0x50c ()
#19 0x388a0 in main+0xf8 ()


We will try to contact Oracle and give them the details.

[H.Merijn Brand (procura]

I think I found a generic solution that resolves this Oracle fuckup of SSL. I'd rather kill Oracle or at least remove libnnz10, but alas, it probably has more functionality than just the broken parts.

Assuming that is where your OpenSSL is installed in /usr/local/ssl

On PA-RISC:

tcsh/csh: setenv LD_PRELOAD /usr/local/ssl/lib/libcrypto.sl
sh/ksh/bash: export LD_PRELOAD=/usr/local/ssl/lib/libcrypto.sl

On Itanium:

tcsh/csh: setenv LD_PRELOAD /usr/local/ssl/lib/libcrypto.so
sh/ksh/bash: export LD_PRELOAD=/usr/local/ssl/lib/libcrypto.so

On both, it is more reliable to make very sure that /usr/local/ssl/lib is in front in both $SHLIB_PATH and in $LD_LIBRARY_PATH

Enjoy, Have FUN! H.Merijn [ who finds Oracle to be fun only in very rare conditions ]

[Randy Slezak]

Was the root cause of this problem ever determined and an associated fix? I have this same problem with LWP, oracle 10 and making connecting to https site. There are no DBI calls in the script, when I connect to http no problems.

Using LD_PRELOAD=... in front of my perl script pointing to /opt/openssl/lib/pa20_64/libcrypto.sl it works.

Any ideas?