Failed to authenticate via SSH tunneling

[Vercryger]

Describe the bug
Hey, for some unknown reason, the client is not able to connect a remote database through SSH even when provided credentials are correct.
I'am able to access the remote server using the terminal though, however when I try to access through the client, I get an error telling:

Failed to authenticate via private key. Authentication failed or partial success. (4)

These are the logs when I attempt to access through the client:

2023/06/23 22:47:52:036  Application is becoming active.
2023/06/23 22:47:52:069  connectToRecentConnectionById (not requesting password)
2023/06/23 22:47:52:069  doConnect: cashrent-mariadb-qa1.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/23 22:47:52:081  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/23 22:47:52:081  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/23 22:47:52:081  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/23 22:47:52:081  doConnect calling databaseClient->connect
2023/06/23 22:47:52:081  HSChilkatSSHTunnelHelper disconnect
2023/06/23 22:47:52:085  HSChilkatSSHTunnelHelper:closeConnection success YES.
2023/06/23 22:47:52:086  HSSSHTunnelPool - Creating a new connection.
2023/06/23 22:47:52:086  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/23 22:47:52:086  HSChilkatSSHTunnelHelper:connect - ssh authentication methods exist in cache: (
    publickey,
    "gssapi-keyex",
    "gssapi-with-mic"
)
2023/06/23 22:47:53:146  SSHTunnel:keysForHost:port: returning an array (1 entries) of fingerprints.
2023/06/23 22:47:53:146  Keydata was found (user previously stored).
2023/06/23 22:47:53:146  SSH:authenticateViaPublicKey - publickey auth path is accessable. Not using bookmark.
2023/06/23 22:47:53:148  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/23 22:47:53:480  Application is resigning activity.
2023/06/23 22:47:54:619  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/23 22:47:54:619  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/23 22:47:54:619  publickey authentication finished and we are not yet authenticated.
2023/06/23 22:47:54:619  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    Component successfully unlocked using purchased unlock code.
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext)
                    myIP: 192.168.1.102
                    myPort: 58173
                    socket connect successful.
                    (leaveContext 276ms)
                (leaveContext 276ms)
            (leaveContext 276ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 277ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.70
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 2ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext 1ms)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext 1ms)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256@libssh.org
            choose_hostkey_algorithm:
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 9ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 1ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            Using SHA256 for Key Exchange Hash
            (leaveContext 2ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 32
                s_len: 32
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: 48D30939FA771718B1D04AF31AD60B15152FE062F1B3F854B0A75097E542503723571780E59C6554F6ACFFB4A7EB7D63BB9ADA3588CFD74ED0B29355F48D90B9
                        (leaveContext)
                    (leaveContext 4ms)
                ecdsaSigValid: 1
                (leaveContext 4ms)
            ECDSA host key signature verification success
            (leaveContext 5ms)
        calculateKey:
            (leaveContext 1ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext)
        (leaveContext 781ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext 1ms)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 1060ms)
AuthenticatePwPk:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 2048 af:91:2a:53:f3:02:6f:31:2e:45:e3:6f:d0:68:b1:b2
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext)
                ssh-userauth service accepted.
                (leaveContext 247ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=01=01=00=BD=82B=A9=1E=12-=DB`&=F9=E6=F4=D6=87$=D6=9D=E4=C8=13=04=BAY5%=CE=14=ED=B3=FB=BC~H=F0=9B=F2d=EA=96u=03=D8=F2m=1D=CCK~=FE=E2<=C7=EA=C9=D8k=EF	=89=BA=846Z=9A=11>)'=FDiNQ=B4=0D<H=FEQu=B7=B0=DB=98=92.=8C=97=1Ac=B3=06=A31=13=B4P=ED=17=8E=CEYti =ED=16w=DDLln=FFgV=CC=F5=CAX=13,5^ =B2=D9=98=87=AD=0F=F8=DE=10=D6`f=F3=AC>?=F76=CD2=9BK=BFN=E4=E9=F4=BF=FEC=A9=B9=92}+X=EC=F0=18=B0=DD=F3j=99=9F\=B5j=0A=A7x=B4=0B=C2=EF=11=B9=92=17=9DV=D4=8F^=B934h9[=F0B=D2=97fr=18=9Ep#Y=A4=95=B1mr=F5-=12=E3JN!u=A4=99=95v=02=C8=C2=FC=BAY=AF=EE_=18c=DFI=9A=DB=98x=E2yQ=ECk=14FN=90?+l=18=83iw=FB]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 10ms)
            rsaSigLen: 256
            Sent public-key request with signature.
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            (less common) It can also mean that Chilkat tried to use rsa-sha2-256 for the authentication, because the server indicated it supports rsa-sha2-256, but does not actually support it for PK authentication.
            A workaround is to set the UncommonOptions property equal to "ForceUserAuthRsaSha1" and then re-try.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Publickey authentication failed..
            (leaveContext 1469ms)
        (leaveContext 1470ms)
    Failed.
    (leaveContext 1470ms)
2023/06/23 22:47:54:619  SSH tunnel failed after 2.53 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/23 22:47:54:619  Not accepting
2023/06/23 22:47:54:619  Not connected
2023/06/23 22:47:54:619  initializeSSH (allow pool) took 2.54 seconds.
2023/06/23 22:47:54:619  doConnect databaseClient->connect finished
2023/06/23 22:47:54:620  setDBC: connectionId: 700C85E0-BD4E-4EC7-A58C-1074AE288CE2-9484-0000018CEA89337B
2023/06/23 22:47:54:620  checkSSHFingerprintError returning NO
2023/06/23 22:47:54:621  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/23 22:47:54:621  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/23 22:47:54:622  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/23 22:47:54:623  Clearing internal database connection details.
2023/06/23 22:47:54:623  setDBC: nil
2023/06/23 22:47:56:336  Application is becoming active.
2023/06/23 22:47:57:081  Application is resigning activity.

To Reproduce
Steps to reproduce the behavior:

1. Go to Connect
2. Click on the saved remote connection
3. See error

Expected behavior
It should connect successfully to the remote database using the correct SSH tunneling credentials.

Screenshots

Environment details (please complete the following information):

• Device: MacBook
• OS: macOS 12.6
• SQLPro app Version: SQLPro Studio Version 2023.43 (Build 111043.5)
• Installation source: App Store
• Target database server: MariaDB

[hankinsoft]

Hmmm, ok. I see a message from the tunnel library:

             When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            (less common) It can also mean that Chilkat tried to use rsa-sha2-256 for the authentication, because the server indicated it supports rsa-sha2-256, but does not actually support it for PK authentication.
            A workaround is to set the UncommonOptions property equal to "ForceUserAuthRsaSha1" and then re-try.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic

I think I'm going to have to provide a test build or two based on these settings. I'll post the first build here once it is available.

[hankinsoft]

Could you download: https://sqlprostudio.s3.us-east-1.amazonaws.com/studio/SQLProStudio.2023.46.app.zip

When you edit the connection ssh, there should now be an 'Advanced options' textbox.

If possible, could you try:

1. Filling this in with: ForceUserAuthRsaSha1
2. Filling this in with: PubkeyOrPassword
3. Filling this in with: ForceUserAuthRsaSha1, PubkeyOrPassword

And seeing if either of these options let you connect?

If they do not, could you also provide the log file from the third session?

[Vercryger]

Unfortunately none of those options worked. Here's the log file:

2023/06/27 15:14:56:876  Application is becoming active.
2023/06/27 15:14:59:516  Application is resigning activity.
2023/06/27 15:15:05:090  Application is becoming active.
2023/06/27 15:15:09:109  HSSSHTunnelWindowController endSheetWithReturnCode: OK
2023/06/27 15:15:10:594  SQLProConnectionPersistance:saveConnection:inGroup:error: - connection 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154 has been modified. Going to close all existing connections.
2023/06/27 15:15:10:594  Took 0.00 seconds to release 0 connections.
2023/06/27 15:15:10:595  MySQLConnectionWindowController endSheetWithReturnCode: HSModalResponseSaveWithoutConnecting
2023/06/27 15:15:10:596  HSCollectionViewWithKeyEvents:deselectAll
2023/06/27 15:15:10:597  HSCollectionViewWithKeyEvents:deselectAll
2023/06/27 15:15:10:597  SQLProConnectionWindowController:updateConnections: entered.
2023/06/27 15:15:10:597  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:619  setCollectionEntries with 2 sections (23 entries).
2023/06/27 15:15:10:619  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:10:620  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:10:621  doRefreshConnectionsReloadOnMain started
2023/06/27 15:15:10:621  SQLProConnectionWindowController:updateConnections: entered.
2023/06/27 15:15:10:621  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:621  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:622  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:622  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:622  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:622  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:622  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:622  setCollectionEntries with 2 sections (23 entries).
2023/06/27 15:15:10:622  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:10:622  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:10:622  doRefreshConnectionsReloadOnMain finished
2023/06/27 15:15:10:638  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:639  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:640  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:640  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:684  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:10:685  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:14:179  connectToRecentConnectionById (not requesting password)
2023/06/27 15:15:14:179  doConnect: cashrent-mariadb-qa2.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/27 15:15:14:189  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/27 15:15:14:190  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/27 15:15:14:190  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/27 15:15:14:190  doConnect calling databaseClient->connect
2023/06/27 15:15:14:190  HSSSHTunnelPool - Creating a new connection.
2023/06/27 15:15:14:190  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/27 15:15:14:190  HSChilkatSSHTunnelHelper:connect - ssh authentication methods exist in cache: (
    publickey,
    "gssapi-keyex",
    "gssapi-with-mic"
)
2023/06/27 15:15:14:190  HSChilkatSSHTunnelHelper:connect - using uncommon options: ForceUserAuthRsaSha1
2023/06/27 15:15:15:197  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/27 15:15:15:197  Keydata was found (user previously stored).
2023/06/27 15:15:15:197  SSH:authenticateViaPublicKey - publickey auth path is accessable. Not using bookmark.
2023/06/27 15:15:15:200  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/27 15:15:16:086  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/27 15:15:16:086  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:16:086  publickey authentication finished and we are not yet authenticated.
2023/06/27 15:15:16:086  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    Component successfully unlocked using purchased unlock code.
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext 1ms)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext 1ms)
                    myIP: 192.168.0.69
                    myPort: 52359
                    socket connect successful.
                    (leaveContext 219ms)
                (leaveContext 221ms)
            (leaveContext 221ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 222ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.70
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext 2ms)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 3ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext 1ms)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256@libssh.org
            choose_hostkey_algorithm:
                (leaveContext 1ms)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 9ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 3ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            Using SHA256 for Key Exchange Hash
            (leaveContext 2ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 33
                s_len: 33
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: F92616DED97713C0C3ED4A239B352D6C07E9724C91488476DE7EE5D1008FFB26A2F33F17D1FE4BC6CC0304AF7F7157E418D435E4355A816BB8EC82C688469BCF
                        (leaveContext)
                    (leaveContext 2ms)
                ecdsaSigValid: 1
                (leaveContext 4ms)
            ECDSA host key signature verification success
            (leaveContext 5ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext 1ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext)
        (leaveContext 781ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 1007ms)
AuthenticatePwPk:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext 1ms)
                ssh-userauth service accepted.
                (leaveContext 269ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext 1ms)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 23ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            (less common) It can also mean that Chilkat tried to use rsa-sha2-256 for the authentication, because the server indicated it supports rsa-sha2-256, but does not actually support it for PK authentication.
            A workaround is to set the UncommonOptions property equal to "ForceUserAuthRsaSha1" and then re-try.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Publickey authentication failed..
            (leaveContext 885ms)
        (leaveContext 885ms)
    Failed.
    (leaveContext 885ms)
