To setup a SSH tunnel, a public ssh key must be added to the machines users ~/.ssh/authorized_key file. Below is the public key to add.
# Please contact support@tractorscope.com to obtain the public key.
Then add the database to Tractorscope’s interface. The user name that the SSH key is installed for will need to be used in the SSH user input
Depending on the machines settings, you may need to add the following to enable RSA key authentication.
Edit
/etc/ssh/sshd_config
file and add the following:# Adding for tractorscope rsa ssh key
PubkeyAcceptedAlgorithms +ssh-rsa# Adding for tractorscope rsa ssh key
PubkeyAcceptedAlgorithms +ssh-rsaAfter you have made that change, restart sshd with
systemctl restart sshd
You should be connecting through the SSH tunnel now.
FAQ
When do I need an SSH tunnel for a database connection?
Use an SSH tunnel when the database is on a private network or is not directly reachable from Tractorscope.
Where does the Tractorscope public key need to be installed?
Install the public key in the
~/.ssh/authorized_keys
file for the user account that will accept the SSH connection.Which SSH username should I enter in Tractorscope?
Use the username for the account where you installed the Tractorscope public key.
Why would I need to change PubkeyAcceptedAlgorithms?
Some SSH servers reject RSA keys by default. Adding
PubkeyAcceptedAlgorithms +ssh-rsa
can allow the connection if your server requires that compatibility setting.