Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SSH Private Key Problem: "The file couldn't be opened" #633

Closed
oander11 opened this Issue Feb 4, 2019 · 4 comments

Comments

Projects
None yet
2 participants
@oander11
Copy link

oander11 commented Feb 4, 2019

Hi,
I've been using Postico for several years, and I find it great, thanks for the good work!

I've never had any issues connecting to DBs until today, and I can't really figure it out.

What I have

I have a DB deployed in an AWS EC2 instance. I connect to the DB from Postico 1.4.2 on a Mac running High Sierra via SSH, pointing out the private key from the Postico settings, like ~/xx.pem.

xx.pem only contains:
-----BEGIN RSA PRIVATE KEY-----
etc. etc.
-----END RSA PRIVATE KEY-----

This works just fine!

I now have a new Mac, with Mojave, and Postico 1.5.4. I have the same xx.pem key but when I try to select it in Postico I get a The file couldn't be opened prompt.

Maybe this is some change in Postico 1.5 vs 1.4 but since I can't find 1.4 as a legacy version I haven't been able to downgrade and verify (and I don't dare upgrading on my old machine which still works). Or maybe this has to do with some change in OS X between High Sierra and Mojave.

Unfortunately my knowledge of SSH certificates and keys are too limited to further understand what could be wrong. I have used Postico on other machines too without issue so maybe this points to some change between versions 1.4 and 1.5?

Hope for some help.
Thanks
/ola

@jakob

This comment has been minimized.

Copy link
Owner

jakob commented Feb 4, 2019

This is most likely an issue with the keychain.

Things that may fix the issue:

  1. Restart your Mac
  2. Create a new user account
  3. Redownload Postico

See this thread for more info:
https://forums.developer.apple.com/thread/46583

@oander11

This comment has been minimized.

Copy link
Author

oander11 commented Feb 4, 2019

@jakob jakob changed the title ssh connection issue SSH Private Key Problem: "The file couldn't be opened" Feb 4, 2019

@jakob

This comment has been minimized.

Copy link
Owner

jakob commented Feb 4, 2019

Thank you!

You're not the first to report the issue, so I'm going to leave this issue open for now. We should probably at least change the error message.

@jakob

This comment has been minimized.

Copy link
Owner

jakob commented Feb 12, 2019

We just released Postico 1.5.5 which has better error messages when bookmark creation fails (and it suggests to restart your Mac, so people don't need to contact customer support).

Thanks for reporting this!

@jakob jakob closed this Feb 12, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.