2023/06/27 15:15:16:086  SSH tunnel failed after 1.90 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:16:086  Not accepting
2023/06/27 15:15:16:086  Not connected
2023/06/27 15:15:16:086  initializeSSH (allow pool) took 1.90 seconds.
2023/06/27 15:15:16:086  doConnect databaseClient->connect finished
2023/06/27 15:15:16:087  setDBC: connectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/27 15:15:16:087  checkSSHFingerprintError returning NO
2023/06/27 15:15:16:087  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/27 15:15:16:087  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/27 15:15:16:088  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:16:088  Clearing internal database connection details.
2023/06/27 15:15:16:088  setDBC: nil
2023/06/27 15:15:19:329  onEditConnection
2023/06/27 15:15:19:330  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:19:331  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:23:349  Application is resigning activity.
2023/06/27 15:15:25:285  Application is becoming active.
2023/06/27 15:15:27:398  HSSSHTunnelWindowController endSheetWithReturnCode: OK
2023/06/27 15:15:28:740  SQLProConnectionPersistance:saveConnection:inGroup:error: - connection 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154 has been modified. Going to close all existing connections.
2023/06/27 15:15:28:741  Took 0.00 seconds to release 0 connections.
2023/06/27 15:15:28:741  MySQLConnectionWindowController endSheetWithReturnCode: HSModalResponseSaveWithoutConnecting
2023/06/27 15:15:28:742  HSCollectionViewWithKeyEvents:deselectAll
2023/06/27 15:15:28:743  HSCollectionViewWithKeyEvents:deselectAll
2023/06/27 15:15:28:743  SQLProConnectionWindowController:updateConnections: entered.
2023/06/27 15:15:28:743  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:759  setCollectionEntries with 2 sections (23 entries).
2023/06/27 15:15:28:759  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:28:760  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:28:760  doRefreshConnectionsReloadOnMain started
2023/06/27 15:15:28:760  SQLProConnectionWindowController:updateConnections: entered.
2023/06/27 15:15:28:760  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:761  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:761  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:762  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:762  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:762  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:762  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:762  setCollectionEntries with 2 sections (23 entries).
2023/06/27 15:15:28:762  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:28:762  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:28:762  doRefreshConnectionsReloadOnMain finished
2023/06/27 15:15:28:775  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:776  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:777  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:777  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:803  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:28:804  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:30:494  connectToRecentConnectionById (not requesting password)
2023/06/27 15:15:30:494  doConnect: cashrent-mariadb-qa2.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/27 15:15:30:505  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/27 15:15:30:505  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/27 15:15:30:505  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/27 15:15:30:505  doConnect calling databaseClient->connect
2023/06/27 15:15:30:505  HSChilkatSSHTunnelHelper disconnect
2023/06/27 15:15:30:512  HSChilkatSSHTunnelHelper:closeConnection success YES.
2023/06/27 15:15:30:522  HSSSHTunnelPool - Creating a new connection.
2023/06/27 15:15:30:522  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/27 15:15:30:522  HSChilkatSSHTunnelHelper:connect - ssh authentication methods exist in cache: (
    publickey,
    "gssapi-keyex",
    "gssapi-with-mic"
)
2023/06/27 15:15:30:522  HSChilkatSSHTunnelHelper:connect - using uncommon options: PubkeyOrPassword
2023/06/27 15:15:31:562  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/27 15:15:31:562  Keydata was found (user previously stored).
2023/06/27 15:15:31:562  SSH:authenticateViaPublicKey - publickey auth path is accessable. Not using bookmark.
2023/06/27 15:15:31:565  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/27 15:15:32:189  Application is resigning activity.
2023/06/27 15:15:32:323  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/27 15:15:32:324  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:32:324  publickey authentication finished and we are not yet authenticated.
2023/06/27 15:15:32:324  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    Component successfully unlocked using purchased unlock code.
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext 1ms)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext)
                    myIP: 192.168.0.69
                    myPort: 52382
                    socket connect successful.
                    (leaveContext 305ms)
                (leaveContext 308ms)
            (leaveContext 309ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 309ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.70
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext 1ms)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 3ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext 1ms)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext 1ms)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256@libssh.org
            choose_hostkey_algorithm:
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 10ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 2ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            Using SHA256 for Key Exchange Hash
            (leaveContext 3ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext 1ms)
            eccVerifySig:
                r_len: 32
                s_len: 32
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: 6E4FA1F40DAD50AD54BABD10946E9685FCBA0B8658C7D09E67A5D986F047578643FCF0EB4271960B2C691645C6A4F9447A9D9D97747EB0EE54816CA7D8858079
                        (leaveContext)
                    (leaveContext 3ms)
                ecdsaSigValid: 1
                (leaveContext 3ms)
            ECDSA host key signature verification success
            (leaveContext 4ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext 1ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext 1ms)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext 1ms)
        (leaveContext 726ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext 1ms)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 1039ms)
AuthenticatePwPk:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext)
                ssh-userauth service accepted.
                (leaveContext 287ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext 1ms)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 24ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            (less common) It can also mean that Chilkat tried to use rsa-sha2-256 for the authentication, because the server indicated it supports rsa-sha2-256, but does not actually support it for PK authentication.
            A workaround is to set the UncommonOptions property equal to "ForceUserAuthRsaSha1" and then re-try.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            publickey not accepted, but continuing to authenticate the password...
            Publickey authentication failed..
            (leaveContext 757ms)
        (leaveContext 757ms)
    Failed.
    (leaveContext 759ms)
