(Excel) IMAP over Multiple Hop SSH

Demonstrates how to read IMAP email (using TCP or TLS) tunneled through mulitple-hop SSH. The scheme looks like this:

Application => ServerSSH1 => ServerSSH2 => IMAPServer

The ConnectThroughSsh and UseSsh methods are added in Chilkat version 9.5.0.55 to accomplish this task.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim ssh1 As Chilkat.Ssh
Set ssh1 = Chilkat.NewSsh

' Connect directly to the 1st SSH server.

success = ssh1.Connect("serverssh1.com",22)
If (success <> True) Then
    Debug.Print ssh1.LastErrorText
    Exit Sub
End If

' Authenticate using login/password:
success = ssh1.AuthenticatePw("ssh1Login","ssh1Password")
If (success <> True) Then
    Debug.Print ssh1.LastErrorText
    Exit Sub
End If

' Connect through the 1st SSH connection to reach a 2nd SSH server.
' Note: Any number of SSH connections may be simultaneously tunneled through a single
' existing SSH connection.
Dim ssh2 As Chilkat.Ssh
Set ssh2 = Chilkat.NewSsh
success = ssh2.ConnectThroughSsh(ssh1,"serverssh2.com",22)
If (success <> True) Then
    Debug.Print ssh2.LastErrorText
    Exit Sub
End If

' Authenticate with ssh2...
success = ssh2.AuthenticatePw("ssh2Login","ssh2Password")
If (success <> True) Then
    Debug.Print ssh2.LastErrorText
    Exit Sub
End If

Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

' Tell the IMAP object to connect to the IMAP server though the ssh2 tunnel (which itself is routed through ssh1).
' The connection looks like this:  Application => ServerSSH1 => ServerSSH2 => IMAPServer
success = imap.UseSsh(ssh2)
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

imap.Ssl = True
imap.Port = 993

' Connect to an IMAP server (through the multi-hop SSH tunnel)
success = imap.Connect("imap.someimapserver.com")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Login
success = imap.Login("myLogin","myPassword")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Do whatever needs to be done...  for example,

' Create the new email folder (sub-mailbox) on the IMAP server.
' If no folder path is provided, the new folder is a sub-mailbox of Inbox.
success = imap.CreateMailbox("newFolder")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

Debug.Print "Success."

' Close the connection with the IMAP server.  (This closes the tunnel through ssh2)
' The connection with ssh2 is still alive, and may be used for more connections.
success = imap.Disconnect()

' Close the connection with ssh2.  (This closes the the tunnel through ssh1.)
' The connection with ssh1 is still alive, and may be used for more connections.
ssh2.Disconnect 

ssh1.Disconnect