Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Informatica ODBC Setup with SSL

Solved Go to solution

Informatica ODBC Setup with SSL

New Contributor

Good Afternoon,

 

My organization is having trouble setting up an ODBC on Redhat and I think it might have something to do with the SSL configuration.

 

The error we receive is: "FATAL ERROR : Signal Received: SIGSEGV (11)" but when our administrator looked into the trace it seemed to point to SSL.

 

Is there a way to configure trust store password? I think this might be the item we are missing from our driver configuration. Settings below for a normal JDBC string we use in other applications and our current driver settings.

 

JDBC: 

jdbc:hive2://{host}:{port}/;ssl=true;sslTrustStore={certs.jks};trustStorePassword=changeit

 

Driver:

[HIVE]
Description=Cloudera ODBC Driver for Apache Hive (64-bit) DSN
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
HiveServerType=2
Host=[host]
Port=[post]
AuthMech=3
ThriftTransport=1
UID=[username]

PWD=[password]
TrustedCerts=[cert.pem]
KrbHostFQDN=_HOST
KrbServiceName=hive
KrbRealm=[ORG]
SSL=1

 

Thank you!

Aaron

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Informatica ODBC Setup with SSL

New Contributor

Hey Eric,

 

Appreciate all the help with this one. I'm circling back on this one before I forget. I figured out the issue which was related to the driver.

 

We use RHEL 6 on the server that we were trying to set this up on. OpenSSL driver was built into library dependencies so we kept getting connection errors no matter which tweaks we tried. We actually discovered that OpenSSL was built into the dependencies of the driver libraries too. Rolling back to a version from like 6 months ago worked like a charm.

 

Pasting a snippet from an email I sent detailing this in case it helps someone in the future. I used web.archive.org to view old release notes and determined which version was most compatible with our OpenSSL driver. Anyone using Informatica/Redhat that has issues, might be best to start looking there first.

 

"According to this page our openSSL version is 4 years old: https://web.archive.org/web/20150120120428/https://www.openssl.org/news/openssl-1.0.1-notes.html

 

Another archived page with old connector release notes, 2.5.17 shows an upgrade to OpenSSL past our version. Use 2.5.16 for testing.

https://web.archive.org/web/20160508220024/http://www.cloudera.com/documentation/other/connectors/hi...

 

            Version 2.5.17

            Upgraded OpenSSL library

                        The driver now uses OpenSSL 1.0.1l. Previously, the driver used OpenSSL 1.0.0q."

 

5 REPLIES 5

Re: Informatica ODBC Setup with SSL

Guru
Hi Aaron,

Are you able to share the exact error you get in the ODBC trace log that you mentioned?

Is your server using self-signed or CA signed certificates? If Self-Signed, you might need to add AllowSelfSignedServerCert=1 in your ODBC driver config file.

Since you are using ODBC driver, the JDBC connection string you mentioned does not apply here:
jdbc:hive2://{host}:{port}/;ssl=true;sslTrustStore={certs.jks};trustStorePassword=changeit

Where is the certificate file cert.pem?

Cheers
Eric

Re: Informatica ODBC Setup with SSL

New Contributor

Thanks for the quick reply Eric!

 

Here is the stack trace.. looks like Informatica uses GDB debugger and I see the process crashes on a single thread.

 

==============================================
pmstack 7.0 28OCT2015
==============================================
 
Invoked at : Tue Sep  3 13:54:51 EDT 2019
Invoked by : infadm
Debugger : gdb
Current Directory : /opt/informatica/Informatica/10.1/server/bin
 
OS info :
Linux [INFA SERVER] 2.6.32-754.11.1.el6.x86_64 #1 SMP Tue Jan 22 17:25:23 EST 2019 x86_64 x86_64 x86_64 GNU/Linux
 
Core info :
-rw-------. 1 infadm infadm 135438336 Aug  8 15:37 core.15342
core.15342: ELF 64-bit LSB core file x86-64, version 1 (SYSV), SVR4-style, from 'pmdtm -PR -gmh [INFA SERVER].[ORGANIZATION] -gmp 6045 -guid 299def2c-cd08-4d41-9', real uid: 507, effective uid: 507, real gid: 507, effective gid: 507, execfn: '/opt/informatica/Informatica/10.1/server/bin/pmdtm', platform: 'x86_64'
 