2023/06/27 15:15:32:324  SSH tunnel failed after 1.80 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:32:324  Not accepting
2023/06/27 15:15:32:324  Not connected
2023/06/27 15:15:32:324  initializeSSH (allow pool) took 1.82 seconds.
2023/06/27 15:15:32:324  doConnect databaseClient->connect finished
2023/06/27 15:15:32:324  setDBC: connectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/27 15:15:32:324  checkSSHFingerprintError returning NO
2023/06/27 15:15:32:325  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/27 15:15:32:325  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/27 15:15:32:325  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:32:326  Clearing internal database connection details.
2023/06/27 15:15:32:326  setDBC: nil
2023/06/27 15:15:37:334  Application is becoming active.
2023/06/27 15:15:39:987  onEditConnection
2023/06/27 15:15:39:987  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:39:988  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:46:536  HSSSHTunnelWindowController endSheetWithReturnCode: OK
2023/06/27 15:15:47:665  SQLProConnectionPersistance:saveConnection:inGroup:error: - connection 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154 has been modified. Going to close all existing connections.
2023/06/27 15:15:47:665  Took 0.00 seconds to release 0 connections.
2023/06/27 15:15:47:665  MySQLConnectionWindowController endSheetWithReturnCode: HSModalResponseSaveWithoutConnecting
2023/06/27 15:15:47:666  HSCollectionViewWithKeyEvents:deselectAll
2023/06/27 15:15:47:667  HSCollectionViewWithKeyEvents:deselectAll
2023/06/27 15:15:47:667  SQLProConnectionWindowController:updateConnections: entered.
2023/06/27 15:15:47:667  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:686  setCollectionEntries with 2 sections (23 entries).
2023/06/27 15:15:47:686  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:47:687  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:47:687  doRefreshConnectionsReloadOnMain started
2023/06/27 15:15:47:687  SQLProConnectionWindowController:updateConnections: entered.
2023/06/27 15:15:47:687  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:688  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:688  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:688  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:688  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:689  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:689  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:689  setCollectionEntries with 2 sections (23 entries).
2023/06/27 15:15:47:689  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:47:689  HSCollectionViewWithKeyEvents:reloadData
2023/06/27 15:15:47:689  doRefreshConnectionsReloadOnMain finished
2023/06/27 15:15:47:701  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:701  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:702  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:703  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:729  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:47:730  FAILED TO OPEN CONNECTIONS LOG FILE
2023/06/27 15:15:49:203  connectToRecentConnectionById (not requesting password)
2023/06/27 15:15:49:203  doConnect: cashrent-mariadb-qa2.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/27 15:15:49:219  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/27 15:15:49:220  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/27 15:15:49:220  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/27 15:15:49:220  doConnect calling databaseClient->connect
2023/06/27 15:15:49:220  HSChilkatSSHTunnelHelper disconnect
2023/06/27 15:15:49:227  HSChilkatSSHTunnelHelper:closeConnection success YES.
2023/06/27 15:15:49:237  HSSSHTunnelPool - Creating a new connection.
2023/06/27 15:15:49:237  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/27 15:15:49:237  HSChilkatSSHTunnelHelper:connect - ssh authentication methods exist in cache: (
    publickey,
    "gssapi-keyex",
    "gssapi-with-mic"
)
2023/06/27 15:15:49:237  HSChilkatSSHTunnelHelper:connect - using uncommon options: ForceUserAuthRsaSha1, PubkeyOrPassword
2023/06/27 15:15:50:212  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/27 15:15:50:212  Keydata was found (user previously stored).
2023/06/27 15:15:50:212  SSH:authenticateViaPublicKey - publickey auth path is accessable. Not using bookmark.
2023/06/27 15:15:50:214  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/27 15:15:51:045  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/27 15:15:51:045  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:51:045  publickey authentication finished and we are not yet authenticated.
2023/06/27 15:15:51:045  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    Component successfully unlocked using purchased unlock code.
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext 1ms)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext 1ms)
                    myIP: 192.168.0.69
                    myPort: 52408
                    socket connect successful.
                    (leaveContext 220ms)
                (leaveContext 221ms)
            (leaveContext 222ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 222ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.70
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext 1ms)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 2ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext 1ms)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256@libssh.org
            choose_hostkey_algorithm:
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 8ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 2ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            Using SHA256 for Key Exchange Hash
            (leaveContext 1ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext 1ms)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 32
                s_len: 33
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: 4DE01B2F65A82C9074A6813C2B2E25CF19BE241A50A4B35CA914C5BDF1ECBB6CACA52D7F5DA9C203397EB7B1E62BC8A26C830B869A10FB8EF3485A083AB9CAF1
                        (leaveContext)
                    (leaveContext 3ms)
                ecdsaSigValid: 1
                (leaveContext 4ms)
            ECDSA host key signature verification success
            (leaveContext 5ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext 1ms)
        (leaveContext 749ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext 1ms)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 974ms)
