View Revisions: Issue #4410

Back to Issue
Summary 0004410: "Reconnect" to database for SymmetricDS installation fails with security exception
Revision 2020-06-01 13:21 by pmarzullo
Description When replacing a symmetric installation in a database, there is a security exception:

2020-06-01 09:17:35,535 ERROR [server] [AbstractSymmetricEngine] [qtp238357312-18] An error occurred while starting SymmetricDS StackTraceKey.init [RuntimeException:957202463]
java.lang.RuntimeException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
        at org.jumpmind.security.SecurityService.decrypt(SecurityService.java:168) ~[symmetric-util-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.security.NodePasswordFilter.onNodeSecurityRender(NodePasswordFilter.java:22) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.filterPasswordOnRenderIfNeeded(NodeService.java:769) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.access$000(NodeService.java:60) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService$NodeSecurityRowMapper.mapRow(NodeService.java:903) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService$NodeSecurityRowMapper.mapRow(NodeService.java:899) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:139) ~[symmetric-jdbc-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:209) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:189) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.findNodeSecurity(NodeService.java:474) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.findNodeSecurity(NodeService.java:466) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1257) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1226) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1222) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.DatabaseUpgradeListener.afterUpgrade(DatabaseUpgradeListener.java:231) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:523) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:160) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:513) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:487) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:657) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:646) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:277) ~[symmetric-client-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:435) ~[symmetric-server-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dM.q(SymmetricDetectedScreen.java:144) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dH.c(NodeSetupWizard.java:285) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dM$2.buttonClick(SymmetricDetectedScreen.java:59) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
        at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:499) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:273) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:237) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1014) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.ui.Button.fireClick(Button.java:384) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.ui.Button$1.click(Button.java:57) ~[vaadin-server-8.10.0.jar:8.10.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
        at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:116) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:445) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:410) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:148) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:248) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:534) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) [vaadin-server-8.10.0.jar:8.10.0]
        at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:225) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:114) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2297) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:594) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:448) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
