(Excel) SSH Tunnel Authenticate Secure

Demonstrates how to do SSH password authentication with secure strings.

This example requires Chilkat v9.5.0.71 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' Imagine we've previously saved our encrypted login and password within a JSON config file
' that contains this:

' {
'   "ssh_login": "2+qylFfC56Ck7OQQt/U2/w==",
'   "ssh_password": "5neIq9Jmn0E3p71N6Yc8TA=="
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.LoadFile("qa_data/passwords/ssh.json")

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

' These are the encryption settings we previously used to encrypt the credentials within the JSON config file.
crypt.CryptAlgorithm = "aes"
crypt.CipherMode = "cbc"
crypt.KeyLength = 128
crypt.SetEncodedKey "000102030405060708090A0B0C0D0E0F","hex"
crypt.SetEncodedIV "000102030405060708090A0B0C0D0E0F","hex"
crypt.EncodingMode = "base64"

Dim ssLogin As Chilkat.SecureString
Set ssLogin = Chilkat.NewSecureString
Dim ssPassword As Chilkat.SecureString
Set ssPassword = Chilkat.NewSecureString

' Decrypt to the secure string.  (the strings will still held in memory encrypted, but are now encrypted using
' a randomly generated session key.)
success = crypt.DecryptSecureENC(json.StringOf("ssh_login"),ssLogin)
success = crypt.DecryptSecureENC(json.StringOf("ssh_password"),ssPassword)

Dim tunnel As Chilkat.SshTunnel
Set tunnel = Chilkat.NewSshTunnel

success = tunnel.Connect("MY-SSH-SERVER-DOMAIN-OR-IP",22)
If (success <> True) Then
    Debug.Print tunnel.LastErrorText
    Exit Sub
End If

' Authenticate using secure strings
success = tunnel.AuthenticateSecPw(ssLogin,ssPassword)
If (success <> True) Then
    Debug.Print tunnel.LastErrorText
    Exit Sub
End If

Debug.Print "SSH Tunnel Authentication successful."

' ...

success = tunnel.CloseTunnel(True)