AuthenticatePwPk:
    DllDate: Nov 18 2022
    ChilkatVersion: 9.5.0.93
    UnlockPrefix: HNKNSF.CB1082023
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext)
                ssh-userauth service accepted.
                (leaveContext 275ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 21ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            (less common) It can also mean that Chilkat tried to use rsa-sha2-256 for the authentication, because the server indicated it supports rsa-sha2-256, but does not actually support it for PK authentication.
            A workaround is to set the UncommonOptions property equal to "ForceUserAuthRsaSha1" and then re-try.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            publickey not accepted, but continuing to authenticate the password...
            Publickey authentication failed..
            (leaveContext 829ms)
        (leaveContext 829ms)
    Failed.
    (leaveContext 830ms)
2023/06/27 15:15:51:045  SSH tunnel failed after 1.81 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:51:045  Not accepting
2023/06/27 15:15:51:045  Not connected
2023/06/27 15:15:51:045  initializeSSH (allow pool) took 1.83 seconds.
2023/06/27 15:15:51:045  doConnect databaseClient->connect finished
2023/06/27 15:15:51:046  setDBC: connectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/27 15:15:51:046  checkSSHFingerprintError returning NO
2023/06/27 15:15:51:047  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/27 15:15:51:047  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/27 15:15:51:047  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/27 15:15:51:048  Clearing internal database connection details.
2023/06/27 15:15:51:048  setDBC: nil
2023/06/27 15:15:55:023  Application is resigning activity.

[hankinsoft]

If possible, could you try this build:
https://sqlprostudio.s3.us-east-1.amazonaws.com/studio/SQLProStudio.2023.48.app.zip

You shouldn't need any of the extra options set. If it fails, could you please again provide the log file?

[Vercryger]

Sadly, it didn't work either @hankinsoft .

2023/06/29 11:31:28:301  


Application com.hankinsoft.osx.sqlprostudio v2023.48 (111048) has launched (from Website).
2023/06/29 11:31:28:301  App startup path is: file:///private/var/folders/dk/4v8y1k9d64l78z6q0_8w5hw40000gn/T/AppTranslocation/90BAA7B7-C20B-4D3D-8557-811935468D52/d/
2023/06/29 11:31:28:301  Initialize themes
2023/06/29 11:31:28:304  Finished initialize themes (took 0.00 seconds.)
2023/06/29 11:31:28:347  applicationPreferencesChanged
2023/06/29 11:31:28:371  RMAppStoreHelper:hasInvalidReceipt - receipt file does not exist.
2023/06/29 11:31:28:374  Application is becoming active.
2023/06/29 11:31:28:824  SQLProDocumentController:setCanOpenUntitledDocument:... true
2023/06/29 11:31:28:825  restoreUIState - Started restoring. App recovery URL is: file:///Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Recovery/AppRecovery.json
2023/06/29 11:31:28:825  Document init called. 0 time.
2023/06/29 11:31:28:851  Document (0x7ff6efa9d1e0) awakeFromNib.
2023/06/29 11:31:28:851  DatabaseTreeViewController 0x6000028db440 init
2023/06/29 11:31:28:856  HSOutlineView (0x7ff6ef04e600) awakeFromNib.
2023/06/29 11:31:28:856  Started reloadData
2023/06/29 11:31:28:856  Finished reloadData
2023/06/29 11:31:28:862  HSOutlineView (0x7ff6ef069000) awakeFromNib.
2023/06/29 11:31:28:862  Started reloadData
2023/06/29 11:31:28:862  Finished reloadData
2023/06/29 11:31:28:863  MainTabViewController::loadView - started
2023/06/29 11:31:28:869  MainTabViewController::loadView - super finished)
2023/06/29 11:31:28:873  MainTabViewController::loadView - finished
2023/06/29 11:31:28:874  Document windowControllerDidLoadNib
2023/06/29 11:31:28:899  Started reloadData
2023/06/29 11:31:28:899  Finished reloadData
2023/06/29 11:31:28:899  Finished restoring UIState.
2023/06/29 11:31:28:956  HSUpdateHelper - Current app version is the latest.
2023/06/29 11:31:29:131  openConnectionDialogWithBlock entered
2023/06/29 11:31:29:139  SQLProConnectionWindowController init.
2023/06/29 11:31:29:208  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:31:29:211  MySQLAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/C03550
2023/06/29 11:31:29:216  PostgresAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/140695
2023/06/29 11:31:29:225  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - DFD106D5-37AC-4034-A4A0-C05BC1462426-6643-0000372EB8D5DD25.json) begin
2023/06/29 11:31:29:226  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:31:29:227  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:31:29:227  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:31:29:227  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - BE5FF488-778E-4603-B6B2-1E00BD217132-13598-0000152C42B7C2A9.json) begin
2023/06/29 11:31:29:234  restoreWindowSize entered.
2023/06/29 11:31:29:252  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:31:29:254  setCollectionEntries with 2 sections (19 entries).
2023/06/29 11:31:29:254  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:254  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:254  HSCollectionViewWithKeyEvents:deselectAll
2023/06/29 11:31:29:254  HSCollectionViewWithKeyEvents:deselectAll
2023/06/29 11:31:29:254  doRefreshConnectionsReloadOnMain started
2023/06/29 11:31:29:254  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:31:29:256  setCollectionEntries with 2 sections (19 entries).
2023/06/29 11:31:29:256  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:256  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:256  doRefreshConnectionsReloadOnMain finished
2023/06/29 11:31:29:256  configureToolbar
2023/06/29 11:31:29:271  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:31:29:273  setCollectionEntries with 2 sections (23 entries).
2023/06/29 11:31:29:273  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:273  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:286  MSSQLAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/B4E95C
2023/06/29 11:31:29:299  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - performance_schema) has 1.560 entries.
2023/06/29 11:31:29:317  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - sys) has 1.117 entries.
2023/06/29 11:31:29:338  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - information_schema) has 813 entries.
2023/06/29 11:31:29:363  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent) has 1.252 entries.
2023/06/29 11:31:29:373  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - mysql) has 330 entries.
2023/06/29 11:31:29:373  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.15 seconds
2023/06/29 11:31:29:373  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - E992E767-8867-4ACC-A193-2092FE3380A8-44712-00018EFFB5723143.json) begin
2023/06/29 11:31:29:377  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:31:29:378  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:31:29:395  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent) has 1.201 entries.
2023/06/29 11:31:29:395  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.02 seconds
2023/06/29 11:31:29:396  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - B76A4AE1-630C-4DBB-AC6C-3C99BC37B666-91994-00000DCFC1C3A8A3.json) begin
2023/06/29 11:31:29:396  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:31:29:397  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:31:29:397  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:31:29:397  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - F7ECA8B6-ACFE-4F13-BCBF-D6EE8A4B4CC6-4063-00001C1E0874A45D.json) begin
2023/06/29 11:31:29:439  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent_staging) has 1.201 entries.
2023/06/29 11:31:29:468  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - information_schema) has 896 entries.
2023/06/29 11:31:29:492  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - test) has 877 entries.
2023/06/29 11:31:29:492  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.09 seconds
2023/06/29 11:31:29:493  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - B099C7E2-C7DC-474D-A650-B583C404DC02-51820-00000844CBF3DA0C.json) begin
2023/06/29 11:31:29:493  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:31:29:495  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:31:29:495  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:31:29:495  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - FF5B1CFB-B197-49F1-ACD6-E9BBE7FF1776-1854-000018B4AAFCF00B.json) begin
2023/06/29 11:31:29:500  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:31:29:501  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:31:29:526  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent) has 1.252 entries.
2023/06/29 11:31:29:526  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.03 seconds
2023/06/29 11:31:29:526  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - EC55D5FB-FC88-4E19-9C63-80A593A5F51F-456-00000801B6EC0585.json) begin
2023/06/29 11:31:29:527  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:31:29:528  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:31:29:528  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:31:29:686  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:31:29:688  setCollectionEntries with 2 sections (23 entries).
2023/06/29 11:31:29:688  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:689  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:689  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:31:29:691  setCollectionEntries with 2 sections (23 entries).
2023/06/29 11:31:29:691  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:29:691  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:31:30:186  MongoDBAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/F44336
2023/06/29 11:31:30:240  MongoDBDatabaseClient initialize with v1.18.0-pre.
2023/06/29 11:31:32:284  NSApp sendAction: collectionItemViewDoubleClick
2023/06/29 11:31:32:284  collectionItemViewDoubleClick
2023/06/29 11:31:32:284  connectToConnectionId: 700C85E0-BD4E-4EC7-A58C-1074AE288CE2-9484-0000018CEA89337B
2023/06/29 11:31:32:285  connectToRecentConnectionById (not requesting password)
2023/06/29 11:31:32:285  doConnect: cashrent-mariadb-qa1.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/29 11:31:32:304  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:31:32:304  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/29 11:31:32:305  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/29 11:31:32:321  mysql_library_init result: 0. Client info: 3.3.1. Thread safe: YES.
2023/06/29 11:31:32:321  doConnect calling databaseClient->connect
2023/06/29 11:31:32:321  HSSSHTunnelPool - Creating a new connection.
2023/06/29 11:31:32:322  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/29 11:31:32:322  HSChilkatSSHTunnelHelper:connect - getting ssh authentication methods.
2023/06/29 11:31:33:201  HSChilkatSSHTunnelHelper:connected with banner [], identifier: [SSH-2.0-OpenSSH_8.7]
2023/06/29 11:31:33:860  HSChilkatSSHTunnelHelper:connect - got auth methods from ssh server. (publickey|gssapi-keyex|gssapi-with-mic)
2023/06/29 11:31:33:860  HSChilkatSSHTunnelHelper:connect - using uncommon options: ForceUserAuthRsaSha1, PubkeyOrPassword
2023/06/29 11:31:34:727  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/29 11:31:34:727  Keydata was found (user previously stored).
2023/06/29 11:31:34:738  SSH:authenticateViaPublicKey - publickey auth path via bookmark.
2023/06/29 11:31:34:741  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/29 11:31:35:411  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/29 11:31:35:412  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:31:35:412  publickey authentication finished and we are not yet authenticated.
2023/06/29 11:31:35:412  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext 3ms)
                    myIP: 192.168.1.104
                    myPort: 53190
                    socket connect successful.
                    (leaveContext 212ms)
                (leaveContext 213ms)
            (leaveContext 213ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 214ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.78
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,aes128-gcm@openssh.com,aes256-gcm@openssh.com,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext 1ms)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 2ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext 1ms)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256
            choose_hostkey_algorithm:
                choose_userauth_rsa_algorithm:
                    (leaveContext)
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 6ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 2ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            (leaveContext 2ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 33
                s_len: 33
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: F645550B8BAC43746654BE7AC9E238834B0E4775E416E300A2F472707F637DEAED5BAF9E2334D0691EB9E25203D19659A97B600ABD2766EF772448807E81CD6A
                        (leaveContext 1ms)
                    (leaveContext 3ms)
                ecdsaSigValid: 1
                (leaveContext 3ms)
            ECDSA host key signature verification success
            (leaveContext 5ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext 1ms)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext 1ms)
        (leaveContext 649ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext 1ms)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 866ms)