Last login: Fri May 29 10:57:24 on ttys003
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage setextradata "Linux - Ingres" "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" 1
philipmarzullo@MacBook-Pro-3 ~ % ps -ef | fgrep java
  501 63374 63367 0 Thu02PM ?? 302:47.79 /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java -cp /Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/squirrel-sql.jar:/Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/lib/* -Dapple.laf.useScreenMenuBar=true -Dcom.apple.mrj.application.apple.menu.about.name=SQuirreLSQL -Dapple.awt.application.name=SQuirreLSQL -splash:/Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/icons/splash.jpg net.sourceforge.squirrel_sql.client.Main --log-config-file /Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/log4j.properties --squirrel-home /Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java --native-laf
  501 94097 94031 0 7:07AM ttys004 0:00.00 fgrep java
philipmarzullo@MacBook-Pro-3 ~ % kill 63374
philipmarzullo@MacBook-Pro-3 ~ % sudo VBoxManage setextradata "Linux - Ingres" "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" 1
Password:
VBoxManage: error: Could not find a registered machine named 'Linux - Ingres'
VBoxManage: error: Details: code VBOX_E_OBJECT_NOT_FOUND (0x80bb0001), component VirtualBoxWrap, interface IVirtualBox, callee nsISupports
VBoxManage: error: Context: "FindMachine(Bstr(a->argv[0]).raw(), machine.asOutParam())" at line 935 of file VBoxManageMisc.cpp
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage -?
zsh: no matches found: -?
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage
Oracle VM VirtualBox Command Line Management Interface Version 6.0.20
(C) 2005-2020 Oracle Corporation
All rights reserved.

Usage:

  VBoxManage [<general option>] <command>
 
 
General Options:
 
  [-v|--version] print version number and exit
  [-q|--nologo] suppress the logo
  [--settingspw <pw>] provide the settings password
  [--settingspwfile <file>] provide a file containing the settings password
  [@<response-file>] load arguments from the given response file (bourne style)
 
 
Commands:
 
  list [--long|-l] [--sorted|-s] vms|runningvms|ostypes|hostdvds|hostfloppies|
                            intnets|bridgedifs|hostonlyifs|natnets|dhcpservers|
                            hostinfo|hostcpuids|hddbackends|hdds|dvds|floppies|
                            usbhost|usbfilters|systemproperties|extpacks|
                            groups|webcams|screenshotformats|cloudproviders|
                            cloudprofiles

  showvminfo <uuid|vmname> [--details]
                            [--machinereadable]
  showvminfo <uuid|vmname> --log <idx>

  registervm <filename>

  unregistervm <uuid|vmname> [--delete]

  createvm --name <name>
                            [--groups <group>, ...]
                            [--ostype <ostype>]
                            [--register]
                            [--basefolder <path>]
                            [--uuid <uuid>]
                            [--default]

  modifyvm <uuid|vmname>
                            [--name <name>]
                            [--groups <group>, ...]
                            [--description <desc>]
                            [--ostype <ostype>]
                            [--iconfile <filename>]
                            [--memory <memorysize in MB>]
                            [--pagefusion on|off]
                            [--vram <vramsize in MB>]
                            [--acpi on|off]
                            [--pciattach 03:04.0]
                            [--pciattach 03:04.0@02:01.0]
                            [--pcidetach 03:04.0]
                            [--ioapic on|off]
                            [--hpet on|off]
                            [--triplefaultreset on|off]
                            [--apic on|off]
                            [--x2apic on|off]
                            [--paravirtprovider none|default|legacy|minimal|
                                                hyperv|kvm]
                            [--paravirtdebug <key=value> [,<key=value> ...]]
                            [--hwvirtex on|off]
                            [--nestedpaging on|off]
                            [--largepages on|off]
                            [--vtxvpid on|off]
                            [--vtxux on|off]
                            [--pae on|off]
                            [--longmode on|off]
                            [--ibpb-on-vm-exit on|off]
                            [--ibpb-on-vm-entry on|off]
                            [--spec-ctrl on|off]
                            [--l1d-flush-on-sched on|off]
                            [--l1d-flush-on-vm-entry on|off]
                            [--mds-clear-on-sched on|off]
                            [--mds-clear-on-vm-entry on|off]
                            [--nested-hw-virt on|off]
                            [--cpu-profile "host|Intel 80[86|286|386]"]
                            [--cpuid-portability-level <0..3>
                            [--cpuid-set <leaf[:subleaf]> <eax> <ebx> <ecx> <edx>]
                            [--cpuid-remove <leaf[:subleaf]>]
                            [--cpuidremoveall]
                            [--hardwareuuid <uuid>]
                            [--cpus <number>]
                            [--cpuhotplug on|off]
                            [--plugcpu <id>]
                            [--unplugcpu <id>]
                            [--cpuexecutioncap <1-100>]
                            [--rtcuseutc on|off]
                            [--graphicscontroller none|vboxvga|vmsvga|vboxsvga]
                            [--monitorcount <number>]
                            [--accelerate3d on|off]
                            [--accelerate2dvideo on|off]
                            [--firmware bios|efi|efi32|efi64]
                            [--chipset ich9|piix3]
                            [--bioslogofadein on|off]
                            [--bioslogofadeout on|off]
                            [--bioslogodisplaytime <msec>]
                            [--bioslogoimagepath <imagepath>]
                            [--biosbootmenu disabled|menuonly|messageandmenu]
                            [--biosapic disabled|apic|x2apic]
                            [--biossystemtimeoffset <msec>]
                            [--biospxedebug on|off]
                            [--boot<1-4> none|floppy|dvd|disk|net>]
                            [--nic<1-N> none|null|nat|bridged|intnet|hostonly|
                                        generic|natnetwork]
                            [--nictype<1-N> Am79C970A|Am79C973|
                                            82540EM|82543GC|82545EM|
                                            virtio]
                            [--cableconnected<1-N> on|off]
                            [--nictrace<1-N> on|off]
                            [--nictracefile<1-N> <filename>]
                            [--nicproperty<1-N> name=[value]]
                            [--nicspeed<1-N> <kbps>]
                            [--nicbootprio<1-N> <priority>]
                            [--nicpromisc<1-N> deny|allow-vms|allow-all]
                            [--nicbandwidthgroup<1-N> none|<name>]
                            [--bridgeadapter<1-N> none|<devicename>]
                            [--hostonlyadapter<1-N> none|<devicename>]
                            [--intnet<1-N> <network name>]
                            [--nat-network<1-N> <network name>]
                            [--nicgenericdrv<1-N> <driver>
                            [--natnet<1-N> <network>|default]
                            [--natsettings<1-N> [<mtu>],[<socksnd>],
                                                [<sockrcv>],[<tcpsnd>],
                                                [<tcprcv>]]
                            [--natpf<1-N> [<rulename>],tcp|udp,[<hostip>],
                                          <hostport>,[<guestip>],<guestport>]
                            [--natpf<1-N> delete <rulename>]
                            [--nattftpprefix<1-N> <prefix>]
                            [--nattftpfile<1-N> <file>]
                            [--nattftpserver<1-N> <ip>]
                            [--natbindip<1-N> <ip>
                            [--natdnspassdomain<1-N> on|off]
                            [--natdnsproxy<1-N> on|off]
                            [--natdnshostresolver<1-N> on|off]
                            [--nataliasmode<1-N> default|[log],[proxyonly],
                                                         [sameports]]
                            [--macaddress<1-N> auto|<mac>]
                            [--mouse ps2|usb|usbtablet|usbmultitouch]
                            [--keyboard ps2|usb
                            [--uart<1-N> off|<I/O base> <IRQ>]
                            [--uartmode<1-N> disconnected|
                                             server <pipe>|
                                             client <pipe>|
                                             tcpserver <port>|
                                             tcpclient <hostname:port>|
                                             file <file>|
                                             <devicename>]
                            [--uarttype<1-N> 16450|16550A|16750
                            [--guestmemoryballoon <balloonsize in MB>]
                            [--audio none|null|coreaudio]
                            [--audioin on|off]
                            [--audioout on|off]
                            [--audiocontroller ac97|hda|sb16]
                            [--audiocodec stac9700|ad1980|stac9221|sb16]
                            [--clipboard disabled|hosttoguest|guesttohost|
                                         bidirectional]
                            [--draganddrop disabled|hosttoguest|guesttohost|
                                         bidirectional]
                            [--vrde on|off]
                            [--vrdeextpack default|<name>
                            [--vrdeproperty <name=[value]>]
                            [--vrdeport <hostport>]
                            [--vrdeaddress <hostip>]
                            [--vrdeauthtype null|external|guest]
                            [--vrdeauthlibrary default|<name>
                            [--vrdemulticon on|off]
                            [--vrdereusecon on|off]
                            [--vrdevideochannel on|off]
                            [--vrdevideochannelquality <percent>]
                            [--usbohci on|off]
                            [--usbehci on|off]
                            [--usbxhci on|off]
                            [--usbrename <oldname> <newname>]
                            [--snapshotfolder default|<path>]
                            [--teleporter on|off]
                            [--teleporterport <port>]
                            [--teleporteraddress <address|empty>
                            [--teleporterpassword <password>]
                            [--teleporterpasswordfile <file>|stdin]
                            [--tracing-enabled on|off]
                            [--tracing-config <config-string>]
                            [--tracing-allow-vm-access on|off]
                            [--usbcardreader on|off]
                            [--autostart-enabled on|off]
                            [--autostart-delay <seconds>]
                            [--recording on|off]
                            [--recordingscreens all|<screen ID> [<screen ID> ...]]
                            [--recordingfile <filename>]
                            [--recordingvideores <width> <height>]
                            [--recordingvideorate <rate>]
                            [--recordingvideofps <fps>]
                            [--recordingmaxtime <s>]
                            [--recordingmaxsize <MB>]
                            [--recordingopts <key=value> [,<key=value> ...]]
                            [--defaultfrontend default|<name>]

  clonevm <uuid|vmname>
                            [--snapshot <uuid>|<name>]
                            [--mode machine|machineandchildren|all]
                            [--options link|keepallmacs|keepnatmacs|
                                       keepdisknames|keephwuuids]
                            [--name <name>]
                            [--groups <group>, ...]
                            [--basefolder <basefolder>]
                            [--uuid <uuid>]
                            [--register]

  movevm <uuid|vmname>
                            --type basic
                            [--folder <path>]

  import <ovfname/ovaname>
                            [--dry-run|-n]
                            [--options keepallmacs|keepnatmacs|importtovdi]
                            [more options]
                            (run with -n to have options displayed
                             for a particular OVF)

  export <machines> --output|-o <name>.<ovf/ova/tar.gz>
                            [--legacy09|--ovf09|--ovf10|--ovf20|--opc10]
                            [--manifest]
                            [--iso]
                            [--options manifest|iso|nomacs|nomacsbutnat]
                            [--vsys <number of virtual system>]
                                    [--vmname <name>]
                                    [--product <product name>]
                                    [--producturl <product url>]
                                    [--vendor <vendor name>]
                                    [--vendorurl <vendor url>]
                                    [--version <version info>]
                                    [--description <description info>]
                                    [--eula <license text>]
                                    [--eulafile <filename>]
                            [--cloud <number of virtual system>]
                                    [--vmname <name>]
                                    [--cloudprofile <cloud profile name>]
                                    [--cloudshape <shape>]
                                    [--clouddomain <domain>]
                                    [--clouddisksize <disk size in GB>]
                                    [--cloudbucket <bucket name>]
                                    [--cloudocivcn <OCI vcn id>]
                                    [--cloudocisubnet <OCI subnet id>]
                                    [--cloudkeepobject <true/false>]
                                    [--cloudlaunchinstance <true/false>]
                                    [--cloudpublicip <true/false>]

  startvm <uuid|vmname>...
                            [--type gui|headless|separate]
                            [-E|--putenv <NAME>[=<VALUE>]]

  controlvm <uuid|vmname>
                            pause|resume|reset|poweroff|savestate|
                            acpipowerbutton|acpisleepbutton|
                            keyboardputscancode <hex> [<hex> ...]|
                            keyboardputstring <string1> [<string2> ...]|
                            keyboardputfile <filename>|
                            setlinkstate<1-N> on|off |
                            nic<1-N> null|nat|bridged|intnet|hostonly|generic|
                                     natnetwork [<devicename>] |
                            nictrace<1-N> on|off |
                            nictracefile<1-N> <filename> |
                            nicproperty<1-N> name=[value] |
                            nicpromisc<1-N> deny|allow-vms|allow-all |
                            natpf<1-N> [<rulename>],tcp|udp,[<hostip>],
                                        <hostport>,[<guestip>],<guestport> |
                            natpf<1-N> delete <rulename> |
                            guestmemoryballoon <balloonsize in MB> |
                            usbattach <uuid>|<address>
                                      [--capturefile <filename>] |
                            usbdetach <uuid>|<address> |
                            audioin on|off |
                            audioout on|off |
                            clipboard disabled|hosttoguest|guesttohost|
                                      bidirectional |
                            draganddrop disabled|hosttoguest|guesttohost|
                                      bidirectional |
                            vrde on|off |
                            vrdeport <port> |
                            vrdeproperty <name=[value]> |
                            vrdevideochannelquality <percent> |
                            setvideomodehint <xres> <yres> <bpp>
                                            [[<display>] [<enabled:yes|no> |
                                              [<xorigin> <yorigin>]]] |
                            setscreenlayout <display> on|primary <xorigin> <yorigin> <xres> <yres> <bpp> | off
                            screenshotpng <file> [display] |
                            recording on|off |
                            recording screens all|none|<screen>,[<screen>...] |
                            recording filename <file> |
                            recording videores <width>x<height> |
                            recording videorate <rate> |
                            recording videofps <fps> |
                            recording maxtime <s> |
                            recording maxfilesize <MB> |
                            setcredentials <username>
                                           --passwordfile <file> | <password>
                                           <domain>
                                           [--allowlocallogon <yes|no>] |
                            teleport --host <name> --port <port>
                                     [--maxdowntime <msec>]
                                     [--passwordfile <file> |
                                      --password <password>] |
                            plugcpu <id> |
                            unplugcpu <id> |
                            cpuexecutioncap <1-100>
                            webcam <attach [path [settings]]> | <detach [path]> | <list>
                            addencpassword <id>
                                           <password file>|-
                                           [--removeonsuspend <yes|no>]
                            removeencpassword <id>
                            removeallencpasswords
                            changeuartmode<1-N> disconnected|
                                                server <pipe>|
                                                client <pipe>|
                                                tcpserver <port>|
                                                tcpclient <hostname:port>|
                                                file <file>|
                                                <devicename>]

  discardstate <uuid|vmname>

  adoptstate <uuid|vmname> <state_file>

  snapshot <uuid|vmname>
                            take <name> [--description <desc>] [--live]
                                 [--uniquename Number,Timestamp,Space,Force] |
                            delete <uuid|snapname> |
                            restore <uuid|snapname> |
                            restorecurrent |
                            edit <uuid|snapname>|--current
                                 [--name <name>]
                                 [--description <desc>] |
                            list [--details|--machinereadable] |
                            showvminfo <uuid|snapname>

  closemedium [disk|dvd|floppy] <uuid|filename>
                            [--delete]

  storageattach <uuid|vmname>
                            --storagectl <name>
                            [--port <number>]
                            [--device <number>]
                            [--type dvddrive|hdd|fdd]
                            [--medium none|emptydrive|additions|
                                      <uuid|filename>|host:<drive>|iscsi]
                            [--mtype normal|writethrough|immutable|shareable|
                                     readonly|multiattach]
                            [--comment <text>]
                            [--setuuid <uuid>]
                            [--setparentuuid <uuid>]
                            [--passthrough on|off]
                            [--tempeject on|off]
                            [--nonrotational on|off]
                            [--discard on|off]
                            [--hotpluggable on|off]
                            [--bandwidthgroup <name>]
                            [--forceunmount]
                            [--server <name>|<ip>]
                            [--target <target>]
                            [--tport <port>]
                            [--lun <lun>]
                            [--encodedlun <lun>]
                            [--username <username>]
                            [--password <password>]
                            [--passwordfile <file>]
                            [--initiator <initiator>]
                            [--intnet]

  storagectl <uuid|vmname>
                            --name <name>
                            [--add ide|sata|scsi|floppy|sas|usb|pcie]
                            [--controller LSILogic|LSILogicSAS|BusLogic|
                                          IntelAHCI|PIIX3|PIIX4|ICH6|I82078|
                            [ USB|NVMe]
                            [--portcount <1-n>]
                            [--hostiocache on|off]
                            [--bootable on|off]
                            [--rename <name>]
                            [--remove]

  bandwidthctl <uuid|vmname>
                            add <name> --type disk|network
                                --limit <megabytes per second>[k|m|g|K|M|G] |
                            set <name>
                                --limit <megabytes per second>[k|m|g|K|M|G] |
                            remove <name> |
                            list [--machinereadable]
                            (limit units: k=kilobit, m=megabit, g=gigabit,
                                          K=kilobyte, M=megabyte, G=gigabyte)

  showmediuminfo [disk|dvd|floppy] <uuid|filename>

  createmedium [disk|dvd|floppy] --filename <filename>
                            [--size <megabytes>|--sizebyte <bytes>]
                            [--diffparent <uuid>|<filename>
                            [--format VDI|VMDK|VHD] (default: VDI)
                            [--variant Standard,Fixed,Split2G,Stream,ESX,
                                       Formatted]

  modifymedium [disk|dvd|floppy] <uuid|filename>
                            [--type normal|writethrough|immutable|shareable|
                                    readonly|multiattach]
                            [--autoreset on|off]
                            [--property <name=[value]>]
                            [--compact]
                            [--resize <megabytes>|--resizebyte <bytes>]
                            [--move <path>]
                            [--setlocation <path>]
                            [--description <description string>]
  clonemedium [disk|dvd|floppy] <uuid|inputfile> <uuid|outputfile>
                            [--format VDI|VMDK|VHD|RAW|<other>]
                            [--variant Standard,Fixed,Split2G,Stream,ESX]
                            [--existing]

  mediumproperty [disk|dvd|floppy] set <uuid|filename>
                            <property> <value>

                            [disk|dvd|floppy] get <uuid|filename>
                            <property>

                            [disk|dvd|floppy] delete <uuid|filename>
                            <property>

  encryptmedium <uuid|filename>
                            [--newpassword <file>|-]
                            [--oldpassword <file>|-]
                            [--cipher <cipher identifier>]
                            [--newpasswordid <password identifier>]

  checkmediumpwd <uuid|filename>
                            <pwd file>|-

  convertfromraw <filename> <outputfile>
                            [--format VDI|VMDK|VHD]
                            [--variant Standard,Fixed,Split2G,Stream,ESX]
                            [--uuid <uuid>]
  convertfromraw stdin <outputfile> <bytes>
                            [--format VDI|VMDK|VHD]
                            [--variant Standard,Fixed,Split2G,Stream,ESX]
                            [--uuid <uuid>]

  getextradata global|<uuid|vmname>
                            <key>|[enumerate]

  setextradata global|<uuid|vmname>
                            <key>
                            [<value>] (no value deletes key)

  setproperty machinefolder default|<folder> |
                            hwvirtexclusive on|off |
                            vrdeauthlibrary default|<library> |
                            websrvauthlibrary default|null|<library> |
                            vrdeextpack null|<library> |
                            autostartdbpath null|<folder> |
                            loghistorycount <value>
                            defaultfrontend default|<name>
                            logginglevel <log setting>
                            proxymode system|noproxy|manual
                            proxyurl <url>

  usbfilter add <index,0-N>
                            --target <uuid|vmname>|global
                            --name <string>
                            --action ignore|hold (global filters only)
                            [--active yes|no] (yes)
                            [--vendorid <XXXX>] (null)
                            [--productid <XXXX>] (null)
                            [--revision <IIFF>] (null)
                            [--manufacturer <string>] (null)
                            [--product <string>] (null)
                            [--remote yes|no] (null, VM filters only)
                            [--serialnumber <string>] (null)
                            [--maskedinterfaces <XXXXXXXX>]

  usbfilter modify <index,0-N>
                            --target <uuid|vmname>|global
                            [--name <string>]
                            [--action ignore|hold] (global filters only)
                            [--active yes|no]
                            [--vendorid <XXXX>|""]
                            [--productid <XXXX>|""]
                            [--revision <IIFF>|""]
                            [--manufacturer <string>|""]
                            [--product <string>|""]
                            [--remote yes|no] (null, VM filters only)
                            [--serialnumber <string>|""]
                            [--maskedinterfaces <XXXXXXXX>]

  usbfilter remove <index,0-N>
                            --target <uuid|vmname>|global

  sharedfolder add <uuid|vmname>
                            --name <name> --hostpath <hostpath>
                            [--transient] [--readonly] [--automount]

  sharedfolder remove <uuid|vmname>
                            --name <name> [--transient]

  guestproperty get <uuid|vmname>
                            <property> [--verbose]

  guestproperty set <uuid|vmname>
                            <property> [<value> [--flags <flags>]]

  guestproperty delete|unset <uuid|vmname>
                            <property>

  guestproperty enumerate <uuid|vmname>
                            [--patterns <patterns>]

  guestproperty wait <uuid|vmname> <patterns>
                            [--timeout <msec>] [--fail-on-timeout]

  guestcontrol <uuid|vmname> [--verbose|-v] [--quiet|-q]
                              [--username <name>] [--domain <domain>]
                              [--passwordfile <file> | --password <password>]

                              run [common-options]
                              [--exe <path to executable>] [--timeout <msec>]
                              [-E|--putenv <NAME>[=<VALUE>]] [--unquoted-args]
                              [--ignore-operhaned-processes] [--profile]
                              [--no-wait-stdout|--wait-stdout]
                              [--no-wait-stderr|--wait-stderr]
                              [--dos2unix] [--unix2dos]
                              -- <program/arg0> [argument1] ... [argumentN]]

                              start [common-options]
                              [--exe <path to executable>] [--timeout <msec>]
                              [-E|--putenv <NAME>[=<VALUE>]] [--unquoted-args]
                              [--ignore-operhaned-processes] [--profile]
                              -- <program/arg0> [argument1] ... [argumentN]]

                              copyfrom [common-options]
                              [--follow] [-R|--recursive]
                              <guest-src0> [guest-src1 [...]] <host-dst>

                              copyfrom [common-options]
                              [--follow] [-R|--recursive]
                              [--target-directory <host-dst-dir>]
                              <guest-src0> [guest-src1 [...]]

                              copyto [common-options]
                              [--follow] [-R|--recursive]
                              <host-src0> [host-src1 [...]] <guest-dst>

                              copyto [common-options]
                              [--follow] [-R|--recursive]
                              [--target-directory <guest-dst>]
                              <host-src0> [host-src1 [...]]

                              mkdir|createdir[ectory] [common-options]
                              [--parents] [--mode <mode>]
                              <guest directory> [...]

                              rmdir|removedir[ectory] [common-options]
                              [-R|--recursive]
                              <guest directory> [...]

                              removefile|rm [common-options] [-f|--force]
                              <guest file> [...]

                              mv|move|ren[ame] [common-options]
                              <source> [source1 [...]] <dest>

                              mktemp|createtemp[orary] [common-options]
                              [--secure] [--mode <mode>] [--tmpdir <directory>]
                              <template>

                              stat [common-options]
                              <file> [...]

  guestcontrol <uuid|vmname> [--verbose|-v] [--quiet|-q]

                              list <all|sessions|processes|files> [common-opts]

                              closeprocess [common-options]
                              < --session-id <ID>
                                | --session-name <name or pattern>
                              <PID1> [PID1 [...]]

                              closesession [common-options]
                              < --all | --session-id <ID>
                                | --session-name <name or pattern> >

                              updatega|updateguestadditions|updateadditions
                              [--source <guest additions .ISO>]
                              [--wait-start] [common-options]
                              [-- [<argument1>] ... [<argumentN>]]

                              watch [common-options]

  metrics list [*|host|<vmname> [<metric_list>]]
                                                 (comma-separated)

  metrics setup
                            [--period <seconds>] (default: 1)
                            [--samples <count>] (default: 1)
                            [--list]
                            [*|host|<vmname> [<metric_list>]]

  metrics query [*|host|<vmname> [<metric_list>]]

  metrics enable
                            [--list]
                            [*|host|<vmname> [<metric_list>]]

  metrics disable
                            [--list]
                            [*|host|<vmname> [<metric_list>]]

  metrics collect
                            [--period <seconds>] (default: 1)
                            [--samples <count>] (default: 1)
                            [--list]
                            [--detach]
                            [*|host|<vmname> [<metric_list>]]

  natnetwork add --netname <name>
                            --network <network>
                            [--enable|--disable]
                            [--dhcp on|off]
                            [--port-forward-4 <rule>]
                            [--loopback-4 <rule>]
                            [--ipv6 on|off]
                            [--port-forward-6 <rule>]
                            [--loopback-6 <rule>]

  natnetwork remove --netname <name>

  natnetwork modify --netname <name>
                            [--network <network>]
                            [--enable|--disable]
                            [--dhcp on|off]
                            [--port-forward-4 <rule>]
                            [--loopback-4 <rule>]
                            [--ipv6 on|off]
                            [--port-forward-6 <rule>]
                            [--loopback-6 <rule>]

  natnetwork start --netname <name>

  natnetwork stop --netname <name>

  natnetwork list [<pattern>]

  hostonlyif ipconfig <name>
                            [--dhcp |
                            --ip<ipv4> [--netmask<ipv4> (def: 255.255.255.0)] |
                            --ipv6<ipv6> [--netmasklengthv6<length> (def: 64)]]
                            create |
                            remove <name>

  dhcpserver add|modify --netname <network_name> |
                                       --ifname <hostonly_if_name>
                            [--ip <ip_address>
                            --netmask <network_mask>
                            --lowerip <lower_ip>
                            --upperip <upper_ip>]
                            [--enable | --disable]
                            [--options [--vm <name> --nic <1-N>]
                             --id <number> [--value <string> | --remove]]
                             (multiple options allowed after --options)

  dhcpserver remove --netname <network_name> |
                                   --ifname <hostonly_if_name>

  usbdevsource add <source name>
                            --backend <backend>
                            --address <address>
  usbdevsource remove <source name>

 Medium content access:

  VBoxManage mediumio <[--disk=uuid|filename] | [--dvd=uuid|filename] |
      [--floppy=uuid|filename]> [--password-file-|filename] formatfat [--quick]

  VBoxManage mediumio <[--disk=uuid|filename] | [--dvd=uuid|filename] |
      [--floppy=uuid|filename]> [--password-file-|filename] cat [--hex]
      [--offset=byte-offset] [--size=bytes] [--output=-|filename]

  VBoxManage mediumio <[--disk=uuid|filename] | [--dvd=uuid|filename] |
      [--floppy=uuid|filename]> [--password-file-|filename] stream
      [--format=image-format] [--variant=image-variant] [--output=-|filename]

 Introspection and guest debugging:

  VBoxManage debugvm <uuid|vmname> dumpvmcore [--filename=name]

  VBoxManage debugvm <uuid|vmname> info <item> [args...]

  VBoxManage debugvm <uuid|vmname> injectnmi

  VBoxManage debugvm <uuid|vmname> log [[--release] | [--debug]]
      [group-settings...]

  VBoxManage debugvm <uuid|vmname> logdest [[--release] | [--debug]]
      [destinations...]

  VBoxManage debugvm <uuid|vmname> logflags [[--release] | [--debug]] [flags...]

  VBoxManage debugvm <uuid|vmname> osdetect

  VBoxManage debugvm <uuid|vmname> osinfo

  VBoxManage debugvm <uuid|vmname> osdmesg [--lines=lines]

  VBoxManage debugvm <uuid|vmname> getregisters [--cpu=id] [reg-set.reg-name...]

  VBoxManage debugvm <uuid|vmname> setregisters [--cpu=id]
      [reg-set.reg-name=value...]

  VBoxManage debugvm <uuid|vmname> show [[--human-readable] | [--sh-export] |
      [--sh-eval] | [--cmd-set]] [settings-item...]

  VBoxManage debugvm <uuid|vmname> stack [--cpu=id]

  VBoxManage debugvm <uuid|vmname> statistics [--reset] [--descriptions]
      [--pattern=pattern]

 Extension package management:

  VBoxManage extpack install [--replace] <tarball>

  VBoxManage extpack uninstall [--force] <name>

  VBoxManage extpack cleanup

 Unattended guest OS installation:

  VBoxManage unattended detect <--iso=install-iso> [--machine-readable]

  VBoxManage unattended install <uuid|vmname> <--iso=install-iso> [--user=login]
      [--password=password] [--password-file=file] [--full-user-name=name]
      [--key=product-key] [--install-additions] [--no-install-additions]
      [--additions-iso=add-iso] [--install-txs] [--no-install-txs]
      [--validation-kit-iso=testing-iso] [--locale=ll_CC] [--country=CC]
      [--time-zone=tz] [--hostname=fqdn]
      [--package-selection-adjustment=keyword] [--dry-run]
      [--auxiliary-base-path=path] [--image-index=number]
      [--script-template=file] [--post-install-template=file]
      [--post-install-command=command]
      [--extra-install-kernel-parameters=params] [--language=lang]
      [--start-vm=session-type]
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage getextradata
Usage:

VBoxManage getextradata global|<uuid|vmname>
                            <key>|[enumerate]

philipmarzullo@MacBook-Pro-3 ~ % VBoxManage getextradata global
Key: GUI/Details/Elements, Value: general,system,preview,display,storage,audio,network,usb,sharedFolders,description
Key: GUI/GroupDefinitions/, Value: m=bafaa926-90f4-4c23-a412-b2b587eff0a4,m=0ff7a814-4178-4cc9-9e82-ba7f0c2cbbc0,m=86c34b23-b0b7-476d-8ad2-266958c8aac7,m=1f44d068-f388-4583-b002-1be7e6ff7bd8
Key: GUI/GuestControl/FileManagerDialogGeometry, Value: 420,180,840,738
Key: GUI/GuestControl/FileManagerVisiblePanels, Value: SessionPanel
Key: GUI/HostNetworkManager/Details/Expanded, Value: true
Key: GUI/Input/AutoCapture, Value: false
Key: GUI/LastItemSelected, Value: m=Linux - Ingres
Key: GUI/LastWindowPosition, Value: 0,245,1680,514
Key: GUI/LogViewerOptions, Value: Monaco,Regular,10
Key: GUI/LogWindowGeometry, Value: 435,177,809,738
Key: GUI/RecentFolderCD, Value: /Users/philipmarzullo/Downloads
Key: GUI/RecentFolderHD, Value: /Users/philipmarzullo/Downloads/64bit
Key: GUI/RecentListCD, Value: /Users/philipmarzullo/Downloads/rhel-server-7.7-x86_64-dvd.iso,/Users/philipmarzullo/Downloads/rhel-server-7.7-x86_64-boot.iso,/Users/philipmarzullo/Downloads/ubuntu-18.04.4-desktop-amd64.iso
Key: GUI/RecentListHD, Value: /Users/philipmarzullo/Downloads/64bit/Ubuntu 18.10 Cosmic (64bit).vdi,/Users/philipmarzullo/Downloads/64bit/Ubuntu 19.04 (64bit).vdi
Key: GUI/SplitterSizes, Value: 544,1135
Key: GUI/SuppressMessages, Value: remindAboutAutoCapture,remindAboutMouseIntegration,confirmInputCapture,remindAboutGuestAdditionsAreNotActive
Key: GUI/Tools/LastItemsSelected, Value: Welcome,Logs
Key: GUI/UpdateCheckCount, Value: 43
Key: GUI/UpdateDate, Value: 1 d, 2020-06-02, stable, 6.0.20
Key: HostOnly/vboxnet0/IPAddress, Value: 192.168.56.1
Key: HostOnly/vboxnet0/IPNetMask, Value: 255.255.255.0
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage getextradata "Linux - Ingres"
Key: GUI/LastCloseAction, Value: PowerOff
Key: GUI/LastNormalWindowPosition, Value: 680,383,400,321
Key: GUI/LastScaleWindowPosition, Value: 86,83,1506,880
Key: GUI/Scale, Value: true
Key: VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled, Value: 1
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage setextradata "Linux - Ingres" "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" 1
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage getextradata "Linux - Ingres"
Key: GUI/LastCloseAction, Value: PowerOff
Key: GUI/LastNormalWindowPosition, Value: 680,383,400,321
Key: GUI/LastScaleWindowPosition, Value: 86,83,1506,880
Key: GUI/Scale, Value: true
Key: VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled, Value: 1
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage getextradata "Linux - Ingres"
Key: GUI/LastCloseAction, Value: PowerOff
Key: GUI/LastNormalWindowPosition, Value: 680,383,400,321
Key: GUI/LastScaleWindowPosition, Value: 86,83,1506,880
Key: GUI/Scale, Value: true
Key: VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled, Value: 1
philipmarzullo@MacBook-Pro-3 ~ % VBoxManage getextradata "Linux - Ingres"
Key: GUI/LastCloseAction, Value: PowerOff
Key: GUI/LastNormalWindowPosition, Value: 680,383,400,321
Key: GUI/LastScaleWindowPosition, Value: 86,83,1506,880
Key: GUI/Scale, Value: true
Key: VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled, Value: 1
philipmarzullo@MacBook-Pro-3 ~ % cd
philipmarzullo@MacBook-Pro-3 ~ % cd symmetric-workspaces/symmetric-workspace-ingres
philipmarzullo@MacBook-Pro-3 symmetric-workspace-ingres % ls
git workspace
philipmarzullo@MacBook-Pro-3 symmetric-workspace-ingres % cd git
philipmarzullo@MacBook-Pro-3 git % ls
jumpmind-common symmetric-ds
jumpmind-datasources symmetric-pro
philipmarzullo@MacBook-Pro-3 git % cd symmetric-pro
philipmarzullo@MacBook-Pro-3 symmetric-pro % cd symmetric-pro
philipmarzullo@MacBook-Pro-3 symmetric-pro % cd target
philipmarzullo@MacBook-Pro-3 target % ls
cacerts engines junit.log keystore tmp
philipmarzullo@MacBook-Pro-3 target % vi junit.log
philipmarzullo@MacBook-Pro-3 target % ps -ef | fgrep java
  501 94262 94255 0 7:26AM ?? 6:59.00 /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java -cp /Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/squirrel-sql.jar:/Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/lib/* -Dapple.laf.useScreenMenuBar=true -Dcom.apple.mrj.application.apple.menu.about.name=SQuirreLSQL -Dapple.awt.application.name=SQuirreLSQL -splash:/Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/icons/splash.jpg net.sourceforge.squirrel_sql.client.Main --log-config-file /Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java/log4j.properties --squirrel-home /Applications/SQuirreLSQL.app/Contents/MacOS/../Resources/Java --native-laf
  501 94850 94031 0 8:21AM ttys004 0:00.00 fgrep java
philipmarzullo@MacBook-Pro-3 target % vi junit.log
philipmarzullo@MacBook-Pro-3 target % cd
philipmarzullo@MacBook-Pro-3 ~ % cd symmetric
philipmarzullo@MacBook-Pro-3 symmetric % ls
Houston.properties pacelabs symmetric-server-3.11.5 symmetric-server-3.8.29
abbag pepkor symmetric-server-3.11.6 symmetric-server-3.8.32
advance phil.xml symmetric-server-3.11.7 symmetric-server-3.8.40
american_pool pmarzullo symmetric-server-3.11.x-SNAPSHOT symmetric-server-3.9.13
arris redwing symmetric-server-3.12.x-SNAPSHOT symmetric-server-3.9.14
auto-install-3.11.2.xml sandos symmetric-server-3.3.7 symmetric-server-3.9.15
auto-install-3.11.8.xml selectsires symmetric-server-3.6.5 symmetric-server-3.9.16
boots symmetric-server-3.10.0 symmetric-server-3.7.34 symmetric-server-3.9.17
container_store symmetric-server-3.10.3 symmetric-server-3.8.11 symmetric-server-3.9.18
dell symmetric-server-3.10.3.old symmetric-server-3.8.14 symmetric-server-3.9.20
dollar_general symmetric-server-3.10.x-SNAPSHOT symmetric-server-3.8.18 symmetric-server-3.9.x-SNAPSHOT
ee symmetric-server-3.11.0 symmetric-server-3.8.19 tsc
element_vehicle_management_system symmetric-server-3.11.2 symmetric-server-3.8.2 unicomer
force5 symmetric-server-3.11.3 symmetric-server-3.8.21 visma
ingrambarge symmetric-server-3.11.4 symmetric-server-3.8.22
philipmarzullo@MacBook-Pro-3 symmetric % ls symmetric-server-3.12.x-SNAPSHOT/engines
philipmarzullo@MacBook-Pro-3 symmetric % rm -fr symmetric-server-3.12.x-SNAPSHOT/*
zsh: sure you want to delete all the files in /Users/philipmarzullo/symmetric/symmetric-server-3.12.x-SNAPSHOT [yn]? y
philipmarzullo@MacBook-Pro-3 symmetric % cd symmetric-server-3.12.x-SNAPSHOT
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % ls
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % ls -a
. ..
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % java -jar /Users/philipmarzullo/symmetric-workspaces/symmetric-workspace-ingres/git/symmetric-pro/symmetric-pro/build/symmetric-pro-3.12.x-SNAPSHOT-setup.jar
Command line arguments:
====================
Installation started
Framework: 1.6.0_65-b14-468 (Apple Inc.)
Platform: mac_osx,version=10.15.4,arch=x86,symbolicName=null,javaVersion=1.8.0_232
[ Writing log to /Users/philipmarzullo/symmetric/symmetric-server-3.12.x-SNAPSHOT/./logs/install.log ]
Installation finished
[ Writing the uninstaller data ... ]
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % vi conf/symmetric-server.properties
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % cp ~/.symmetricds/lib/iijdbc.jar lib/
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % vi engines/
philipmarzullo@MacBook-Pro-3 symmetric-server-3.12.x-SNAPSHOT % cd logs
philipmarzullo@MacBook-Pro-3 logs % ls
install.log symmetric.log wrapper.log
philipmarzullo@MacBook-Pro-3 logs % vi symmetric.log










        at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:227) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:150) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:147) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:112) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:168) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:92) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:460) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:441) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
        at com.sun.crypto.provider.CipherCore.unpad(CipherCore.java:975) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.CipherCore.fillOutputBuffer(CipherCore.java:1056) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:853) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:446) ~[sunjce_provider.jar:1.8.0_232]
        at javax.crypto.Cipher.doFinal(Cipher.java:2164) ~[?:1.8.0_232]
        at org.jumpmind.security.SecurityService.decrypt(SecurityService.java:163) ~[symmetric-util-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        ... 85 more
Revision 2020-06-01 13:23 by pmarzullo
Description When replacing a symmetric installation in a database, there is a security exception:

2020-06-01 09:17:35,535 ERROR [server] [AbstractSymmetricEngine] [qtp238357312-18] An error occurred while starting SymmetricDS StackTraceKey.init [RuntimeException:957202463]
java.lang.RuntimeException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
        at org.jumpmind.security.SecurityService.decrypt(SecurityService.java:168) ~[symmetric-util-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.security.NodePasswordFilter.onNodeSecurityRender(NodePasswordFilter.java:22) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.filterPasswordOnRenderIfNeeded(NodeService.java:769) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.access$000(NodeService.java:60) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService$NodeSecurityRowMapper.mapRow(NodeService.java:903) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService$NodeSecurityRowMapper.mapRow(NodeService.java:899) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:139) ~[symmetric-jdbc-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:209) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:189) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.findNodeSecurity(NodeService.java:474) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.findNodeSecurity(NodeService.java:466) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1257) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1226) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1222) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.DatabaseUpgradeListener.afterUpgrade(DatabaseUpgradeListener.java:231) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:523) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:160) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:513) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:487) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:657) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:646) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:277) ~[symmetric-client-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:435) ~[symmetric-server-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dM.q(SymmetricDetectedScreen.java:144) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dH.c(NodeSetupWizard.java:285) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dM$2.buttonClick(SymmetricDetectedScreen.java:59) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
        at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:499) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:273) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:237) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1014) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.ui.Button.fireClick(Button.java:384) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.ui.Button$1.click(Button.java:57) ~[vaadin-server-8.10.0.jar:8.10.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
        at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:116) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:445) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:410) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:148) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:248) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:534) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) [vaadin-server-8.10.0.jar:8.10.0]
        at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:225) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:114) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2297) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:594) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:448) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:227) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:150) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:147) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:112) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:168) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:92) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:460) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:441) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
        at com.sun.crypto.provider.CipherCore.unpad(CipherCore.java:975) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.CipherCore.fillOutputBuffer(CipherCore.java:1056) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:853) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:446) ~[sunjce_provider.jar:1.8.0_232]
        at javax.crypto.Cipher.doFinal(Cipher.java:2164) ~[?:1.8.0_232]
        at org.jumpmind.security.SecurityService.decrypt(SecurityService.java:163) ~[symmetric-util-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        ... 85 more
Revision 2020-06-12 12:31 by elong
Description When reconnecting a new node to an old SymmetricDS installation in a database, there is a security exception.

2020-06-01 09:17:35,535 ERROR [server] [AbstractSymmetricEngine] [qtp238357312-18] An error occurred while starting SymmetricDS StackTraceKey.init [RuntimeException:957202463]
java.lang.RuntimeException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.

The sym_node_security table has encrypted node_password entries, and it is unable to decrypt them because it has a different encryption key than the old node.

Possible solutions: If registration node, then re-open registration for all nodes, re-generating a new password for them. If not registration node, then remove identity to request registration again.
Revision 2020-06-01 13:21 by pmarzullo
Steps To Reproduce 1. Install version 3.12
2. Create a node against a database that already has SymmetricDS system tables in it.
3. Choose to replace the installation.
Revision 2020-06-12 12:31 by elong
Steps To Reproduce 1. Install version 3.12
2. Create a node against a database
3. Remove 3.12 installation from disk only, and install again (or, just delete security/keystore and engines/*)
4. Create a node against same database
5. Choose to reconnect the installation.
Revision 2020-06-01 13:21 by pmarzullo
Additional Information
Revision 2020-06-12 12:31 by elong
Additional Information 2020-06-01 09:17:35,535 ERROR [server] [AbstractSymmetricEngine] [qtp238357312-18] An error occurred while starting SymmetricDS StackTraceKey.init [RuntimeException:957202463]
java.lang.RuntimeException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
        at org.jumpmind.security.SecurityService.decrypt(SecurityService.java:168) ~[symmetric-util-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.security.NodePasswordFilter.onNodeSecurityRender(NodePasswordFilter.java:22) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.filterPasswordOnRenderIfNeeded(NodeService.java:769) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.access$000(NodeService.java:60) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService$NodeSecurityRowMapper.mapRow(NodeService.java:903) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService$NodeSecurityRowMapper.mapRow(NodeService.java:899) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:139) ~[symmetric-jdbc-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:209) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:189) ~[symmetric-db-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.findNodeSecurity(NodeService.java:474) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.NodeService.findNodeSecurity(NodeService.java:466) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1257) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1226) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1222) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.DatabaseUpgradeListener.afterUpgrade(DatabaseUpgradeListener.java:231) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:523) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:160) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:513) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:487) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:657) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:646) ~[symmetric-core-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:277) ~[symmetric-client-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:435) ~[symmetric-server-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dM.q(SymmetricDetectedScreen.java:144) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dH.c(NodeSetupWizard.java:285) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at com.jumpmind.symmetric.console.impl.dM$2.buttonClick(SymmetricDetectedScreen.java:59) ~[symmetric-pro-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
        at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:499) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:273) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:237) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1014) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.ui.Button.fireClick(Button.java:384) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.ui.Button$1.click(Button.java:57) ~[vaadin-server-8.10.0.jar:8.10.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
        at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:116) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:445) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:410) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:148) ~[vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:248) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:534) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) [vaadin-server-8.10.0.jar:8.10.0]
        at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) [vaadin-server-8.10.0.jar:8.10.0]
        at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:225) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:114) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2297) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:594) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:448) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) [atmosphere-runtime-2.4.30.vaadin1.jar:2.4.30.vaadin1]
        at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:227) [javax-websocket-client-impl-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:150) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:147) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:112) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:168) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:92) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:460) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:441) [websocket-common-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.28.v20200408.jar:9.4.28.v20200408]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
        at com.sun.crypto.provider.CipherCore.unpad(CipherCore.java:975) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.CipherCore.fillOutputBuffer(CipherCore.java:1056) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:853) ~[sunjce_provider.jar:1.8.0_232]
        at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:446) ~[sunjce_provider.jar:1.8.0_232]
        at javax.crypto.Cipher.doFinal(Cipher.java:2164) ~[?:1.8.0_232]
        at org.jumpmind.security.SecurityService.decrypt(SecurityService.java:163) ~[symmetric-util-3.12.x-SNAPSHOT.jar:3.12.x-SNAPSHOT]
        ... 85 more