Process name used for analyzing the core : /opt/informatica/Informatica/10.1/server/bin/pmdtm
 
/opt/informatica/Informatica/10.1/server/bin/pmdtm is not a Java program. Proceeding..
Program info :
-rwxrwxr-x. 1 infadm infadm 7938667 Feb 22  2018 /opt/informatica/Informatica/10.1/server/bin/pmdtm
 
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/pmdtm...(no debugging symbols found)...done.
[New Thread 15355]
[New Thread 15353]
[New Thread 15342]
[New Thread 15351]
[New Thread 15344]
[New Thread 15343]
[New Thread 15352]
Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done.
[Thread debugging using libthread_db enabled]
Loaded symbols for /lib64/libpthread.so.0
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmmqcmn.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmmqcmn.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcmnexpr.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcmnexpr.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcmnxcontext.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcmnxcontext.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmsrvexpr.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmsrvexpr.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmsrvxcontext.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmsrvxcontext.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpcsflog.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpcsflog.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmdetector.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmdetector.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmdec.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmdec.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libnsort.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libnsort.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcuti.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcuti.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcrypto.so.1.0.0...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcrypto.so.1.0.0
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmuti.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmuti.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmasrt.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmasrt.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmsdksrv.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmsdksrv.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmrepsdk.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmrepsdk.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmsdkcmn.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmsdkcmn.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmtx.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmtx.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmser.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmser.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmi18n.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmi18n.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmprepare.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmprepare.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmmq.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmmq.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmxmlrdrutil.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmxmlrdrutil.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmxml.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmxml.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmwrtfile.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmwrtfile.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmldrgen.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmldrgen.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcmnvari.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcmnvari.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcmnvar.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcmnvar.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmvar.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmvar.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmlmapi.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmlmapi.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmdbopt.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmdbopt.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmparopt.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmparopt.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcrep.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcrep.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmodl.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmodl.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcmnrep.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcmnrep.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmesapi.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmesapi.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpminfapi.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpminfapi.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmxmlrowblkmgr.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmxmlrowblkmgr.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmxmlrdrmdinfo.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmxmlrdrmdinfo.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpcsfcmn.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpcsfcmn.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpcsfprtcl.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpcsfprtcl.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmproctasklib.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmproctasklib.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmlicense.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmlicense.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmkamauth.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmkamauth.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libACE_SSL.so.6.3.3...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libACE_SSL.so.6.3.3
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmICE.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmICE.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmxerces-c.so.27...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmxerces-c.so.27
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmcurl.so.4...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmcurl.so.4
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmssh2.so.1...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmssh2.so.1
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmicudata.so.32...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmicudata.so.32
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmicui18n.so.32...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmicui18n.so.32
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmicuio.so.32...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmicuio.so.32
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmicuuc.so.32...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmicuuc.so.32
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmz.so.1...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmz.so.1
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmssl.so.1.0.0...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmssl.so.1.0.0
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmfbopenssl.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmfbopenssl.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libgssapi_krb5.so.2...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libgssapi_krb5.so.2
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libkrb5.so.3...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libkrb5.so.3
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libk5crypto.so.3...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libk5crypto.so.3
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libkrb5support.so.0...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libkrb5support.so.0
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libcom_err.so.3...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libcom_err.so.3
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libkam.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libkam.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmpcsfconfigsvc.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmpcsfconfigsvc.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmsso.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmsso.so
Reading symbols from /lib64/librt.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/librt.so.1
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmtl.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmtl.so
Reading symbols from /lib64/libnsl.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libnsl.so.1
Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /usr/lib64/libstdc++.so.6...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libstdc++.so.6
Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/libgcc_s.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libgcc_s.so.1
Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libcrypt.so.1
Reading symbols from /lib64/libidn.so.11...(no debugging symbols found)...done.
Loaded symbols for /lib64/libidn.so.11
Reading symbols from /lib64/libkeyutils.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libkeyutils.so.1
Reading symbols from /lib64/libresolv.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libresolv.so.2
Reading symbols from /lib64/libfreebl3.so...(no debugging symbols found)...done.
Loaded symbols for /lib64/libfreebl3.so
Reading symbols from /lib64/libnss_files.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /lib64/libnss_dns.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libnss_dns.so.2
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmrelrdr.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmrelrdr.so
Reading symbols from /opt/informatica/Informatica/10.1/server/bin/libpmodbc.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/server/bin/libpmodbc.so
Reading symbols from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
Reading symbols from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbcinst.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbcinst.so
Reading symbols from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libDWicu27.so...(no debugging symbols found)...done.
Loaded symbols for /opt/informatica/Informatica/10.1/ODBC7.1/lib/libDWicu27.so
Reading symbols from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so...(no debugging symbols found)...done.
Loaded symbols for /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
Reading symbols from /lib64/libcom_err.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libcom_err.so.2
Reading symbols from /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libicudata_sb64.so.58...(no debugging symbols found)...done.
Loaded symbols for /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libicudata_sb64.so.58
Reading symbols from /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libicui18n_sb64.so.58...(no debugging symbols found)...done.
Loaded symbols for /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libicui18n_sb64.so.58
Reading symbols from /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libicuuc_sb64.so.58...(no debugging symbols found)...done.
Loaded symbols for /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libicuuc_sb64.so.58
Reading symbols from /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libssl.so.1.1...(no debugging symbols found)...done.
Loaded symbols for /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libssl.so.1.1
Reading symbols from /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libcrypto.so.1.1...(no debugging symbols found)...done.
Loaded symbols for /opt/cloudera/hiveodbc/lib/64/ThirdParty/./libcrypto.so.1.1
Core was generated by `pmdtm -PR -gmh [INFA SERVER].[ORGANIZATION] -gmp 6045 -guid 299def2c-cd08-4d41-9'.
Program terminated with signal 6, Aborted.
#0  0x0000003700e32495 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install glibc-2.12-1.212.el6.x86_64 keyutils-libs-1.4-5.el6.x86_64 libcom_err-1.41.12-24.el6.x86_64 libgcc-4.4.7-23.el6.x86_64 libidn-1.18-2.el6.x86_64 libstdc++-4.4.7-23.el6.x86_64 nss-softokn-freebl-3.14.3-23.3.el6_8.x86_64
(gdb) (gdb) (gdb) (gdb) "Threads List :" >> core.15342_20190903_135451.trace(gdb)   7 Thread 0x7f9bf97bc700 (LWP 15352)  0x0000003700edf393 in poll () from /lib64/libc.so.6
  6 Thread 0x7f9bfb674700 (LWP 15343)  0x0000003700edf393 in poll () from /lib64/libc.so.6
  5 Thread 0x7f9bfac73700 (LWP 15344)  0x000000370120ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
  4 Thread 0x7f9bfa1bd700 (LWP 15351)  0x000000370120ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
  3 Thread 0x7f9c01a7e720 (LWP 15342)  0x000000370120b68c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
  2 Thread 0x7f9bf8dbb700 (LWP 15353)  0x000000370120b68c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
* 1 Thread 0x7f9be3fff700 (LWP 15355)  0x0000003700e32495 in raise () from /lib64/libc.so.6
(gdb) "Current Thread :" >> core.15342_20190903_135451.trace(gdb) #0  0x0000003700e32495 in raise () from /lib64/libc.so.6
#1  0x0000003700e33c75 in abort () from /lib64/libc.so.6
#2  0x00007f9c0c54ae19 in PmAbortProcess() () from /opt/informatica/Informatica/10.1/server/bin/libpmuti.so
#3  0x00000000005de9ff in fatalSignalHandler(int, siginfo*, void*) ()
#4  <signal handler called>
#5  0x0000003700f28696 in __strcmp_sse42 () from /lib64/libc.so.6
#6  0x00007f9c0ca37659 in lh_insert () from /opt/informatica/Informatica/10.1/server/bin/libpmcrypto.so.1.0.0
#7  0x00007f9c0c996dbb in OBJ_NAME_add () from /opt/informatica/Informatica/10.1/server/bin/libpmcrypto.so.1.0.0
#8  0x00007f9bda7afe70 in openssl_add_all_ciphers_int () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#9  0x00007f9bda6e00c9 in ossl_init_add_all_ciphers_ossl_ () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#10 0x000000370120ce03 in pthread_once () from /lib64/libpthread.so.0
#11 0x00007f9bda71e1a9 in CRYPTO_THREAD_run_once () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#12 0x00007f9bda6dfdc3 in OPENSSL_init_crypto () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#13 0x00007f9bda660c1c in OPENSSL_init_ssl () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#14 0x00007f9bda5f33d4 in apache::thrift::transport::TETSSLSocketFactory::initializeOpenSSL() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#15 0x00007f9bda5f6811 in apache::thrift::transport::TETSSLSocketFactory::TETSSLSocketFactory(Simba::ThriftExtension::TESettings const&, Simba::Support::ILogger*) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#16 0x00007f9bda5eade1 in Simba::ThriftExtension::TEHttpProxySslSocketFactory::TEHttpProxySslSocketFactory(Simba::ThriftExtension::TESettings const&, Simba::Support::ILogger*) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#17 0x00007f9bd9ad2af3 in Simba::Hardy::HardyHiveCxnFactory::GetTSslSocketFactory() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#18 0x00007f9bd9ad35a8 in (anonymous namespace)::CreateTSocket(Simba::Hardy::HardyHiveCxnFactory&, Simba::Hardy::HardySettings&, Simba::Support::ILogger&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#19 0x00007f9bd9ad3937 in (anonymous namespace)::CreateNonHttpTProtocol(Simba::Hardy::HardyHiveCxnFactory&, Simba::Hardy::HardySettings&, Simba::Support::ILogger&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#20 0x00007f9bd9ad4114 in Simba::Hardy::HardyHiveCxnFactory::CreateHS2NonHttpCxn() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#21 0x00007f9bd9ad47d9 in Simba::Hardy::HardyHiveCxnFactory::CreateHS2Cxn(bool) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#22 0x00007f9bd9adc214 in Simba::Hardy::HardyHiveCxnPool::CreateHS2Cxn(bool) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#23 0x00007f9bd9adcfec in Simba::Hardy::HardyHiveCxnPool::GetHS2Cxn() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#24 0x00007f9bd9afd95f in Simba::Hardy::HardyTCLIServiceClient::GetBackendCxn() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#25 0x00007f9bd9afddb9 in Simba::Hardy::HardyTCLIServiceClient::TestConnection() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#26 0x00007f9bd9a443ba in Simba::Hardy::HardyConnection::Establish() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#27 0x00007f9bd9a4e6c4 in Simba::Hardy::HardyConnection::HandleConnect(std::map<Simba::Support::simba_wstring, Simba::Support::Variant, Simba::Support::simba_wstring::CaseInsensitiveComparator, std::allocator<std::pair<Simba::Support::simba_wstring const, Simba::Support::Variant> > > const&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#28 0x00007f9bda820cee in Simba::DriverSupport::DSCommonConnection::Connect(std::map<Simba::Support::simba_wstring, Simba::Support::Variant, Simba::Support::simba_wstring::CaseInsensitiveComparator, std::allocator<std::pair<Simba::Support::simba_wstring const, Simba::Support::Variant> > > const&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#29 0x00007f9bd9d68470 in Simba::ODBC::Connection::CompleteConnection(Simba::ODBC::ConnectionSettings&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#30 0x00007f9bd9d7c2f3 in Simba::ODBC::ConnectionState2::SQLConnectW(Simba::ODBC::Connection*, wchar_t*, short, wchar_t*, short, wchar_t*, short) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#31 0x00007f9bd9d6ffc5 in Simba::ODBC::Connection::SQLConnectW(wchar_t*, short, wchar_t*, short, wchar_t*, short) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#32 0x00007f9bd9d11ca4 in Simba::ODBC::SQLConnectTask<true>::DoSynchronously(Simba::ODBC::Connection&, Simba::ODBC::SQLConnectTask<true>::TaskParameters const&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#33 0x00007f9bd9d6490c in short DoTask<Simba::ODBC::SQLConnectTask<true> >(char const*, void*, Simba::ODBC::SQLConnectTask<true>::TaskParameters&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#34 0x00007f9bd9d27c48 in SQLConnectW () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#35 0x00007f9be0bd0344 in ?? () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#36 0x00007f9be0bcfbf9 in ?? () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#37 0x00007f9be0bcfffc in ?? () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#38 0x00007f9be0bb8fa3 in SQLConnectA () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#39 0x00007f9be0de9d66 in TODBCDb::Connect(PmUString const&, PmUString const&, PmUString const&, short) () from /opt/informatica/Informatica/10.1/server/bin/libpmodbc.so
#40 0x00007f9c08fcf187 in TDatabase::ConnectImpl(PmUString const&, PmUString const&, PmUString const&, short) () from /opt/informatica/Informatica/10.1/server/bin/libpmodl.so
#41 0x00007f9c08fcf8eb in TDatabase::Connect(PmUString const&, PmUString const&, PmUString const&, short, int) () from /opt/informatica/Informatica/10.1/server/bin/libpmodl.so
#42 0x00007f9bf81a58e8 in relReader::connect(int) () from /opt/informatica/Informatica/10.1/server/bin/libpmrelrdr.so
#43 0x00007f9bf81a90d3 in relReader::Connect() () from /opt/informatica/Informatica/10.1/server/bin/libpmrelrdr.so
#44 0x00000000007a73e2 in frame_blkReader::init() ()
#45 0x00000000007a773d in SReaderRunnable::handleRequest(SManagerRequest const&) ()
#46 0x00000000006268a2 in SWorker::run() ()
#47 0x0000000000601fe1 in SDTMRunnable::MainEntryPoint() ()
#48 0x00007f9c0e45efea in runit(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#49 0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#50 0x0000003700ee8bdd in clone () from /lib64/libc.so.6
(gdb) "All Threads :" >> core.15342_20190903_135451.trace(gdb) 
Thread 7 (Thread 0x7f9bf97bc700 (LWP 15352)):
#0  0x0000003700edf393 in poll () from /lib64/libc.so.6
#1  0x00007f9c0c54afdb in PmSleep(int, short) () from /opt/informatica/Informatica/10.1/server/bin/libpmuti.so
#2  0x0000000000614586 in SMonitorRunnable::run() ()
#3  0x0000000000614895 in SMonitorRunnable::handleRequest(SManagerRequest const&) ()
#4  0x00000000006268a2 in SWorker::run() ()
#5  0x0000000000601fe1 in SDTMRunnable::MainEntryPoint() ()
#6  0x00007f9c0e45efea in runit(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#7  0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#8  0x0000003700ee8bdd in clone () from /lib64/libc.so.6

Thread 6 (Thread 0x7f9bfb674700 (LWP 15343)):
#0  0x0000003700edf393 in poll () from /lib64/libc.so.6
#1  0x00007f9c054fd667 in ICEOS::select(ICESelectHandle*, int, ICETimeValue const*) () from /opt/informatica/Informatica/10.1/server/bin/libpmICE.so
#2  0x00007f9c07096b04 in IAConnModule::run() () from /opt/informatica/Informatica/10.1/server/bin/libpminfapi.so
#3  0x00007f9c07096d02 in IAConnModule::startFunc(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpminfapi.so
#4  0x00007f9c05a5c2d5 in ACE_Thread_Adapter::invoke_i() () from /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3
#5  0x00007f9c05a5c351 in ACE_Thread_Adapter::invoke() () from /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3
#6  0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#7  0x0000003700ee8bdd in clone () from /lib64/libc.so.6

Thread 5 (Thread 0x7f9bfac73700 (LWP 15344)):
#0  0x000000370120ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f9c05a053ee in ACE_Condition<ACE_Thread_Mutex>::wait(ACE_Thread_Mutex&, ACE_Time_Value const*) () from /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3
#2  0x00007f9c054eebba in ICECondition::wait(ICETimeValue const*) () from /opt/informatica/Informatica/10.1/server/bin/libpmICE.so
#3  0x00007f9c09316328 in RClientAsyncThread::wait(unsigned int&) () from /opt/informatica/Informatica/10.1/server/bin/libpmcrep.so
#4  0x00007f9c09316ecd in RClientAsyncThread::run() () from /opt/informatica/Informatica/10.1/server/bin/libpmcrep.so
#5  0x00007f9c09316002 in RClientAsyncThread::threadMain(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpmcrep.so
#6  0x00007f9c05a5c2d5 in ACE_Thread_Adapter::invoke_i() () from /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3
#7  0x00007f9c05a5c351 in ACE_Thread_Adapter::invoke() () from /opt/informatica/Informatica/10.1/server/bin/libACE.so.6.3.3
#8  0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#9  0x0000003700ee8bdd in clone () from /lib64/libc.so.6

Thread 4 (Thread 0x7f9bfa1bd700 (LWP 15351)):
#0  0x000000370120ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f9c0e45ce13 in timedWait(pthread_cond_t*, pthread_mutex_t*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#2  0x00007f9c0e45e675 in conditionWait(pthread_cond_t*, SMutex*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#3  0x00007f9c0e460275 in SThread::Sleep(unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#4  0x00007f9c0e45e9ab in SEvent::putThreadToSleep(SThread*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#5  0x00007f9c0e45f8ce in msgque::get(int, TObject**, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#6  0x00007f9c0e45fa77 in SThread::readMessage(int, unsigned int, TObject**) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#7  0x000000000060815b in SManagerImpl::getNextMessage(int) ()
#8  0x000000000060b797 in SManagerImpl::doAsyncHandling() ()
#9  0x000000000060bfd2 in SManagerImpl::run() ()
#10 0x000000000060e3e7 in SManagerRunnable::start() ()
#11 0x0000000000601fe1 in SDTMRunnable::MainEntryPoint() ()
#12 0x00007f9c0e45efea in runit(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#13 0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#14 0x0000003700ee8bdd in clone () from /lib64/libc.so.6

Thread 3 (Thread 0x7f9c01a7e720 (LWP 15342)):
#0  0x000000370120b68c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f9c0e45e60c in conditionWait(pthread_cond_t*, SMutex*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#2  0x00007f9c0e460275 in SThread::Sleep(unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#3  0x00007f9c0e45e9ab in SEvent::putThreadToSleep(SThread*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#4  0x00007f9c0e45f8ce in msgque::get(int, TObject**, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#5  0x00007f9c0e45fa77 in SThread::readMessage(int, unsigned int, TObject**) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#6  0x00000000005fc4a5 in SDirectorImpl::getNextMessage() ()
#7  0x00000000005fca4d in SDirectorImpl::doPETLOrchestration() ()
#8  0x00000000005fda58 in SDirectorImpl::orchestrate() ()
#9  0x00000000005fdb31 in SDirectorImpl::run() ()
#10 0x0000000000601bf7 in SDirectorRunnable::start() ()
#11 0x00000000005cfa12 in SExecutorDTM::start() ()
#12 0x00000000005e9c10 in SPreparerDTMImpl::start() ()
#13 0x00000000005e193b in DTMMain(int, char const**) ()
#14 0x0000003700e1ed1d in __libc_start_main () from /lib64/libc.so.6
#15 0x00000000005bc639 in _start ()

Thread 2 (Thread 0x7f9bf8dbb700 (LWP 15353)):
#0  0x000000370120b68c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007f9c0e45e60c in conditionWait(pthread_cond_t*, SMutex*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#2  0x00007f9c0e460275 in SThread::Sleep(unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#3  0x00007f9c0e45e9ab in SEvent::putThreadToSleep(SThread*, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#4  0x00007f9c0e45f8ce in msgque::get(int, TObject**, unsigned int) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#5  0x00007f9c0e45fa77 in SThread::readMessage(int, unsigned int, TObject**) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#6  0x0000000000626774 in SWorker::run() ()
#7  0x0000000000601fe1 in SDTMRunnable::MainEntryPoint() ()
#8  0x00007f9c0e45efea in runit(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#9  0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#10 0x0000003700ee8bdd in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7f9be3fff700 (LWP 15355)):
#0  0x0000003700e32495 in raise () from /lib64/libc.so.6
#1  0x0000003700e33c75 in abort () from /lib64/libc.so.6
#2  0x00007f9c0c54ae19 in PmAbortProcess() () from /opt/informatica/Informatica/10.1/server/bin/libpmuti.so
#3  0x00000000005de9ff in fatalSignalHandler(int, siginfo*, void*) ()
#4  <signal handler called>
#5  0x0000003700f28696 in __strcmp_sse42 () from /lib64/libc.so.6
#6  0x00007f9c0ca37659 in lh_insert () from /opt/informatica/Informatica/10.1/server/bin/libpmcrypto.so.1.0.0
#7  0x00007f9c0c996dbb in OBJ_NAME_add () from /opt/informatica/Informatica/10.1/server/bin/libpmcrypto.so.1.0.0
#8  0x00007f9bda7afe70 in openssl_add_all_ciphers_int () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#9  0x00007f9bda6e00c9 in ossl_init_add_all_ciphers_ossl_ () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#10 0x000000370120ce03 in pthread_once () from /lib64/libpthread.so.0
#11 0x00007f9bda71e1a9 in CRYPTO_THREAD_run_once () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#12 0x00007f9bda6dfdc3 in OPENSSL_init_crypto () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#13 0x00007f9bda660c1c in OPENSSL_init_ssl () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#14 0x00007f9bda5f33d4 in apache::thrift::transport::TETSSLSocketFactory::initializeOpenSSL() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#15 0x00007f9bda5f6811 in apache::thrift::transport::TETSSLSocketFactory::TETSSLSocketFactory(Simba::ThriftExtension::TESettings const&, Simba::Support::ILogger*) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#16 0x00007f9bda5eade1 in Simba::ThriftExtension::TEHttpProxySslSocketFactory::TEHttpProxySslSocketFactory(Simba::ThriftExtension::TESettings const&, Simba::Support::ILogger*) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#17 0x00007f9bd9ad2af3 in Simba::Hardy::HardyHiveCxnFactory::GetTSslSocketFactory() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#18 0x00007f9bd9ad35a8 in (anonymous namespace)::CreateTSocket(Simba::Hardy::HardyHiveCxnFactory&, Simba::Hardy::HardySettings&, Simba::Support::ILogger&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#19 0x00007f9bd9ad3937 in (anonymous namespace)::CreateNonHttpTProtocol(Simba::Hardy::HardyHiveCxnFactory&, Simba::Hardy::HardySettings&, Simba::Support::ILogger&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#20 0x00007f9bd9ad4114 in Simba::Hardy::HardyHiveCxnFactory::CreateHS2NonHttpCxn() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#21 0x00007f9bd9ad47d9 in Simba::Hardy::HardyHiveCxnFactory::CreateHS2Cxn(bool) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#22 0x00007f9bd9adc214 in Simba::Hardy::HardyHiveCxnPool::CreateHS2Cxn(bool) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#23 0x00007f9bd9adcfec in Simba::Hardy::HardyHiveCxnPool::GetHS2Cxn() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#24 0x00007f9bd9afd95f in Simba::Hardy::HardyTCLIServiceClient::GetBackendCxn() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#25 0x00007f9bd9afddb9 in Simba::Hardy::HardyTCLIServiceClient::TestConnection() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#26 0x00007f9bd9a443ba in Simba::Hardy::HardyConnection::Establish() () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#27 0x00007f9bd9a4e6c4 in Simba::Hardy::HardyConnection::HandleConnect(std::map<Simba::Support::simba_wstring, Simba::Support::Variant, Simba::Support::simba_wstring::CaseInsensitiveComparator, std::allocator<std::pair<Simba::Support::simba_wstring const, Simba::Support::Variant> > > const&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#28 0x00007f9bda820cee in Simba::DriverSupport::DSCommonConnection::Connect(std::map<Simba::Support::simba_wstring, Simba::Support::Variant, Simba::Support::simba_wstring::CaseInsensitiveComparator, std::allocator<std::pair<Simba::Support::simba_wstring const, Simba::Support::Variant> > > const&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#29 0x00007f9bd9d68470 in Simba::ODBC::Connection::CompleteConnection(Simba::ODBC::ConnectionSettings&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#30 0x00007f9bd9d7c2f3 in Simba::ODBC::ConnectionState2::SQLConnectW(Simba::ODBC::Connection*, wchar_t*, short, wchar_t*, short, wchar_t*, short) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#31 0x00007f9bd9d6ffc5 in Simba::ODBC::Connection::SQLConnectW(wchar_t*, short, wchar_t*, short, wchar_t*, short) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#32 0x00007f9bd9d11ca4 in Simba::ODBC::SQLConnectTask<true>::DoSynchronously(Simba::ODBC::Connection&, Simba::ODBC::SQLConnectTask<true>::TaskParameters const&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#33 0x00007f9bd9d6490c in short DoTask<Simba::ODBC::SQLConnectTask<true> >(char const*, void*, Simba::ODBC::SQLConnectTask<true>::TaskParameters&) () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#34 0x00007f9bd9d27c48 in SQLConnectW () from /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
#35 0x00007f9be0bd0344 in ?? () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#36 0x00007f9be0bcfbf9 in ?? () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#37 0x00007f9be0bcfffc in ?? () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#38 0x00007f9be0bb8fa3 in SQLConnectA () from /opt/informatica/Informatica/10.1/ODBC7.1/lib/libodbc.so
#39 0x00007f9be0de9d66 in TODBCDb::Connect(PmUString const&, PmUString const&, PmUString const&, short) () from /opt/informatica/Informatica/10.1/server/bin/libpmodbc.so
#40 0x00007f9c08fcf187 in TDatabase::ConnectImpl(PmUString const&, PmUString const&, PmUString const&, short) () from /opt/informatica/Informatica/10.1/server/bin/libpmodl.so
#41 0x00007f9c08fcf8eb in TDatabase::Connect(PmUString const&, PmUString const&, PmUString const&, short, int) () from /opt/informatica/Informatica/10.1/server/bin/libpmodl.so
#42 0x00007f9bf81a58e8 in relReader::connect(int) () from /opt/informatica/Informatica/10.1/server/bin/libpmrelrdr.so
#43 0x00007f9bf81a90d3 in relReader::Connect() () from /opt/informatica/Informatica/10.1/server/bin/libpmrelrdr.so
#44 0x00000000007a73e2 in frame_blkReader::init() ()
#45 0x00000000007a773d in SReaderRunnable::handleRequest(SManagerRequest const&) ()
#46 0x00000000006268a2 in SWorker::run() ()
#47 0x0000000000601fe1 in SDTMRunnable::MainEntryPoint() ()
#48 0x00007f9c0e45efea in runit(void*) () from /opt/informatica/Informatica/10.1/server/bin/libpmcef.so
#49 0x0000003701207aa1 in start_thread () from /lib64/libpthread.so.0
#50 0x0000003700ee8bdd in clone () from /lib64/libc.so.6
(gdb)  
Pmstack completed successfully

 

We use CA signed certificates.

 

The JDBC was meant to be more of a reference to what our Hive connection string looks like for some other applications. I was most curious about the trustStorePassword because we don't have something analogous to it in the driver setup.

 

Certificate is located in the home directory of the admin user. I did see another certificate file at /opt/cloudera/hiveodbc/lib/64 but it is not being used.

 

Thank you!

Aaron

Highlighted

Re: Informatica ODBC Setup with SSL

Guru
Hi Aaron,

This is not the log file that I was after. Can you add:

LogPath=/path/to/dir
LogLevel=6

Into ODBC driver configuration file and test again? Then the trace logs for the driver should be logged under /path/to/dir and see what error we can get from there.

Cheers

Re: Informatica ODBC Setup with SSL

New Contributor

Hey Eric,

 

Appreciate all the help with this one. I'm circling back on this one before I forget. I figured out the issue which was related to the driver.

 

We use RHEL 6 on the server that we were trying to set this up on. OpenSSL driver was built into library dependencies so we kept getting connection errors no matter which tweaks we tried. We actually discovered that OpenSSL was built into the dependencies of the driver libraries too. Rolling back to a version from like 6 months ago worked like a charm.

 

Pasting a snippet from an email I sent detailing this in case it helps someone in the future. I used web.archive.org to view old release notes and determined which version was most compatible with our OpenSSL driver. Anyone using Informatica/Redhat that has issues, might be best to start looking there first.

 

"According to this page our openSSL version is 4 years old: https://web.archive.org/web/20150120120428/https://www.openssl.org/news/openssl-1.0.1-notes.html

 

Another archived page with old connector release notes, 2.5.17 shows an upgrade to OpenSSL past our version. Use 2.5.16 for testing.

https://web.archive.org/web/20160508220024/http://www.cloudera.com/documentation/other/connectors/hi...

 

            Version 2.5.17

            Upgraded OpenSSL library

                        The driver now uses OpenSSL 1.0.1l. Previously, the driver used OpenSSL 1.0.0q."

 

Re: Informatica ODBC Setup with SSL

Guru
@aohl,

Thanks for sharing the details about your resolution on the issue. I am glad that it has been resolved and sure others will benefit from your findings here.

Cheers
Eric
Don't have an account?
Coming from Hortonworks? Activate your account here