AuthenticatePwPk:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext 1ms)
                ssh-userauth service accepted.
                (leaveContext 209ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 21ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            hostKeyAlg: 3
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            publickey not accepted, but continuing to authenticate the password...
            Publickey authentication failed..
            (leaveContext 668ms)
        (leaveContext 668ms)
    Failed.
    (leaveContext 670ms)
2023/06/29 11:31:35:412  SSH tunnel failed after 3.09 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:31:35:412  Not accepting
2023/06/29 11:31:35:412  Not connected
2023/06/29 11:31:35:412  initializeSSH (allow pool) took 3.09 seconds.
2023/06/29 11:31:35:412  doConnect databaseClient->connect finished
2023/06/29 11:31:35:412  setDBC: connectionId: 700C85E0-BD4E-4EC7-A58C-1074AE288CE2-9484-0000018CEA89337B
2023/06/29 11:31:35:412  checkSSHFingerprintError returning NO
2023/06/29 11:31:35:413  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/29 11:31:35:413  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:31:35:413  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:31:35:414  Clearing internal database connection details.
2023/06/29 11:31:35:414  setDBC: nil
2023/06/29 11:31:37:990  NSApp sendAction: collectionItemViewDoubleClick
2023/06/29 11:31:37:990  collectionItemViewDoubleClick
2023/06/29 11:31:37:990  connectToConnectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/29 11:31:37:990  connectToRecentConnectionById (not requesting password)
2023/06/29 11:31:37:990  doConnect: cashrent-mariadb-qa2.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/29 11:31:38:000  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:31:38:000  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/29 11:31:38:001  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/29 11:31:38:001  doConnect calling databaseClient->connect
2023/06/29 11:31:38:001  HSSSHTunnelPool - Creating a new connection.
2023/06/29 11:31:38:001  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/29 11:31:38:001  HSChilkatSSHTunnelHelper:connect - ssh authentication methods exist in cache: (
    publickey,
    "gssapi-keyex",
    "gssapi-with-mic"
)
2023/06/29 11:31:38:853  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/29 11:31:38:853  Keydata was found (user previously stored).
2023/06/29 11:31:38:853  SSH:authenticateViaPublicKey - publickey auth path is accessable. Not using bookmark.
2023/06/29 11:31:38:855  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/29 11:31:39:508  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/29 11:31:39:508  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:31:39:508  publickey authentication finished and we are not yet authenticated.
2023/06/29 11:31:39:508  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext 1ms)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext 1ms)
                    myIP: 192.168.1.104
                    myPort: 53191
                    socket connect successful.
                    (leaveContext 205ms)
                (leaveContext 207ms)
            (leaveContext 208ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 208ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.78
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,aes128-gcm@openssh.com,aes256-gcm@openssh.com,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 1ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256
            choose_hostkey_algorithm:
                choose_userauth_rsa_algorithm:
                    (leaveContext)
                (leaveContext 1ms)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 6ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 2ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            (leaveContext)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 33
                s_len: 32
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: D679CF04642A51CD91B37CF9EC43C588B94122C2A22077FB443A7BD373E1DDC52B7E221D397D589063548567B6E6EAE9197B2B958410D00854A9D15745563EA1
                        (leaveContext)
                    (leaveContext 2ms)
                ecdsaSigValid: 1
                (leaveContext 2ms)
            ECDSA host key signature verification success
            (leaveContext 3ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext 1ms)
        (leaveContext 641ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 851ms)
AuthenticatePwPk:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext 1ms)
                ssh-userauth service accepted.
                (leaveContext 205ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 21ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            hostKeyAlg: 3
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Publickey authentication failed..
            (leaveContext 651ms)
        (leaveContext 651ms)
    Failed.
    (leaveContext 652ms)
2023/06/29 11:31:39:508  SSH tunnel failed after 1.51 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:31:39:509  Not accepting
2023/06/29 11:31:39:509  Not connected
2023/06/29 11:31:39:509  initializeSSH (allow pool) took 1.51 seconds.
2023/06/29 11:31:39:509  doConnect databaseClient->connect finished
2023/06/29 11:31:39:509  setDBC: connectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/29 11:31:39:509  checkSSHFingerprintError returning NO
2023/06/29 11:31:39:509  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/29 11:31:39:510  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:31:39:510  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:31:39:510  Clearing internal database connection details.
2023/06/29 11:31:39:510  setDBC: nil
2023/06/29 11:31:43:683  Application is resigning activity.
2023/06/29 11:32:52:321  Application is becoming active.
2023/06/29 11:32:52:869  HSCollectionViewWithKeyEvents:keyDown
2023/06/29 11:32:52:869  SQLProConnectionWindowController:onCancel:
2023/06/29 11:32:52:870  SQLProConnectionWindowController endSheetWithReturnCode: Cancel
2023/06/29 11:32:54:479  applicationWillTerminate
2023/06/29 11:32:54:479  Enter SQLProAppStateHelper::saveStateNow
2023/06/29 11:32:54:479  SQLProAppStateHelper::Want to save state
2023/06/29 11:32:54:479  SaveState: Going to save state for 1 documents.
2023/06/29 11:32:54:482  Saved window rect as: {{91, 185}, {1270, 663}}
2023/06/29 11:32:54:482  Finished actualSaveState
2023/06/29 11:32:54:482  SQLProDatabaseConnectionPool::releaseAllConnections entered.
2023/06/29 11:32:54:482  SQLProDatabaseConnectionPool::releaseAllConnections in resource queue.
2023/06/29 11:32:54:482  SQLProDatabaseConnectionPool::releaseAllConnections waiting for finish.
2023/06/29 11:32:54:482  Took 0.00 seconds to release 0 connections.
2023/06/29 11:32:54:482  HSSSHTunnelPool::disconnectAll entered
2023/06/29 11:32:54:482  HSChilkatSSHTunnelHelper disconnect
2023/06/29 11:32:54:487  HSChilkatSSHTunnelHelper:closeConnection success YES.
2023/06/29 11:32:54:497  HSChilkatSSHTunnelHelper disconnect
2023/06/29 11:32:54:502  HSChilkatSSHTunnelHelper:closeConnection success YES.
2023/06/29 11:32:54:512  HSChilkatSSHTunnelHelper disconnect
2023/06/29 11:32:54:512  HSChilkatSSHTunnelHelper disconnect
2023/06/29 11:32:54:512  HSSSHTunnelPool::disconnectAll finished
2023/06/29 11:32:54:514  Document::close
2023/06/29 11:32:54:514  HSDatabaseTreeView 0x6000028db440 is closing.
2023/06/29 11:34:11:490  


Application com.hankinsoft.osx.sqlprostudio v2023.48 (111048) has launched (from Website).
2023/06/29 11:34:11:490  App startup path is: file:///private/var/folders/dk/4v8y1k9d64l78z6q0_8w5hw40000gn/T/AppTranslocation/204587C1-8BCF-4B17-B342-4F4331309EA0/d/
2023/06/29 11:34:11:491  Initialize themes
2023/06/29 11:34:11:494  Finished initialize themes (took 0.00 seconds.)
2023/06/29 11:34:11:533  applicationPreferencesChanged
2023/06/29 11:34:11:558  RMAppStoreHelper:hasInvalidReceipt - receipt file does not exist.
2023/06/29 11:34:11:562  Application is becoming active.
2023/06/29 11:34:12:035  SQLProDocumentController:setCanOpenUntitledDocument:... true
2023/06/29 11:34:12:036  restoreUIState - Started restoring. App recovery URL is: file:///Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Recovery/AppRecovery.json
2023/06/29 11:34:12:037  Document init called. 0 time.
2023/06/29 11:34:12:072  Document (0x7f9803726650) awakeFromNib.
2023/06/29 11:34:12:073  DatabaseTreeViewController 0x600001665fa0 init
2023/06/29 11:34:12:080  HSOutlineView (0x7f9805172800) awakeFromNib.
2023/06/29 11:34:12:080  Started reloadData
2023/06/29 11:34:12:080  Finished reloadData
2023/06/29 11:34:12:086  HSOutlineView (0x7f98049af200) awakeFromNib.
2023/06/29 11:34:12:087  Started reloadData
2023/06/29 11:34:12:087  Finished reloadData
2023/06/29 11:34:12:088  MainTabViewController::loadView - started
2023/06/29 11:34:12:095  MainTabViewController::loadView - super finished)
2023/06/29 11:34:12:099  MainTabViewController::loadView - finished
2023/06/29 11:34:12:101  Document windowControllerDidLoadNib
2023/06/29 11:34:12:130  Started reloadData
2023/06/29 11:34:12:131  Finished reloadData
2023/06/29 11:34:12:131  Finished restoring UIState.
2023/06/29 11:34:12:168  HSUpdateHelper - Current app version is the latest.
2023/06/29 11:34:12:366  openConnectionDialogWithBlock entered
2023/06/29 11:34:12:372  SQLProConnectionWindowController init.
2023/06/29 11:34:12:445  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:34:12:450  MySQLAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/C03550
2023/06/29 11:34:12:452  PostgresAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/140695
2023/06/29 11:34:12:467  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - DFD106D5-37AC-4034-A4A0-C05BC1462426-6643-0000372EB8D5DD25.json) begin
2023/06/29 11:34:12:475  restoreWindowSize entered.
2023/06/29 11:34:12:475  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:34:12:479  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:34:12:479  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.01 seconds
2023/06/29 11:34:12:479  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - BE5FF488-778E-4603-B6B2-1E00BD217132-13598-0000152C42B7C2A9.json) begin
2023/06/29 11:34:12:494  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:34:12:497  setCollectionEntries with 2 sections (19 entries).
2023/06/29 11:34:12:497  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:497  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:497  HSCollectionViewWithKeyEvents:deselectAll
2023/06/29 11:34:12:497  HSCollectionViewWithKeyEvents:deselectAll
2023/06/29 11:34:12:498  doRefreshConnectionsReloadOnMain started
2023/06/29 11:34:12:498  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:34:12:499  setCollectionEntries with 2 sections (19 entries).
2023/06/29 11:34:12:499  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:499  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:499  doRefreshConnectionsReloadOnMain finished
2023/06/29 11:34:12:499  configureToolbar
2023/06/29 11:34:12:510  MSSQLAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/B4E95C
2023/06/29 11:34:12:514  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:34:12:516  setCollectionEntries with 2 sections (23 entries).
2023/06/29 11:34:12:516  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:516  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:537  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - performance_schema) has 1.560 entries.
2023/06/29 11:34:12:558  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - sys) has 1.117 entries.
2023/06/29 11:34:12:573  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - information_schema) has 813 entries.
2023/06/29 11:34:12:594  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent) has 1.252 entries.
2023/06/29 11:34:12:605  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - mysql) has 330 entries.
2023/06/29 11:34:12:605  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.13 seconds
2023/06/29 11:34:12:605  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - E992E767-8867-4ACC-A193-2092FE3380A8-44712-00018EFFB5723143.json) begin
2023/06/29 11:34:12:608  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:34:12:610  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:34:12:634  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent) has 1.201 entries.
2023/06/29 11:34:12:634  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.03 seconds
2023/06/29 11:34:12:634  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - B76A4AE1-630C-4DBB-AC6C-3C99BC37B666-91994-00000DCFC1C3A8A3.json) begin
2023/06/29 11:34:12:634  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:34:12:636  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:34:12:636  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:34:12:636  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - F7ECA8B6-ACFE-4F13-BCBF-D6EE8A4B4CC6-4063-00001C1E0874A45D.json) begin
2023/06/29 11:34:12:664  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent_staging) has 1.201 entries.
2023/06/29 11:34:12:690  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - information_schema) has 896 entries.
2023/06/29 11:34:12:710  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - test) has 877 entries.
2023/06/29 11:34:12:710  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.07 seconds
2023/06/29 11:34:12:710  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - B099C7E2-C7DC-474D-A650-B583C404DC02-51820-00000844CBF3DA0C.json) begin
2023/06/29 11:34:12:711  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:34:12:712  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:34:12:712  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:34:12:712  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - FF5B1CFB-B197-49F1-ACD6-E9BBE7FF1776-1854-000018B4AAFCF00B.json) begin
2023/06/29 11:34:12:717  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:34:12:718  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:34:12:743  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - cashrent) has 1.252 entries.
2023/06/29 11:34:12:743  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.03 seconds
2023/06/29 11:34:12:743  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - EC55D5FB-FC88-4E19-9C63-80A593A5F51F-456-00000801B6EC0585.json) begin
2023/06/29 11:34:12:743  HSAutocompleteEntryCache - restoreFromDictionaryRepresention HSArrayDivide had no results. Doing nothing.
2023/06/29 11:34:12:744  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper - ) has 0 entries.
2023/06/29 11:34:12:744  HSAutocompleteHelper:loadAutocompleteCacheFromURL (MySQLAutocompleteHelper) took 0.00 seconds
2023/06/29 11:34:12:925  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:34:12:928  setCollectionEntries with 2 sections (23 entries).
2023/06/29 11:34:12:928  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:929  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:929  SQLProConnectionWindowController:updateConnections: entered.
2023/06/29 11:34:12:931  setCollectionEntries with 2 sections (23 entries).
2023/06/29 11:34:12:931  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:12:931  HSCollectionViewWithKeyEvents:reloadData
2023/06/29 11:34:13:312  MongoDBAutocompleteHelper:loadExistingCacheFiles - baseURL is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Caches/AutoComplete/F44336
2023/06/29 11:34:13:340  MongoDBDatabaseClient initialize with v1.18.0-pre.
2023/06/29 11:34:14:945  NSApp sendAction: collectionItemViewDoubleClick
2023/06/29 11:34:14:945  collectionItemViewDoubleClick
2023/06/29 11:34:14:945  connectToConnectionId: 700C85E0-BD4E-4EC7-A58C-1074AE288CE2-9484-0000018CEA89337B
2023/06/29 11:34:14:945  connectToRecentConnectionById (not requesting password)
2023/06/29 11:34:14:945  doConnect: cashrent-mariadb-qa1.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/29 11:34:14:964  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:34:14:964  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/29 11:34:14:965  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/29 11:34:14:976  mysql_library_init result: 0. Client info: 3.3.1. Thread safe: YES.
2023/06/29 11:34:14:977  doConnect calling databaseClient->connect
2023/06/29 11:34:14:978  HSSSHTunnelPool - Creating a new connection.
2023/06/29 11:34:14:978  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/29 11:34:14:978  HSChilkatSSHTunnelHelper:connect - getting ssh authentication methods.
2023/06/29 11:34:15:845  HSChilkatSSHTunnelHelper:connected with banner [], identifier: [SSH-2.0-OpenSSH_8.7]
2023/06/29 11:34:16:484  HSChilkatSSHTunnelHelper:connect - got auth methods from ssh server. (publickey|gssapi-keyex|gssapi-with-mic)
2023/06/29 11:34:16:485  HSChilkatSSHTunnelHelper:connect - using uncommon options: ForceUserAuthRsaSha1, PubkeyOrPassword
2023/06/29 11:34:17:365  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/29 11:34:17:365  Keydata was found (user previously stored).
2023/06/29 11:34:17:374  SSH:authenticateViaPublicKey - publickey auth path via bookmark.
2023/06/29 11:34:17:377  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/29 11:34:18:057  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/29 11:34:18:057  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:34:18:057  publickey authentication finished and we are not yet authenticated.
2023/06/29 11:34:18:057  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext)
                    myIP: 192.168.1.104
                    myPort: 53225
                    socket connect successful.
                    (leaveContext 212ms)
                (leaveContext 215ms)
            (leaveContext 215ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 215ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.78
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,aes128-gcm@openssh.com,aes256-gcm@openssh.com,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 2ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256
            choose_hostkey_algorithm:
                choose_userauth_rsa_algorithm:
                    (leaveContext)
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 6ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 2ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            (leaveContext 2ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 33
                s_len: 33
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: F63FFE21D2AE269051B8A369AB6385CB563D48735E61129A3BC01711680F8279AD15FD028EE479A8C45C2D2203C995160327C94FB1E0EBFAF7E2516ACF218AAC
                        (leaveContext)
                    (leaveContext 2ms)
                ecdsaSigValid: 1
                (leaveContext 3ms)
            ECDSA host key signature verification success
            (leaveContext 3ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext 1ms)
        (leaveContext 662ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 881ms)
AuthenticatePwPk:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext)
                ssh-userauth service accepted.
                (leaveContext 213ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 21ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            hostKeyAlg: 3
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            publickey not accepted, but continuing to authenticate the password...
            Publickey authentication failed..
            (leaveContext 677ms)
        (leaveContext 677ms)
    Failed.
    (leaveContext 678ms)
2023/06/29 11:34:18:057  SSH tunnel failed after 3.08 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:34:18:057  Not accepting
2023/06/29 11:34:18:057  Not connected
2023/06/29 11:34:18:057  initializeSSH (allow pool) took 3.08 seconds.
2023/06/29 11:34:18:057  doConnect databaseClient->connect finished
2023/06/29 11:34:18:057  setDBC: connectionId: 700C85E0-BD4E-4EC7-A58C-1074AE288CE2-9484-0000018CEA89337B
2023/06/29 11:34:18:057  checkSSHFingerprintError returning NO
2023/06/29 11:34:18:058  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/29 11:34:18:058  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:34:18:058  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:34:18:059  Clearing internal database connection details.
2023/06/29 11:34:18:059  setDBC: nil
2023/06/29 11:34:20:395  NSApp sendAction: collectionItemViewDoubleClick
2023/06/29 11:34:20:395  collectionItemViewDoubleClick
2023/06/29 11:34:20:395  connectToConnectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/29 11:34:20:395  connectToRecentConnectionById (not requesting password)
2023/06/29 11:34:20:395  doConnect: cashrent-mariadb-qa2.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/29 11:34:20:405  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:34:20:406  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/29 11:34:20:406  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/29 11:34:20:406  doConnect calling databaseClient->connect
2023/06/29 11:34:20:406  HSSSHTunnelPool - Creating a new connection.
2023/06/29 11:34:20:406  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/29 11:34:20:406  HSChilkatSSHTunnelHelper:connect - ssh authentication methods exist in cache: (
    publickey,
    "gssapi-keyex",
    "gssapi-with-mic"
)
2023/06/29 11:34:21:273  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/29 11:34:21:273  Keydata was found (user previously stored).
2023/06/29 11:34:21:273  SSH:authenticateViaPublicKey - publickey auth path is accessable. Not using bookmark.
2023/06/29 11:34:21:277  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/29 11:34:21:951  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/29 11:34:21:951  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:34:21:951  publickey authentication finished and we are not yet authenticated.
2023/06/29 11:34:21:951  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext 1ms)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext)
                    myIP: 192.168.1.104
                    myPort: 53226
                    socket connect successful.
                    (leaveContext 212ms)
                (leaveContext 213ms)
            (leaveContext 214ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 214ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.78
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,aes128-gcm@openssh.com,aes256-gcm@openssh.com,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext 1ms)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 2ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext 1ms)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext 1ms)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256
            choose_hostkey_algorithm:
                choose_userauth_rsa_algorithm:
                    (leaveContext)
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 6ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 1ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            (leaveContext 1ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 32
                s_len: 32
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: 6CE50E606F9FE7FFCDED2BD0B82475B2290D64D5369B3D75833BC5CBE404D3487EA514D9077F92806E2F75E5A80E9E3D269A9914BB60FD252574E9DBFBD6440C
                        (leaveContext)
                    (leaveContext 2ms)
                ecdsaSigValid: 1
                (leaveContext 2ms)
            ECDSA host key signature verification success
            (leaveContext 3ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext 1ms)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext)
        (leaveContext 647ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 866ms)
