Connecting to SSH using TestComplete (Used Paramiko but is erroring out)

sonya_m  AlexKaras 

Finally I was able to implement Paramiko on Test Complete (Python 3.6) successfully.

Please find the instructions below (Readability is better if the instructions file is opened using Notepad++) :-

Note:- The understanding is that Test Complete is running Python 3.6
            Running Test Complete from the Desktop shortcut defaults to opening the 64-bit version of Test Complete.
            The instructions here explains how to Implement Paramiko on the 64-bit version of Test Complete.

(1) Copy all the contents from "Required Libs for Paramiko" and paste it to the below path:-
C:\Program Files (x86)\SmartBear\TestComplete 14\x64\Bin\Extensions\Python\Python36\Lib

(2) Copy the file "_cffi_backend.cp36-win_amd64.pyd" from the folder "Copy the content to DLL" and paste it to the below path:-
C:\Program Files (x86)\SmartBear\TestComplete 14\x64\Bin\Extensions\Python\Python36\DLLs

(3) Done, the required files for Paramiko have been successfully loaded.

(4) Please find a sample Paramiko script below. Feel free to use any script as desired.

===========================================================

import paramiko

def execSSH(host, user, passwd, command, filename):
  ssh_client = paramiko.SSHClient()
  ssh_client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
  #Establishes a SSH connection with the given details.
  ssh_client.connect(hostname=host, username=user, password=passwd)
  #The SSH commands are executed one by one. Please note that only the last command's 
  #output is saved to the output file. The file is currently saved to the current 
  #present-working-directory (pwd) of the remote server.
  stdout = ssh_client.exec_command(command + " > " + filename)
  #SFTP connection is opened. This is for copying the file from the remote server to our 
  #local machine.
  sftp_client = ssh_client.open_sftp()
  #The created output file is copied from the remote server to our local machine.
  #Please note that the remote-server-path is the present-working-directory (pwd), if 
  #you give otherwise the file-save will fail.
  #Syntax:- 
  #sftp_client.get("<remote-server-path>" + filename, "<local-machine-path>" + filename)
  sftp_client.get("/mnt/AMPBackup/" + filename, "C:\\Users\sabraham\Desktop\\" + 
  filename)
  #The output file is deleted from the remote server since it was copied over to the 
  #local machine.
  sftp_client.remove("/mnt/AMPBackup/" + filename)
  #Close the SFTP and SSH connections
  sftp_client.close()
  ssh_client.close()

if __name__ == '__main__':
  #The variable command holds the various SSH commands we would like to execute one-by- 
  #one on the remote server.
  #Syntax:- command = 'command_1; command_2; command_3; etc....'
  command = 'cd /mnt/AMPBackup/; ls'
  #SSH function call
  execSSH("121.0.0.1", "user_auth", "pass1",command,"outputfile.txt")

===========================================================