#Unable to use ssh key with SQL GUI

1 messages · Page 1 of 1 (latest)

ionic sandal
#

I'm trying to use DBeaver on Ubuntu 22. The DB I'm trying to connect to needs my ssh key, but when I try to connect, I get the error:

Can't initialize tunnel
  Cannot run program "ssh-keygen": error=13, Permission denied
    error=13, Permission denied

My .ssh folder has permissions at 700 and the key itself is at 644. Short of setting the folder and key to 777, which I obviously won't do, I can't figure out 1) what's wrong, and then 2) how to fix it.

thorn trail
ionic sandal
#

Sorry, yes, 22.04. I used the software gui that came with Ubuntu. I admit I don't love it either, it was just the best free gui I found. I'm happy to take a suggestion on an alternative, and I probably should just pay for one.

#

I didn't think it being a sub par software would lead to permissions issues.

thorn trail
#

Beekeeper Studio is what I use.

thorn trail
#

So, "Software GUI" suggests snap, which suggests sandboxing, which ... IN snaps, this is eww.

ionic sandal
#

Ah. Not something I was aware of.

#

Sorry if the answer was unclear, it was just the best I could make.

thorn trail
#

Snaps sandboxing is a major pain of bad design. Flatpak at least allows more granular control when and where needed/.

ionic sandal
#

OK, it's sounding like I need to learn about snap vs flatpak.

#

Which is fine

thorn trail
#

And possibly Beekeeper Studio (which is free, but has a paid for version as well, but it's not really too benefitial to yourself, unless you want to support the developers)

ionic sandal
#

I do use apt-get through the cli, but I figured since the gui came prepackaged, I should use that.

#

If it's good software, I do usually go for the paid version to support.

thorn trail
#

Yeah, Beekeeper Studio has an AppImage, and it's also in Flathub flatpak repo.

ionic sandal
#

OK, so sounds like it's not something I actively screwed up, but rather my lack of knowledge.

#

I'll study up on snap vs flatpak, and look at alternatives to dbeaver.

#

Does that sound accurate?

thorn trail
#

Yep.