Sequel Pro SSH tunnel about scotch-box HOT 50 CLOSED

This is what worked for me:

I had to delete the old line from known_hosts. You can safely delete the file:

rm ~/.ssh/known_hosts

Note: I ran vagrant ssh-config and it gave me port 2222 and I put it in Sequel Pro but it didn't connect. It only worked when I removed 2222.

from scotch-box.

Type: vagrant ssh-config

from scotch-box.

For me I needed to update the Sequel Pro client. This bug caused the issue:
sequelpro/sequelpro#2141

from scotch-box.

I had some strange formatting errors in my ssh 'known-hosts' file. Fixing these allowed me to ssh in without a problem. For those new to these issues, I recommend reading the 2.0 release announcement page here.

from scotch-box.

Yeah, the same issue as the original poster. I didn't see any solution in the thread other than using the vagrant key. Which is fine, but that would warrant an update to documentation, correct? Is that the recommended solution?

If I'm understanding correctly, @sakanaproductions had a typo just in his bug report, but he actually has the correct values in Sequel Pro. I have triple checked my values as well, and host key verification is failing.

See my comment at #38 (comment)

Thanks!

from scotch-box.

For anyone still having this issue, the answer might be pretty straight forward, as it was for me... once I saw the magic clue.

Host default
  HostName 127.0.0.1
  User vagrant
  Port 2222
  UserKnownHostsFile /dev/null
  StrictHostKeyChecking no
  PasswordAuthentication no
  IdentityFile [snip]
  IdentitiesOnly yes
  LogLevel FATAL

Port 2222!

Set the SSH port to 2222 in Sequel Pro, and I'm in!

Hope this helps!

from scotch-box.

I had to use 127.0.0.1 for the SSH Host. Is this normal?

from scotch-box.

Thank you @pendashteh , deleting the old line form known_hosts was the key for me. I'm in!

from scotch-box.

Note that if you use SSH key pairs for other connections, you will be deleting all of your known hosts. I like to shorten my ssh host names, so this is not something I would want to do. The alternative is to open known_hosts in a text editor and see if any obvious issues pop out.

from scotch-box.

I'm not sure if you have a typo, but the MySQL hostname should be
127.0.0.1

You have
127.0.01

from scotch-box.

Yeah, it was just a typo :)

Jamie Fishback
(323)393-3474
[email protected]
http://www.jamiefishback.com

This e-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Thank You.

On Mon, Feb 16, 2015 at 6:28 PM, Jason Jones [email protected]
wrote:

I'm not sure if you have a typo, but the MySQL hostname should be
127.0.0.1

You have
127.0.01

—
Reply to this email directly or view it on GitHub
#38 (comment).

from scotch-box.

So, are we good to to close this?

from scotch-box.

I think we're good to go.

from scotch-box.

No, it was a typo on github not on sequel pro

Jamie Fishback
(323)393-3474
[email protected]
http://www.jamiefishback.com

This e-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Thank You.

On Tue, Feb 17, 2015 at 8:07 AM, Nicholas Cerminara <
[email protected]> wrote:

So, are we good to to close this?

—
Reply to this email directly or view it on GitHub
#38 (comment).

from scotch-box.

I see, where is the typo so I can correct it? I seem to missing it when I look over the github docs.

Here is a image of the current settings:

from scotch-box.

The typo is in my bug report not in your documents.

Jamie Fishback
(323)393-3474
[email protected]
http://www.jamiefishback.com

This e-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Thank You.

On Tue, Feb 17, 2015 at 8:27 AM, Jason Jones [email protected]
wrote:

I see, where is the typo so I can correct it? I seem to missing it when I
look over the github docs.

Here is a image of the current settings:

[image: screen shot 2015-02-17 at 10 25 57 am]
https://cloud.githubusercontent.com/assets/1423384/6232088/82b4a3c6-b68f-11e4-91ec-85f327b84f0a.png

—
Reply to this email directly or view it on GitHub
#38 (comment).

from scotch-box.

I've selected the private key generated by vagrant, the connection works for me.

EDIT: user / password combination works as well.

from scotch-box.

It could also be a network / firewall issue.

from scotch-box.

I'm getting this error as well. "SSH connection failed, The SSH tunnel has unexpectedly closed."

Settings are correct. I can connect to my other vagrant boxes just fine through Sequel Pro SSH forwarding.

The final two lines in the Show Details message are "RSA host key for 192.168.33.10 has changed and you have requested strict checking.
Host key verification failed."

from scotch-box.

Why was this closed?

from scotch-box.

Reopened. Are you still having problems?

from scotch-box.

I'm going to close this, but use the key for now.

from scotch-box.

I have the same issue. Where can I find the vagrant key?

from scotch-box.

Thank you! This worked for me:

Name: scotchBox
MySQL Host: 127.0.0.1
Username: root
Password: root
SSH Host: 127.0.0.1
SSH User: vagrant
SSH Password: {Select vagrant_private_key file}
SSH Port: 2222

