(Excel) SSH Commands to Sophos Router Device Console

Demonstrates how to establish an SSH session with a Sophos XG router and send commands in a device console session.

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 ssh As Chilkat.Ssh
Set ssh = Chilkat.NewSsh


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

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

' Start a shell session.
' (The QuickShell method was added in Chilkat v9.5.0.65)

channelNum = ssh.QuickShell()
If (channelNum < 0) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' The Sophos router will send this initial prompt:

' 	Main Menu
' 
' 	    1.  Network  Configuration
' 	    2.  System   Configuration
' 	    3.  Route    Configuration
' 	    4.  Device Console
' 	    5.  Device Management
' 	    6.  VPN Management
' 	    7.  Shutdown/Reboot Device
' 	    0.  Exit
' 
' 	    Select Menu Number [0-7]: 

success = ssh.ChannelReceiveUntilMatch(channelNum,"Select Menu Number","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Show what we received so far:
Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

' Send "4" <RETURN> to mimic typing in a shell session.
success = ssh.ChannelSendString(channelNum,"4" & vbLf,"utf-8")
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' We should get a "console>" prompt.
success = ssh.ChannelReceiveUntilMatch(channelNum,"console>","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

' Send a command and get the output..
success = ssh.ChannelSendString(channelNum,"dnslookup host google.com" & vbLf,"utf-8")
success = ssh.ChannelReceiveUntilMatch(channelNum,"console>","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

' Send another command and get the output, and so on...
success = ssh.ChannelSendString(channelNum,"dnslookup host microsoft.com" & vbLf,"utf-8")
success = ssh.ChannelReceiveUntilMatch(channelNum,"console>","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

ssh.Disconnect