AuthenticatePwPk:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    authenticatePwPk:
        login: ec2-user
        sshAuthenticatePk:
            keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
            requestUserAuthService:
                sendServiceRequest:
                    svcName: ssh-userauth
                    SentServiceReq: ssh-userauth
                    (leaveContext 1ms)
                ssh-userauth service accepted.
                (leaveContext 207ms)
            Using an RSA key.
            keyToPublicKeyBlob:
                (leaveContext 1ms)
            dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
            Sent public-key request.
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Proceeding with publickey authentication...
            padAndSignHash:
                keyType: Private
                hashInSize: 20
                padding: PKCS v1.5
                HashOid: 1.3.14.3.2.26
                (leaveContext 28ms)
            rsaSigLen: 512
            Sent public-key request with signature.
            hostKeyAlg: 3
            Authentication failed or partial success. (4)
            PartialSuccess4: 0
            When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
            Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
            AuthList: publickey,gssapi-keyex,gssapi-with-mic
            Publickey authentication failed..
            (leaveContext 673ms)
        (leaveContext 673ms)
    Failed.
    (leaveContext 674ms)
2023/06/29 11:34:21:951  SSH tunnel failed after 1.55 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:34:21:951  Not accepting
2023/06/29 11:34:21:951  Not connected
2023/06/29 11:34:21:951  initializeSSH (allow pool) took 1.55 seconds.
2023/06/29 11:34:21:951  doConnect databaseClient->connect finished
2023/06/29 11:34:21:951  setDBC: connectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/29 11:34:21:951  checkSSHFingerprintError returning NO
2023/06/29 11:34:21:952  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/29 11:34:21:952  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 11:34:21:952  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 11:34:21:953  Clearing internal database connection details.
2023/06/29 11:34:21:953  setDBC: nil
2023/06/29 11:34:27:575  User wants to open logs (111048 2023.48 - Website). Path is: /Users/vercryger/Library/Containers/com.hankinsoft.osx.sqlprostudio/Data/Library/Logs/SQLPro Studio
2023/06/29 11:34:27:654  Application is resigning activity.

