Connecting to a Linux Machine

SQL Monitor uses SSH to connect to a Linux host. You can either use SSH credentials or an SSH key to connect to the host. 

  1. Go to the Configuration page and, under Estate, select Monitored servers.
  2. Click Add > SQL Server or Add > PostgreSQL. The Add Server panel expands.
  3. Select Linux as the host operating system.
  4. Enter the machine IP or hostname, under the machine name. SQL Monitor adds the instance that is running on the machine.
  5. Under the section Machine, select the authentication method for connecting to the machine:
    1. SSH key
    2. SSH username and password

Using SSH key

 For more information on SSH keys, including how to generate them, see SSH Keys overview.

Adding a Linux machine using SSH keys

  1. Select the authentication method as "SSH key":
  2. Select the applicable SSH key from a list of all the SSH keys added to the active basemonitor.
  3. Provide the user account name, with which SQL Monitor will connect to the host machine.

    SQL Monitor supports the following private key formats:

    • RSA in OpenSSL PEM and ssh.com format
    • DSA in OpenSSL PEM and ssh.com format
    • ECDSA 256/384/521 in OpenSSL PEM format
    • ECDSA 256/384/521, ED25519 and RSA in OpenSSH key format

Adding an SSH key to the base monitor

  1. Go to the Configuration page, under Estate, select Secure Shell (SSH) keys.
  2. You will be taken to Manage SSH key page. Click New SSH key. You are redirected to the Add SSH key page:
    1. Give an identfiable name as per your choice to the key in the "Name" field
    2. Select the base monitor on which you'd like to add this key.
    3. Choose how you would like to input the private key, upload a file or paste the key text.
    4. Either upload or paste your key in the private key field.
    5. Finally, enter a passphrase if applicable to the key provided.
  3. Upon successful addition, you'll be redirected back to the Manage SSH key page, with the newly added key displayed in a grid, as shown below.
  4. You should now be able to see the newly added key on the Add Server page:

           

Using SSH username and password

You will need to select the authentication method as "SSH username and password", under the Machine section. Continue by providing the SSH username and password in the fields that will be presented.


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?