Reset configuration parameter, EnableSSL
Hello,
it seems like vertica (8.0) doesn't handle EC certificates which I agree is a small oversight from my side but I would never suspect this will result in the following:
Right now I'm gettin an error:
2016-11-28 09:27:31.005 Spread Client:0x927f4b0 <WARNING> @v_vertica_db_node0001: VX001/6705: Could not create SSL RSA: error:0906D06C:PEM routines:PEM_read_bio:no start line
2016-11-28 09:27:31.005 Spread Client:0x927f4b0 <PANIC> @v_vertica_db_node0001: VX001/3380: Failed to initialize SSL
LOCATION: doInstallAndJoin, /scratch_a/release/svrtar5373/vbuild/vertica/Transaction/TransAPI.cpp:2872
which then does not allow me to bring the instance up. This also means I'm not able to disable it, in order to bring the instance back up again and later on try a RSA cert. This is kind of a ridiculous situation for me, that you can not easily revert a configuration option which may basically brick your instance. I had no history retention so I dont think i can rollback to last epoch (?). I took a wildguess and tried editing manually both vertica.conf and config.cat from catalog but that didn't do the trick either.
In case, im attaching errorreport stacktrace
BEGIN BACKTRACE
Vertica Backtrace at Mon Nov 28 09:27:31 2016
-------------------------
Vertica Analytic Database v8.0.0-0 $BrandId$
vertica(v8.0.0-0) built by jeeves@build-centos6 from tag@releases/VER_8_0_RELEASE_BUILD_0_0_20160819 on 'Fri Aug 19 16:15:45 2016' $BuildId$
00400000-04e5a000 r-xp 00000000 fd:00 400192 /opt/vertica/bin/vertica
04e5a000-077d9000 rw-p 04a59000 fd:00 400192 /opt/vertica/bin/vertica
077d9000-0790e000 rw-p 00000000 00:00 0
086dc000-08c3c000 rw-p 00000000 00:00 0 [heap]
7fb68d7c9000-7fb68dbf2000 r--p 00000000 fd:00 526079 /usr/lib/locale/locale-archive
7fb68dbf2000-7fb68eb37000 r--s 00000000 fd:00 400374 /opt/vertica/share/icu/icudt42l.dat
7fb68eb37000-7fb68eb42000 r-xp 00000000 fd:00 738 /lib/x86_64-linux-gnu/libnss_files-2.19.so
7fb68eb42000-7fb68ed41000 ---p 0000b000 fd:00 738 /lib/x86_64-linux-gnu/libnss_files-2.19.so
7fb68ed41000-7fb68ed42000 r--p 0000a000 fd:00 738 /lib/x86_64-linux-gnu/libnss_files-2.19.so
7fb68ed42000-7fb68ed43000 rw-p 0000b000 fd:00 738 /lib/x86_64-linux-gnu/libnss_files-2.19.so
7fb68ed43000-7fb68ed4d000 r-xp 00000000 fd:00 740 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
7fb68ed4d000-7fb68ef4c000 ---p 0000a000 fd:00 740 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
7fb68ef4c000-7fb68ef4d000 r--p 00009000 fd:00 740 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
7fb68ef4d000-7fb68ef4e000 rw-p 0000a000 fd:00 740 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
7fb68ef4e000-7fb68ef63000 r-xp 00000000 fd:00 733 /lib/x86_64-linux-gnu/libnsl-2.19.so
7fb68ef63000-7fb68f162000 ---p 00015000 fd:00 733 /lib/x86_64-linux-gnu/libnsl-2.19.so
7fb68f162000-7fb68f163000 r--p 00014000 fd:00 733 /lib/x86_64-linux-gnu/libnsl-2.19.so
7fb68f163000-7fb68f164000 rw-p 00015000 fd:00 733 /lib/x86_64-linux-gnu/libnsl-2.19.so
7fb68f164000-7fb68f166000 rw-p 00000000 00:00 0
7fb68f166000-7fb68f16d000 r-xp 00000000 fd:00 736 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
7fb68f16d000-7fb68f36c000 ---p 00007000 fd:00 736 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
7fb68f36c000-7fb68f36d000 r--p 00006000 fd:00 736 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
7fb68f36d000-7fb68f36e000 rw-p 00007000 fd:00 736 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
7fb68f36e000-7fb68f770000 rw-p 00000000 00:00 0
7fb68f770000-7fb69f910000 rw-p 00000000 00:00 0
7fb69f910000-7fb69fb18000 rw-p 00000000 00:00 0
7fb69fb18000-7fb69fb32000 r-xp 00000000 fd:00 3802 /lib/x86_64-linux-gnu/libz.so.1.2.8
7fb69fb32000-7fb69fd31000 ---p 0001a000 fd:00 3802 /lib/x86_64-linux-gnu/libz.so.1.2.8
7fb69fd31000-7fb69fd32000 r--p 00019000 fd:00 3802 /lib/x86_64-linux-gnu/libz.so.1.2.8
7fb69fd32000-7fb69fd33000 rw-p 0001a000 fd:00 3802 /lib/x86_64-linux-gnu/libz.so.1.2.8
7fb69fd33000-7fb69fd36000 r-xp 00000000 fd:00 876 /lib/x86_64-linux-gnu/libcom_err.so.2.1
7fb69fd36000-7fb69ff35000 ---p 00003000 fd:00 876 /lib/x86_64-linux-gnu/libcom_err.so.2.1
7fb69ff35000-7fb69ff36000 r--p 00002000 fd:00 876 /lib/x86_64-linux-gnu/libcom_err.so.2.1
7fb69ff36000-7fb69ff37000 rw-p 00003000 fd:00 876 /lib/x86_64-linux-gnu/libcom_err.so.2.1
7fb69ff37000-7fb69ff38000 rw-p 00000000 00:00 0
7fb69ff38000-7fb69ff4c000 r-xp 00000000 fd:00 743 /lib/x86_64-linux-gnu/libresolv-2.19.so
7fb69ff4c000-7fb6a014b000 ---p 00014000 fd:00 743 /lib/x86_64-linux-gnu/libresolv-2.19.so
7fb6a014b000-7fb6a014c000 r--p 00013000 fd:00 743 /lib/x86_64-linux-gnu/libresolv-2.19.so
7fb6a014c000-7fb6a014d000 rw-p 00014000 fd:00 743 /lib/x86_64-linux-gnu/libresolv-2.19.so
7fb6a014d000-7fb6a014f000 rw-p 00000000 00:00 0
7fb6a014f000-7fb6a0152000 r-xp 00000000 fd:00 3687 /lib/x86_64-linux-gnu/libkeyutils.so.1.5
7fb6a0152000-7fb6a0351000 ---p 00003000 fd:00 3687 /lib/x86_64-linux-gnu/libkeyutils.so.1.5
7fb6a0351000-7fb6a0352000 r--p 00002000 fd:00 3687 /lib/x86_64-linux-gnu/libkeyutils.so.1.5
7fb6a0352000-7fb6a0353000 rw-p 00003000 fd:00 3687 /lib/x86_64-linux-gnu/libkeyutils.so.1.5
7fb6a0353000-7fb6a0369000 r-xp 00000000 fd:00 3774 /lib/x86_64-linux-gnu/libgcc_s.so.1
7fb6a0369000-7fb6a0568000 ---p 00016000 fd:00 3774 /lib/x86_64-linux-gnu/libgcc_s.so.1
7fb6a0568000-7fb6a0569000 rw-p 00015000 fd:00 3774 /lib/x86_64-linux-gnu/libgcc_s.so.1
7fb6a0569000-7fb6a0581000 r-xp 00000000 fd:00 721 /lib/x86_64-linux-gnu/libpthread-2.19.so
7fb6a0581000-7fb6a0780000 ---p 00018000 fd:00 721 /lib/x86_64-linux-gnu/libpthread-2.19.so
7fb6a0780000-7fb6a0781000 r--p 00017000 fd:00 721 /lib/x86_64-linux-gnu/libpthread-2.19.so
7fb6a0781000-7fb6a0782000 rw-p 00018000 fd:00 721 /lib/x86_64-linux-gnu/libpthread-2.19.so
7fb6a0782000-7fb6a0786000 rw-p 00000000 00:00 0
7fb6a0786000-7fb6a0789000 r-xp 00000000 fd:00 730 /lib/x86_64-linux-gnu/libdl-2.19.so
7fb6a0789000-7fb6a0988000 ---p 00003000 fd:00 730 /lib/x86_64-linux-gnu/libdl-2.19.so
7fb6a0988000-7fb6a0989000 r--p 00002000 fd:00 730 /lib/x86_64-linux-gnu/libdl-2.19.so
7fb6a0989000-7fb6a098a000 rw-p 00003000 fd:00 730 /lib/x86_64-linux-gnu/libdl-2.19.so
7fb6a098a000-7fb6a0b2b000 r-xp 00000000 fd:00 726 /lib/x86_64-linux-gnu/libc-2.19.so
7fb6a0b2b000-7fb6a0d2b000 ---p 001a1000 fd:00 726 /lib/x86_64-linux-gnu/libc-2.19.so
7fb6a0d2b000-7fb6a0d2f000 r--p 001a1000 fd:00 726 /lib/x86_64-linux-gnu/libc-2.19.so
7fb6a0d2f000-7fb6a0d31000 rw-p 001a5000 fd:00 726 /lib/x86_64-linux-gnu/libc-2.19.so
7fb6a0d31000-7fb6a0d35000 rw-p 00000000 00:00 0
7fb6a0d35000-7fb6a0d3c000 r-xp 00000000 fd:00 744 /lib/x86_64-linux-gnu/librt-2.19.so
7fb6a0d3c000-7fb6a0f3b000 ---p 00007000 fd:00 744 /lib/x86_64-linux-gnu/librt-2.19.so
7fb6a0f3b000-7fb6a0f3c000 r--p 00006000 fd:00 744 /lib/x86_64-linux-gnu/librt-2.19.so
7fb6a0f3c000-7fb6a0f3d000 rw-p 00007000 fd:00 744 /lib/x86_64-linux-gnu/librt-2.19.so
7fb6a0f3d000-7fb6a1029000 r-xp 00000000 fd:00 404380 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
7fb6a1029000-7fb6a1229000 ---p 000ec000 fd:00 404380 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
7fb6a1229000-7fb6a1231000 r--p 000ec000 fd:00 404380 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
7fb6a1231000-7fb6a1233000 rw-p 000f4000 fd:00 404380 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
7fb6a1233000-7fb6a1248000 rw-p 00000000 00:00 0
7fb6a1248000-7fb6a1348000 r-xp 00000000 fd:00 731 /lib/x86_64-linux-gnu/libm-2.19.so
7fb6a1348000-7fb6a1547000 ---p 00100000 fd:00 731 /lib/x86_64-linux-gnu/libm-2.19.so
7fb6a1547000-7fb6a1548000 r--p 000ff000 fd:00 731 /lib/x86_64-linux-gnu/libm-2.19.so
7fb6a1548000-7fb6a1549000 rw-p 00100000 fd:00 731 /lib/x86_64-linux-gnu/libm-2.19.so
7fb6a1549000-7fb6a15ab000 r-xp 00000000 fd:00 539215 /opt/vertica/lib/libssl.so.1.0.1e
7fb6a15ab000-7fb6a17aa000 ---p 00062000 fd:00 539215 /opt/vertica/lib/libssl.so.1.0.1e
7fb6a17aa000-7fb6a17ae000 r--p 00061000 fd:00 539215 /opt/vertica/lib/libssl.so.1.0.1e
7fb6a17ae000-7fb6a17b5000 rw-p 00065000 fd:00 539215 /opt/vertica/lib/libssl.so.1.0.1e
7fb6a17b5000-7fb6a196d000 r-xp 00000000 fd:00 539211 /opt/vertica/lib/libcrypto.so.1.0.1e
7fb6a196d000-7fb6a1b6d000 ---p 001b8000 fd:00 539211 /opt/vertica/lib/libcrypto.so.1.0.1e
7fb6a1b6d000-7fb6a1b88000 r--p 001b8000 fd:00 539211 /opt/vertica/lib/libcrypto.so.1.0.1e
7fb6a1b88000-7fb6a1b94000 rw-p 001d3000 fd:00 539211 /opt/vertica/lib/libcrypto.so.1.0.1e
7fb6a1b94000-7fb6a1b98000 rw-p 00000000 00:00 0
7fb6a1b98000-7fb6a1d3d000 r-xp 00000000 fd:00 539213 /opt/vertica/lib/libAutopassCrypto64.so
7fb6a1d3d000-7fb6a1d51000 rw-p 001a4000 fd:00 539213 /opt/vertica/lib/libAutopassCrypto64.so
7fb6a1d51000-7fb6a1d71000 r-xp 00000000 fd:00 722 /lib/x86_64-linux-gnu/ld-2.19.so
7fb6a1d71000-7fb6a1d74000 rw-p 00000000 00:00 0
7fb6a1d7a000-7fb6a1d7b000 rw-p 00000000 00:00 0
7fb6a1d7b000-7fb6a1daf000 r-xp 00000000 fd:00 539231 /opt/vertica/lib/libidn.so.11.6.15
7fb6a1daf000-7fb6a1db1000 rw-p 00033000 fd:00 539231 /opt/vertica/lib/libidn.so.11.6.15
7fb6a1db1000-7fb6a1dca000 r-xp 00000000 fd:00 539230 /opt/vertica/lib/libgsasl.so.7.9.6
7fb6a1dca000-7fb6a1dcc000 rw-p 00019000 fd:00 539230 /opt/vertica/lib/libgsasl.so.7.9.6
7fb6a1dcc000-7fb6a1dcd000 rw-p 00000000 00:00 0
7fb6a1dcd000-7fb6a1dd0000 r-xp 00000000 fd:00 538395 /opt/vertica/lib/libcom_err.so.3.0
7fb6a1dd0000-7fb6a1dd1000 rw-p 00002000 fd:00 538395 /opt/vertica/lib/libcom_err.so.3.0
7fb6a1dd1000-7fb6a1e13000 r-xp 00000000 fd:00 539229 /opt/vertica/lib/libk5crypto.so.3.1
7fb6a1e13000-7fb6a1e15000 rw-p 00042000 fd:00 539229 /opt/vertica/lib/libk5crypto.so.3.1
7fb6a1e15000-7fb6a1e16000 rw-p 00000000 00:00 0
7fb6a1e16000-7fb6a1e23000 r-xp 00000000 fd:00 539212 /opt/vertica/lib/libkrb5support.so.0.1
7fb6a1e23000-7fb6a1e24000 rw-p 0000c000 fd:00 539212 /opt/vertica/lib/libkrb5support.so.0.1
7fb6a1e24000-7fb6a1e25000 rw-p 00000000 00:00 0
7fb6a1e25000-7fb6a1f06000 r-xp 00000000 fd:00 539214 /opt/vertica/lib/libkrb5.so.3.3
7fb6a1f06000-7fb6a1f16000 rw-p 000e1000 fd:00 539214 /opt/vertica/lib/libkrb5.so.3.3
7fb6a1f16000-7fb6a1f6c000 r-xp 00000000 fd:00 539210 /opt/vertica/lib/libgssapi_krb5.so.2.2
7fb6a1f6c000-7fb6a1f6f000 rw-p 00056000 fd:00 539210 /opt/vertica/lib/libgssapi_krb5.so.2.2
7fb6a1f6f000-7fb6a1f71000 rw-p 00000000 00:00 0
7fb6a1f71000-7fb6a1f72000 r--p 00020000 fd:00 722 /lib/x86_64-linux-gnu/ld-2.19.so
7fb6a1f72000-7fb6a1f73000 rw-p 00021000 fd:00 722 /lib/x86_64-linux-gnu/ld-2.19.so
7fb6a1f73000-7fb6a1f74000 rw-p 00000000 00:00 0
7ffff42bb000-7ffff42dc000 rw-p 00000000 00:00 0 [stack]
7ffff4344000-7ffff4346000 r--p 00000000 00:00 0 [vvar]
7ffff4346000-7ffff4348000 r-xp 00000000 00:00 0 [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
Backtrace Requested
(_ZN6Basics9Backtrace11DoBacktraceEiiPvS1_+0x89b) [0x331ca6b]
(_ZN6Basics20GlobalSignalHandlers20logBacktraceFromHereEb+0xc7) [0x3369e19]
(errthrow+0x43) [0x29ad077]
(_ZN3TXN8TransAPI16doInstallAndJoinERN3CAT14CatalogContentExRNS1_18TransactionContentES5_+0x987) [0x25bdb79]
(_ZN4Dist18FormClusterMessage10invokeVoidEv+0x183) [0x72f3b3]
(_ZN4Dist11DistMessage6invokeEv+0x14) [0x67cff0]
(_ZN4Dist9DistCalls27dispatchIncomingCallMessageERNS_14CallWireFormatERN6Basics10ByteBufferEPb+0xfc5) [0x5de5c3]
(_ZN4Dist9DistCalls15messageReceivedESsRN6Basics10ByteBufferEx+0x36bc) [0x667a64]
(_ZN4Dist7VSpread21processDistCallPacketEiSsSs+0x66c) [0x58a3e8]
(_ZN4Dist7VSpread20handleRegularMessageEsi+0x4d6) [0x59924c]
(_ZN4Dist7VSpread11readMessageEv+0x7f3) [0x59b0c1]
(_ZN4Dist7VSpread13staticDequeueEv+0xe3) [0x5a0b9f]
(_ZN7Session13ThreadManager12launchThreadERKN5boost9function0IvEE+0x58) [0x31943c6]
(thread_proxy+0x72) [0x37684b2]
(start_thread+0xc4) [0x7fb6a05710a4]
(clone+0x6d) [0x7fb6a0a7262d]
END BACKTRACE
THREAD CONTEXT
Thread type: Spread Thread
Request: Unknown request
END THREAD CONTEXT
0