[hankinsoft]

One more build to try:

https://sqlprostudio.s3.us-east-1.amazonaws.com/studio/SQLProStudio.2023.49.app.zip

[Vercryger]

One more build to try:

https://sqlprostudio.s3.us-east-1.amazonaws.com/studio/SQLProStudio.2023.49.app.zip

Same thing mate, I'm not even prompted with the fingerprint window, I'm getting that same popup that I reported at the beginning.

2023/06/29 14:10:31:924  Application is becoming active.
2023/06/29 14:10:34:255  NSApp sendAction: collectionItemViewDoubleClick
2023/06/29 14:10:34:256  collectionItemViewDoubleClick
2023/06/29 14:10:34:256  connectToConnectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/29 14:10:34:256  connectToRecentConnectionById (not requesting password)
2023/06/29 14:10:34:256  doConnect: cashrent-mariadb-qa2.cr41om7t5ri7.us-west-1.rds.amazonaws.com (detected port: 22 specified port: 0)
2023/06/29 14:10:34:278  HSDispatchGroup enter com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 14:10:34:278  doConnect calling getHost:andPort:forServer:userSpecifiedPort:
2023/06/29 14:10:34:278  doConnect self->internalDatabaseConnectionDetails createNewClient
2023/06/29 14:10:34:285  mysql_library_init result: 0. Client info: 3.3.1. Thread safe: YES.
2023/06/29 14:10:34:285  doConnect calling databaseClient->connect
2023/06/29 14:10:34:285  HSSSHTunnelPool - Creating a new connection.
2023/06/29 14:10:34:285  (SSH) HSChilkatSSHTunnelHelper:connect called
2023/06/29 14:10:34:285  HSChilkatSSHTunnelHelper:connect - getting ssh authentication methods.
2023/06/29 14:10:35:140  HSChilkatSSHTunnelHelper:connected with banner [], identifier: [SSH-2.0-OpenSSH_8.7]
2023/06/29 14:10:35:783  HSChilkatSSHTunnelHelper:connect - got auth methods from ssh server. (publickey|gssapi-keyex|gssapi-with-mic)
2023/06/29 14:10:36:778  SSHTunnel:keysForHost:port: returning an array (2 entries) of fingerprints.
2023/06/29 14:10:36:778  Keydata was found (user previously stored).
2023/06/29 14:10:36:788  SSH:authenticateViaPublicKey - publickey auth path via bookmark.
2023/06/29 14:10:36:793  HSChilkatSSHTunnelHelper:authenticateViaPublicKey loaded privateKey.
2023/06/29 14:10:36:793  HSChilkatSSHTunnelHelper:authenticateViaPublicKey WITHOUT password.
2023/06/29 14:10:37:644  HSChilkatErrorHelper:errorMessagesFromXML:errorTag:. SearchForTag failed. (null).
2023/06/29 14:10:37:644  HSChilkatSSHTunnelHelper:authenticateViaPublicKey error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 14:10:37:644  publickey authentication finished and we are not yet authenticated.
2023/06/29 14:10:37:644  HSChilkatSSHTunnelHelper tunnel log is:
Connect_SshTunnel:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    hostname: 13.57.226.121
    port: 22
    sshConnect:
        connectSocket:
            domainOrIpAddress: 13.57.226.121
            port: 22
            connectTimeoutMs: 10000
            connect_ipv6_or_ipv4:
                This is an IPV4 numeric address.
                Domain to IP address resolution not needed.
                getAddressInfo:
                    (leaveContext)
                findIpAddrInfo:
                    (leaveContext)
                connecting to IPV4 address...
                ipAddress: 13.57.226.121
                createSocket:
                    Setting SO_SNDBUF size
                    sendBufSize: 262144
                    Setting SO_RCVBUF size
                    recvBufSize: 4194304
                    (leaveContext 1ms)
                connect:
                    Waiting for the connect to complete...
                    connectTimeoutMs: 10000
                    ck_getsockname_ipv4:
                        (leaveContext)
                    myIP: 192.168.1.104
                    myPort: 53381
                    socket connect successful.
                    (leaveContext 214ms)
                (leaveContext 215ms)
            (leaveContext 217ms)
        Established TCP/IP connection with SSH server
        Turning on TCP_NODELAY.
        (leaveContext 217ms)
    sshSetupConnection:
        clientIdentifier: SSH-2.0-PuTTY_Release_0.78
        Sending client identifier...
        Done sending client identifier.
        Reading server version...
        initialDataFromSshServer: SSH-2.0-OpenSSH_8.7

        serverVersion: SSH-2.0-OpenSSH_8.7
        build_kexInit:
            kexPrefList: curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha256,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1
            preferRsaHostKeyAlgorithm: 1
            hostKeyPrefList: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,rsa-sha2-256,rsa-sha2-512,ssh-ed25519,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
            cipherPrefList: chacha20-poly1305@openssh.com,aes128-ctr,aes256-ctr,aes192-ctr,aes128-cbc,aes256-cbc,aes192-cbc,aes128-gcm@openssh.com,aes256-gcm@openssh.com,twofish256-cbc,twofish128-cbc,blowfish-cbc,3des-cbc,arcfour128,arcfour256
            macPrefList: hmac-sha1-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha1,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-sha1-96,hmac-md5,none
            allowCompression: False
            (leaveContext)
        serverKex:
            KeyExchangeAlgs:
                algorithm: curve25519-sha256
                algorithm: curve25519-sha256@libssh.org
                algorithm: ecdh-sha2-nistp256
                algorithm: ecdh-sha2-nistp384
                algorithm: ecdh-sha2-nistp521
                algorithm: diffie-hellman-group-exchange-sha256
                algorithm: diffie-hellman-group14-sha256
                algorithm: diffie-hellman-group16-sha512
                algorithm: diffie-hellman-group18-sha512
                (leaveContext 2ms)
            HostKeyAlgs:
                algorithm: ecdsa-sha2-nistp256
                algorithm: ssh-ed25519
                (leaveContext 1ms)
            EncCS:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            EncSC:
                algorithm: aes256-gcm@openssh.com
                algorithm: chacha20-poly1305@openssh.com
                algorithm: aes256-ctr
                algorithm: aes128-gcm@openssh.com
                algorithm: aes128-ctr
                (leaveContext)
            MacCS:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            MacSC:
                algorithm: hmac-sha2-256-etm@openssh.com
                algorithm: hmac-sha1-etm@openssh.com
                algorithm: umac-128-etm@openssh.com
                algorithm: hmac-sha2-512-etm@openssh.com
                algorithm: hmac-sha2-256
                algorithm: hmac-sha1
                algorithm: umac-128@openssh.com
                algorithm: hmac-sha2-512
                (leaveContext 1ms)
            CompCS:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext)
            CompSC:
                algorithm: none
                algorithm: zlib@openssh.com
                (leaveContext 1ms)
            LangCS:
                (leaveContext)
            LangSC:
                (leaveContext)
            ChosenIncomingEncryption: chacha20-poly1305@openssh.com
            ChosenOutgoingEncryptoin: chacha20-poly1305@openssh.com
            ChosenIncomingMac: hmac-sha1-etm@openssh.com
            ChosenOutgoingMac: hmac-sha1-etm@openssh.com
            ChosenIncomingCompression: none
            ChosenOutgoingCompression: none
            ChosenKexAlgorithm: curve25519-sha256
            choose_hostkey_algorithm:
                choose_userauth_rsa_algorithm:
                    (leaveContext)
                (leaveContext)
            ChosenHostKeyAlgorithm: ecdsa-sha2-nistp256
            (leaveContext 8ms)
        numBits: 256
        pbits: 4096
        Using Curve25519.
        sendCurve25519Init:
            Sent: SSH2_MSG_KEX_ECDH_INIT
            (leaveContext 3ms)
        computeExchangeHash:
            dhReplyMsgType: 31
            serverVersion: [SSH-2.0-OpenSSH_8.7]
            Computing exchange hash for Curve25519
            (leaveContext 2ms)
        verifyHostKey:
            hostKeyAlg: ecdsa-sha2-nistp256
            loadCurveByName:
                name: ecdsa-sha2-nistp256
                (leaveContext)
            curveName: nistp256
            loadEccPoint:
                (leaveContext)
            exportEccPoint:
                (leaveContext)
            eccVerifySig:
                r_len: 33
                s_len: 32
                eccVerifyHash:
                    unpackDsaSig:
                        siglen: 64
                        isAsnSig: False
                        sig: B5A6FDA1D30B1C352DA66C09F182E8901D4C69A10923782DECC5A9F79B9F77910BE7D42148F0265ACA61353316E1B1CC9A90BEB9661665C81BA996767F0C4862
                        (leaveContext 1ms)
                    (leaveContext 3ms)
                ecdsaSigValid: 1
                (leaveContext 3ms)
            ECDSA host key signature verification success
            (leaveContext 4ms)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        calculateKey:
            (leaveContext)
        Sending newkeys to server...
        Expecting newkeys from server...
        SSH Key Exchange Success.
        installNewKeys:
            m_isRekey: 0
            No outgoing compression.
            No incoming compression.
            Outgoing encryption is now chacha20-poly1305@openssh.com
            Incoming encryption is now chacha20-poly1305@openssh.com
            (leaveContext)
        (leaveContext 776ms)
    socketOptions:
        SO_SNDBUF: 263536
        SO_RCVBUF: 4194304
        TCP_NODELAY: 4
        SO_KEEPALIVE: 8
        (leaveContext 1ms)
    Starting tunnel manager thread...
    Tunnel manager thread started.
    Success.
    (leaveContext 995ms)
