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,