Can't connect Sequel Pro to Forge

Did you use the DB and SSH passwords that Forge sent you in the email?

Yeah, thanks. I've had the credentials saved as a favorite connection in Sequel Pro for a long time.

Are you connecting through the "SSH" tab? Sorry for the questions but I had similar issues in the past because I forgot to use the SSH tab to connect.

Yeah I am. No problem, I appreciate you trying to help.

Here is a screenshot if that helps.

https://cl.ly/iccH

Thanks, mine looks like that too, except for the SSH key I've got ~/.ssh/id_rsa.pub instead of a password.

Here's the end of the error details it's giving me:

debug1: read_passphrase: can't open /dev/tty: Device not configured debug1: permanently_drop_suid: 505 debug1: No more authentication methods to try. Permission denied (publickey).

That is strange. I wonder if you have to register that new key with forge in the ssh section? Just grabbing at straws here.

I think you're right, but I'd already done that in order to SSH into Forge from the command line.

Hi @JennySwift. Did you ever solve your issue? I'm experiencing the same problem (can no longer connect to my Forge database via Sequel Pro).

It's really weird-I tried again just recently and it just worked. I don't know why. It worked just after I ran ssh-add ~/.ssh/id_rsa. Not sure how that would explain it, though.

Hi @JennySwift and @ejdelmonico,

I found a resolution to my issue – hopefully it'll help with yours.

From the command line – I was originally in ~/.ssh but I'm not sure it makes a difference – run:

ssh-add -l

If you see the following output…

The agent has no identities.

…run:

ssh-add

You may be prompted to enter your passphrase for your private key…

Enter passphrase for /Users/[username]/.ssh/id_rsa:

…in which case, enter your key passphrase and press enter.

You should see something similar to the following output:

Identity added: /Users/[username]/.ssh/id_rsa (/Users/[username]/.ssh/id_rsa)

You can confirm your identity was added by re-running ssh-add -l, which should return something similar to the following output:

4096 SHA256:1234ABCabcETC /Users/[username]/.ssh/id_rsa (RSA)

At this point, try connecting to your Forge database again through Sequel Pro.

With any luck, you'll reconnect without issue.

Good luck!

@JennySwift Haha, looks like we discovered the same resolution. Thanks!

Glad it's working for you. :) I'm still not sure why it stopped working in the first place, because I think I'd already done that previously.

Excellent it works perfect ;)

This worked for me @jamesfurey. Thanks so much!

Thanks @jamesfurey, life saver!