AuthenticatePK:
    DllDate: Jun 27 2023
    ChilkatVersion: 9.5.0.94
    UnlockPrefix: HNKNSF
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Cocoa Objective-C
    VerboseLogging: 1
    login: ec2-user
    sshAuthenticatePk:
        keyFingerprint: ssh-rsa 4096 d1:25:76:34:d4:29:c2:3d:a0:0c:9e:ed:45:27:1f:9a
        requestUserAuthService:
            sendServiceRequest:
                svcName: ssh-userauth
                SentServiceReq: ssh-userauth
                (leaveContext)
            ssh-userauth service accepted.
            (leaveContext 233ms)
        Using an RSA key.
        keyToPublicKeyBlob:
            (leaveContext)
        dbPkBlob_qp: [=00=00=00=07ssh-rsa=00=00=00=03=01=00=01=00=00=02=01=00=B7#=04=EA=9C=D8=05=DE3=C7=E4=BB=9De=D5=18"=D3=C5=94S=E3=01=F5=16V=C8n=8C=023=D7=CAW=BBP=8E=B0B=D1=A5=A9\=A5=AD=83$=DB=13o=E1=E7=E1GT+8=13	=B5=81 =B46=AD=19B=C6w5=F2=99=E8x=87O=13=95=04rr=1F=80=80=C1=EF=B1=8A=BA=8B=87=D4j>=A7=B7=82%maJU=1DO=16=87D_=A4=89=F8=8Ai>=81=03 q=F3=A7=1B*n=BB=DE-=C8Z=B2=B7=93o=9DV=85=C7=92Yw=80=CDK=B3=90=D5=14=CE=94=B0=AA%=03=83=EEy5=C2xY0=D1=E9=B1=13=0Aa=14'=D2=CC=C77=D6=AA=80=ECnw=FC)=1C^q=FFV=828=D8=B5=07=AF8=1D'=DDU\t0=C9R=DF=EB50=91=ED=E8_=E2=8D=A1z:=0Bi=B30=A8=A6=1D=3D=89*=FC$=97=FB=E3=F9=02=13=190=EF/=E1pd=A1=BD=1F=0A=F7 =8F=C6=97]=16=BA>=A1?=88=B3=0D=98=F0=00=D8=3Dy=C0=81=FC=F9F=C5=99=BB=A2=DA=F0,U"=DB=18=97!=B0L.d-=8E=BC5,V=AD=0Fcs=CE=FBY@=04{=E0=7F0=FD=E8=C6=A6D=C0_=9E=CA=BB=88=92=A3=00=9Dm=0Br=F0=CE#~^=C5=E9.t=A7[Q=F6x q=ED=E3e=8D=A4=BE=FD=EA=86=C8Udq=80\=E3O3=AB"=A3b=16=AD=A7=93=B3=C0=95=05=81Y=AF=86^=19B?o8=0EsE=AA=0B=A3=C3`v=DC=04o=B3=ECZ=8C=84{=04=F2c=B6%GnA=BD=06=9E=E3=A5b:=CC=C5=F8=7F=AE'=07c=01=89&=D3=DA=C3#=A8=14`=F8=BF=EF=FD=D2I4d=F2=92'U=A3<=F6=F6=CC=B0=D0=A8=CFePb3y=FD=FC=BE-=F8=B2=1A=3D=14=1C=0B=B0BR=91'=FCW=90=FF=C7=94ad=B9=1B=F71w=81=94@=CA=0A:=94=98	P=DC*e=E6=1A=BD=8BU`h7ql=BDq=CD:W]
        Sent public-key request.
        AuthList: publickey,gssapi-keyex,gssapi-with-mic
        Proceeding with publickey authentication...
        padAndSignHash:
            keyType: Private
            hashInSize: 20
            padding: PKCS v1.5
            HashOid: 1.3.14.3.2.26
            (leaveContext 28ms)
        rsaSigLen: 512
        Sent public-key request with signature.
        hostKeyAlg: 3
        Authentication failed or partial success. (4)
        PartialSuccess4: 0
        When partial success is 0, it means you are not using the correct private key that corresponds to the public key installed in the SSH user account.
        Also, to force Chilkat to continue with password authentication even if the public-key authentication fails, set UncommonOptions = "PubkeyOrPassword".
        AuthList: publickey,gssapi-keyex,gssapi-with-mic
        Publickey authentication failed..
        (leaveContext 848ms)
    Failed.
    (leaveContext 850ms)
2023/06/29 14:10:37:644  SSH tunnel failed after 3.36 seconds with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 14:10:37:644  Not accepting
2023/06/29 14:10:37:644  Not connected
2023/06/29 14:10:37:644  initializeSSH (allow pool) took 3.36 seconds.
2023/06/29 14:10:37:644  doConnect databaseClient->connect finished
2023/06/29 14:10:37:645  setDBC: connectionId: 01096F30-568C-429F-ABE6-A0FC1DCF419F-39459-000005373454A154
2023/06/29 14:10:37:645  checkSSHFingerprintError returning NO
2023/06/29 14:10:37:646  SQLProConnectingWindowController endSheetWithReturnCode: OK
2023/06/29 14:10:37:646  HSDispatchGroup leave com.hankinsoft.connectionWindowDispatchGroup
2023/06/29 14:10:37:646  Failed to connect with error: Failed to authenticate via private key. Authentication failed or partial success. (4)
2023/06/29 14:10:37:647  Clearing internal database connection details.
2023/06/29 14:10:37:647  setDBC: nil
2023/06/29 14:10:46:979  Application is resigning activity.

[hankinsoft]

Same thing mate, I'm not even prompted with the fingerprint window, I'm getting that same popup that I reported at the beginning.

That part should be ok, once you approve the fingerprint it shouldn't need to be approved again.

That said, unfortunately I'm running out of ideas. Going to need a bit more of a think for this. To confirm when you do a connection via the command line you are just using publickey authentication correct? gssapi is not being used anywhere?

[hankinsoft]

Also, is there any chance your .pem file has been modified at all since initial setting up SQLPro? It's possible SQLPro is using a cached instance. If there is a chance your pem file has been modified, could you try setting up a new connection and seeing if that helps?

[Vercryger]

Also, is there any chance your .pem file has been modified at all since initial setting up SQLPro? It's possible SQLPro is using a cached instance. If there is a chance your pem file has been modified, could you try setting up a new connection and seeing if that helps?

Yeah it came to my mind as well, but I tried and I got the same error.

That said, unfortunately I'm running out of ideas. Going to need a bit more of a think for this. To confirm when you do a connection via the command line you are just using publickey authentication correct? gssapi is not being used anywhere?

It's understandable, and yes, I'm not using gssapi or anything, just the classic pubkey certificate authentication. Weird is though, I've never had this issue in my lifetime, and I've been using SQLPro for years now. Tried as well using dbeaver, and the connection goes well there, so likewise, I'm not sure what's going on with that particular certificate (generated by AWS).

Anyways, thanks for looking into it, I'll keep an eye to this issue just in case you ever find something.

[hankinsoft]

FYI I have not come up with any more details regarding this. If you have purchased via the website I can offer a refund? Unfortunately I cannot refund App Store purchases, but you could contact apple and request one. What would your preferred go-forward route for this be?

[Vercryger]

@hankinsoft Hey, that's okay, no need for a refund, I'm good with it. I've been comfortable using it for almost 5 years already, just found this only isolated case where the connection didn't work, I found some other workarounds. Thanks for the heads up though.

[hankinsoft]

Ok! Thanks for letting me know. I'm going to close this as I don't expect a different resolution.

Cheers!