Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Aqua Data Studio includes a an SSH Environment - an interactive Unix-like command-line interface. SSH is used for remote login and secure communications with remote servers over unsecured networks. The SSH interface is integrated in the IDE and utilizes all Aqua Data Studio GUI capabilities such as a tabbed window interface, customized tabs, search functions, keyboard mapping, docking framework, and Shortcut Toolbar shortcuts. Advanced Server Properties also allow the use of Private Key Authentication.

...

SSH Server Registration in Aqua Data Studio

SSH - New Server GroupImage RemovedImage Added

SSH - New Server Group NameImage RemovedImage Added

SSH - Register ServerImage RemovedImage Added

SSH - Register Server DialogImage RemovedImage Added

SSH - Register Server - RegisteredImage RemovedImage Added

SSH - Register Server - OpenImage RemovedImage Added

New Server GroupGroup NameRegister SSH ServerEnter Server DetailsServer RegisteredOpen Server

...

Troubleshooting Registrations

SSH Troubleshooting - Username and PasswordImage RemovedImage Added

SSH Troubleshooting - PingImage RemovedImage Added

User name and
Password
Click on Ping

...

Tip : Tick the ’Save Password’ check box and you may quickly connect to a an SSH Server server without having to type in the authentication every time you Open.

...


How to register a an SSH Server Clone

SSH - Register Server Clone

SSH Server - Register SSH Server Clone - DialogImage RemovedImage Added

Right Click ServerSpecify Name

 To create aan SSH Server Clone of an already Registered Server, in Aqua Data Studio:

  • Locate the Server in the Server Browser.
  • Right Click -click on the Server - A Popup Menu Appears. ( or select Server - Register Server Clone from the Main Application Menu once a server in the list is highlighted )
  • Click on the Item which displays Register SSH Server Clone.
  • Once you provide a new name for the clone, a new SSH Server is registered.

...

Using Aqua Data Studio to open a an SSH Server

SSH - Locate ServerImage RemovedImage Added

SSH - Server OpenImage RemovedImage Added

SSH - Server OpenedImage RemovedImage Added

Locate the ServerPopupConnected

...

  • Locate the SSH Server in the Server Browser
  • Select the SSH Server
  • Right Click -click on the SSH Server - A Popup Menu Appears. Click on Open.

...

Once a connection succeeds, the Connection Toolbar becomes visible. It includes buttons which that allow you to Reconnect, Copy selected text, Paste text from the clipboard, Find text, and edit Options.

The Options button allows changing the Font, History Buffer Size, Tab Size as well as the Foreground, Background, and Selection Background colors. Changes made to the Options take affect effect immediately.

SSH Terminal OptionsImage RemovedImage Added

SSH - Find in BufferImage RemovedImage Added

SSH Terminal
Options
SSH Terminal
Find in Buffer

...

  • Locate the server in the Servers Browser
  • Right Click on the Server - A Popup Appears
  • Click on the item which displays Properties
  • Go to the Advanced Tab and make changes

SSH Server - Right Click - PropertiesImage RemovedImage Added

SSH Server Properties - Advanced Image RemovedImage Added

SSH Server
Right Click
SSH Server
Advanced Properties

...

  1. Click the Generate button
  2. Enter a Key Passphrase
  3. Confirm the Key Passphrase
  4. Save the Private Key (the file will have the extension .ppk). It's this file you would browse to in the SSH Server Advanced Properties - Authentication: Private Key File.
  5. Save the Public Key or Copy the Public Key by clicking the Copy to Clipboard button. This must be pasted into an OpenSSH authorized_keys file on the SSH Server.

Key Generator for authorized_keys fileImage RemovedImage Added

Key Generator for Private Key
Authorization

 

...

Once you enter the passphrase at the prompt, the passphrase is kept in application memory until Aqua Data Studio is closed. As long as you do not close Aqua Data Studio the cached passphrase will be used each time you connect to the server.

SSH Key Agent - Passphrase CachingImage RemovedImage Added

Key Agent for caching
key passphrase in memory

...