Post core dumps with below error in event_log when using sslmode=allow in odbc.ini file for connection to target Aurora PostgreSQL
xpst 2018-03-23 19:24:59.031916 8259 2701912000 error_code=101 state=08001 msg=[unixODBC]FATAL: no pg_hba.conf entry for host "xx.xxx.xx.xxx", user "splex_pg", database "rmdev1", SSL off
xpst 2018-03-23 19:24:59.031916 8259 2701912000
xpst 2018-03-23 19:24:59.031923 8259 2701912000 error_code=101 state=08001 msg=[unixODBC]FATAL: no pg_hba.conf entry for host "xx.xxx.xx.xxx", user "splex_pg", database "rmdev1", SSL off
xpst 2018-03-23 19:24:59.031923 8259 2701912000
xpst 2018-03-23 19:24:59.033480 8259 2701912000 [SP-OPX01010] SharePlex can not login to the target database.
If using sslmode=verify-ca, post may core dump with below core.out
Program terminated with signal 11, Segmentation fault.
#0 0x0000003628d19940 in X509_NAME_cmp () from /usr/lib64/libcrypto.so.10
warning: File "/u01/xxx/prod91/lib/libstdc++.so.6.0.16-gdb.py" auto-loading has been declined by your `auto-load safe-path' set to "/usr/share/gdb/auto-load:/usr/lib/debug:/usr/bin/mono-gdb.py".
To enable execution of this file add
add-auto-load-safe-path /u01/xxx/prod91/lib/libstdc++.so.6.0.16-gdb.py
line to your configuration file "/u01/PostgresPlus/9.4AS/.gdbinit".
To completely disable this security protection add
set auto-load safe-path /
line to your configuration file "/u01/PostgresPlus/9.4AS/.gdbinit".
For more information about this security protection see the
"Auto-loading safe path" section in the GDB manual. E.g., run from the shell:
info "(gdb)Auto-loading safe path"
#0 0x0000003628d19940 in X509_NAME_cmp () from /usr/lib64/libcrypto.so.10
#1 0x0000003628d2ba87 in X509_check_issued () from /usr/lib64/libcrypto.so.10
#2 0x0000003628d1b384 in ?? () from /usr/lib64/libcrypto.so.10
#3 0x0000003628d1abf2 in ?? () from /usr/lib64/libcrypto.so.10
#4 0x0000003628d1cbb1 in X509_verify_cert () from /usr/lib64/libcrypto.so.10
#5 0x000000362c445e48 in ssl_verify_cert_chain () from /usr/lib64/libssl.so.10
#6 0x000000362c4250d3 in ssl3_get_server_certificate () from /usr/lib64/libssl.so.10
#7 0x000000362c427702 in ssl3_connect () from /usr/lib64/libssl.so.10
#8 0x000000362c430477 in ssl23_connect () from /usr/lib64/libssl.so.10
#9 0x00007fb294d6f9ec in ?? () from /usr/pgsql-9.5/lib/libpq.so.5
#10 0x00007fb294d5b968 in PQconnectPoll () from /usr/pgsql-9.5/lib/libpq.so.5
#11 0x00007fb294d5c35e in ?? () from /usr/pgsql-9.5/lib/libpq.so.5
#12 0x00007fb294d5d09f in PQconnectdbParams () from /usr/pgsql-9.5/lib/libpq.so.5
#13 0x00007fb294fa0912 in ?? () from /usr/pgsql-9.5/lib/psqlodbc.so
#14 0x00007fb294fa3c89 in ?? () from /usr/pgsql-9.5/lib/psqlodbc.so
#15 0x00007fb294fae1f9 in ?? () from /usr/pgsql-9.5/lib/psqlodbc.so
#16 0x00007fb294fd6538 in SQLDriverConnect () from /usr/pgsql-9.5/lib/psqlodbc.so
#17 0x00007fb29b450bd0 in SQLDriverConnect () from /u01/jess/prod91/lib/libodbc.so.2
#18 0x00000000004dab9c in OdbcDriver::connect (this=0x2a96ac0) at ../src/xpst/odbc/OdbcDriver.cpp:263
#19 0x00000000004db68a in OdbcDriver::OdbcDriver (this=0x2a96ac0, connect_str=<value optimized out>, user_name=..., db_name=..., output_message=false, __in_chrg=<value optimized out>, __vtt_parm=<value optimized out>) at ../src/xpst/odbc/OdbcDriver.cpp:153
#20 0x0000000000453294 in getOdbcTarget (thread=1) at ../src/xpst/open_post.cpp:1284
#21 0x00000000004574fd in main_loop (que=...) at ../src/xpst/open_post.cpp:1450
#22 0x00000000004595d2 in run (argc=<value optimized out>, argv=<value optimized out>) at ../src/xpst/open_post.cpp:1641
#23 0x000000000044fd2c in main (argc=2, argv=0x7fff380d84f8) at ../src/xpst/sp_xpst.cpp:42
=============> End of stack trace <=============
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center