Accessing database using Sequel Pro

Accessing database using Sequel Pro

4 posts / 0 new
Last post
ceokhan's picture
ceokhan
Points: 0
Accessing database using Sequel Pro

Hi, I am trying to access my db using sequel pro following this page and I am getting the following error, keep in mind that I can access the code using git just fine:
OpenSSH_5.9p1, OpenSSL 0.9.8r 8 Feb 2011
debug1: Reading configuration data /etc/ssh_config
debug1: /etc/ssh_config line 20: Applying options for *
debug1: Connecting to srv-1869.devcloud.hosting.acquia.com [67.202.49.86] port 22.
debug1: fd 3 clearing O_NONBLOCK
debug1: Connection established.
debug1: identity file /Users/intelkhan/.ssh/id_rsa type -1
debug1: identity file /Users/intelkhan/.ssh/id_rsa-cert type -1
debug1: identity file /Users/intelkhan/.ssh/id_dsa type -1
debug1: identity file /Users/intelkhan/.ssh/id_dsa-cert type -1
debug1: Remote protocol version 2.0, remote software version OpenSSH_5.3p1 Debian-3ubuntu7
debug1: match: OpenSSH_5.3p1 Debian-3ubuntu7 pat OpenSSH*
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_5.9
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received
debug1: kex: server->client aes128-ctr hmac-md5 none
debug1: kex: client->server aes128-ctr hmac-md5 none
debug1: SSH2_MSG_KEX_DH_GEX_REQUEST(1024<1024<8192) sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_GROUP
debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY
debug1: Server host key: RSA 78:94:5f:a6:9e:37:b9:0e:ea:bf:0e:ce:48:73:99:39
debug1: Host 'srv-1869.devcloud.hosting.acquia.com' is known and matches the RSA host key.
debug1: Found key in /Users/intelkhan/.ssh/known_hosts:3
debug1: ssh_rsa_verify: signature correct
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: Roaming not allowed by server
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: publickey
debug1: Next authentication method: publickey
debug1: Offering RSA public key: /Users/intelkhan/.ssh/github_rsa
debug1: Authentications that can continue: publickey
debug1: Trying private key: /Users/intelkhan/.ssh/id_rsa
debug1: Trying private key: /Users/intelkhan/.ssh/id_dsa
debug1: No more authentication methods to try.
Permission denied (publickey).

Status: 
Resolved (feature request)
nathaniel.hoag's picture
Nathaniel Hoag
Points: 6

Hi ceokhan,

This is likely related to misconfigured credentials or connection details. I can confirm the instructions at the page you referenced are valid.

You will want to review the credentials at 'Cloud' > 'Databases'. Note that the actual database name is listed under 'MySQL Name'.

Also, make sure you're using the 'SSH' tab in the Sequel Pro connection window.

In this case, the fields should resemble the following:
MySQL Host: srv-XXX.devcloud.hosting.acquia.com
Username: database user name
Password: database password
Database: 'MySQL Name'

SSH Host: srv-XXX.devcloud.hosting.acquia.com
SSH User: listed under 'Cloud' > 'Users and Keys' ('user'@)
SSH Password: Will use your SSH key from .ssh/config
SSH Port: 22

david@philanthropyworks.org's picture
david
Points: 0

Thanks Ceokhan!

One minor point re "SSH User": This is the (potentially long) username given as part of the example SSH command, not the more prominently-displayed nickname.
Obvious on reflecting, but potentially confusing with local SSH usernames, etc.

yuan.xie's picture
yuan.xie
Points: 30

Please see the screenshot for a proper connection setup to Acquia Cloud including free tier.

Make sure your ssh keys are set correctly.

One catch here is that you will need to use "localhost" as the MySql Host. Sequel Pro tries to be smart and make you use 127.0.0.1 instead of "localhost", which then unfortunately will not work with Acquia Cloud. The workaround here is to add a space after "localhost" (again, see screenshot).

Status Change: 
Resolved