Fixing the SSH tunnel with Sequel Pro on MacOS Sierra

Sequel Pro is one of the most popular database tools for the Mac. With the release of MacOS Sierra, I had a few issues connecting to my saved databases that used the SSH tunnel method of connecting. The error I kept getting was:

debug1: Offering RSA public key: /Users/username/.ssh/id_rsa.pub
debug1: Server accepts key: pkalg ssh-rsa blen 535
debug1: read_passphrase: can't open /dev/tty: Device not configured
debug1: permanently_drop_suid: 501

The fix involved two steps. The first is to be sure your id_rsa file has the proper permissions.

chmod 600 id_rsa

Then, in your Sequel Pro connection change the key file from id_rsa.pub to the none pub version, id_rsa.

Published by Eric L. Barnes

I'm Eric Barnes, software developer, maker, and blogger/writer. I also run Laravel News. Follow on Twitter @ericlbarnes View all posts by Eric L. Barnes

5 thoughts on “ Fixing the SSH tunnel with Sequel Pro on MacOS Sierra ”

Giby says:

March 1, 2017 at 6:17 am

You sir, deserve a cooky! Was getting mad at this, thank you SO much! 😀 Hugs from Luxembourg

LikeLike

Reply
eduardocruz (@eduardocruz) says:

March 17, 2017 at 5:11 pm

WOW … saved my day 😀

LikeLike

Reply
Annie says:

September 19, 2019 at 3:51 pm

This isn’t resolving my error. Still getting the “debug1: read_passphrase: can’t open /dev/tty: Device not configured” Any suggestions?

LikeLike

Reply
Shawn Crigger says:

November 14, 2019 at 1:15 pm

How did you get the debug output or is that in a logfile somewhere?

LikeLike

Reply
1. Eric L. Barnes says:
  
  November 14, 2019 at 1:37 pm
  
  Good question. I think at the time the error was in a popup window from sequel pro itself. Since this post was written I’ve now been using Table Plus so I’m not familiar with the setup.
  
  LikeLike
  
  Reply