(Excel) SFTP Authenticate Secure

Demonstrates how to do SFTP 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
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 sftp As Chilkat.SFtp
Set sftp = Chilkat.NewSFtp

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

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

Debug.Print "SFTP Authentication successful."

sftp.Disconnect