from scotch-box.

I have this problem. I've tried using the vagrant_private_key file and it still gives the same error.

I've triple checked my settings and they are the same as the documentation.

Here is the error message

Used command: /usr/bin/ssh -v -N -o ControlMaster=no -o ExitOnForwardFailure=yes -o ConnectTimeout=10 -o NumberOfPasswordPrompts=3 -i /Users/matt/.vagrant.d/boxes/scotch-VAGRANTSLASH-box/2.0/virtualbox/vagrant_private_key -o TCPKeepAlive=no -o ServerAliveInterval=60 -o ServerAliveCountMax=1 -p 22 [email protected] -L 52259/127.0.0.1/3306

Bad local forwarding specification ' 52259/127.0.0.1/3306'

from scotch-box.

Thanks @Brendonwbrown

from scotch-box.

Agreed with @ablears, I was using an outdated version of SequelPro and after update, it worked like a charm.

Hope this help others.

from scotch-box.

Thanks to @ablears, updated the SequelPro and everything is fine again.

from scotch-box.

Just got Scotch Pro and this is still happening. Within Sequel Pro (latest version etc) all I get is:

SSH connection failed!
The SSH Tunnel has unexpectedly closed.

With either password or vagrant insecure key.

EDIT
So I edited the known_hosts - I had used scotch box before (non pro) so booting another vagrant I have created two SSH keys - had to uncomment the old one (i still want to run both scotch boxes).

from scotch-box.

I'm still having this issue. Clean Vagrant install with ScotchBox Pro 3.0. Tried with password and with SSH key and getting the same errors others have been reporting:

SSH connection failed!
The SSH Tunnel has unexpectedly closed.

Any ideas on how to fix?

from scotch-box.

Type vagrant ssh-config

Then just use the port forwarding settings

from scotch-box.

This is what that command spits out:

HostName 127.0.0.1
User vagrant
Port 2222
UserKnownHostsFile /dev/null
StrictHostKeyChecking no
PasswordAuthentication no
IdentityFile /Users/avclark/sites/.vagrant/machines/default/virtualbox/private_key
IdentitiesOnly yes
LogLevel FATAL

And here are my Sequel Pro settings:

MySQL Host: 127.0.0.1
Username: root
Password: root
SSH Host: 127.0.0.1
SSH User: vagrant
SSH Key: {private key}
SSH Port: 2222

What should I change based on ssh-config?

from scotch-box.

You on Mac or Windows?

from scotch-box.

Mac

from scotch-box.

El Cap

from scotch-box.

Okay can you try SSH into the box first.

No sequel pro

ssh [email protected] -p 2222

from scotch-box.

Password vagrant

from scotch-box.

Didn't even prompt for a password. Here's what I got (same as the errors Sequel Pro gives, btw):

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that a host key has just been changed.
The fingerprint for the ECDSA key sent by the remote host is
SHA256:s6TtuBDr5iBjWO9atbRydfyuY8+dAz45l408mEpfc04.
Please contact your system administrator.
Add correct host key in /Users/avclark/.ssh/known_hosts to get rid of this message.
Offending ECDSA key in /Users/avclark/.ssh/known_hosts:39
ECDSA host key for [127.0.0.1]:2222 has changed and you have requested strict checking.
Host key verification failed.

from scotch-box.

Awesome. Getting there. Not a big deal. Just delete known_hosts

rm ~/.ssh/known_hosts

from scotch-box.

I checked my known_hosts file, but wasn't really sure what I was looking for. It was just a bunch of SSH keys for various servers and apps that I use, like Beanstalk, Github, etc...

from scotch-box.

I think you'd be okay deleting it and just starting over

from scotch-box.

ok, that worked. but did i just lose connection to all my other servers/apps?

from scotch-box.

thanks for the help, btw.

from scotch-box.

No you should be okay. Next time you SSH you'll just have to accept the connection again.

Can you now SSH into Vagrant?

How about Sequel Pro?

from scotch-box.

Yes to both. Cool. Thanks for the help.

from scotch-box.

Yep, no problem!

from scotch-box.

I rather not delete the entire entry since I've established a lot of known hosts in the past. I remember there being some extra lines and formatting issues, which when cleaned up, allowed Vagrant to work.

from scotch-box.

I'm on a Mac and I've tried all these individually and together:

• Removing my ~/.ssh/known_hosts file.
• Adding the private key mentioned in vagrant ssh-config as the SSH Key.
• Adding either 2222 or 22 as the SSH Port.

I still get "The SSH Tunnel has unexpectedly closed."

from scotch-box.

Adding the private key mentioned in vagrant ssh-config as the SSH Key.

Don't do that

Can you try with just user/password auth:

• vagrant
• vagrant

from scotch-box.

@whatnickcodes Sorry, yes I tried that first because it's in the documentation.

from scotch-box.