Dbeaver CE Ubuntu snap can't read SSH key in ~/.ssh

[kaincenteno]

System information:

• Operating system (distribution) and version
  Ubuntu 20.04
• DBeaver version
  7.2.2.202010041557
• Additional extensions

Connection specification:

• Database name and version
• Driver name
• Do you use tunnels or proxies (SSH, SOCKS, etc)?
  SSH

Describe the problem you're observing:

When trying to create a connecting, if you try using a private key that lives in ~/.ssh it won't allow you to

Steps to reproduce, if exist:

Include any warning/errors/backtraces from the logs

[uslss]

thanks for the bug report

[benzkji]

this is probably because of the security restrictions that are enforced, when using snap? agent does not work either, here.

[AlainBenbassat]

The solution is to give DBeaver permission to access the ssh folder.

• Open the "Ubuntu Software" app
• click on the tab "Installed"
• click on "dbeaver-ce"

• then click on the "Permissions button"

• enable "ssh-keys: allows reading ssh user configuration and keys"

[ndlarsen]

Consider editing the snap so it's installable with the --classic argument. This also enables retaining configurations then uninstalling the snap.

[riednyko]

For reading private keys in ~/.ssh you need to manually connect the plugin
sudo snap connect dbeaver-ce:ssh-keys for access to private keys
and
sudo snap connect dbeaver-ce:ssh-public-keys for access to public keys.

Or you can use the solution written above by @AlainBenbassat