mysql - AWS SSH and RDS permission denied - public key -


i'm trying ssh , connect rds instance. neither working, giving same error:

permission denied (publickey).

i've set credentials in ~/.ssh/config:

host clg-api-staging      hostname ec2-11-111-11-11.compute-1.amazonaws.com         user ec2-user      identityfile ~/.ssh/clg-api-staging.pem

i've tried:

  • changing permissions on pem file: chmod 600 ~/.ssh/clg-api-staging.pem

  • changing permissions on ~/.ssh/ 700

  • set inbound rules tcp on port 22 , mysql on port 3306:

enter image description here

this message when try log in thru profile: 

$ ssh -v clg-api-staging  openssh_7.4p1, libressl 2.5.0 debug1: reading configuration data /users/danniu/.ssh/config debug1: /users/danniu/.ssh/config line 26: applying options clg-api-staging debug1: reading configuration data /etc/ssh/ssh_config debug1: connecting ec2-34-196-57-20.compute-1.amazonaws.com [34.196.57.20] port 22. debug1: connection established. debug1: key_load_public: no such file or directory debug1: identity file /users/danniu/.ssh/clg-api-staging.pem type -1 debug1: key_load_public: no such file or directory debug1: identity file /users/danniu/.ssh/clg-api-staging.pem-cert type -1 debug1: enabling compatibility mode protocol 2.0 debug1: local version string ssh-2.0-openssh_7.4 debug1: remote protocol version 2.0, remote software version openssh_6.6.1 debug1: match: openssh_6.6.1 pat openssh_6.6.1* compat 0x04000000 debug1: authenticating ec2-34-196-57-20.compute-1.amazonaws.com:22 'ec2-user' debug1: ssh2_msg_kexinit sent debug1: ssh2_msg_kexinit received debug1: kex: algorithm: curve25519-sha256@libssh.org debug1: kex: host key algorithm: ecdsa-sha2-nistp256 debug1: kex: server->client cipher: chacha20-poly1305@openssh.com mac: <implicit> compression: none debug1: kex: client->server cipher: chacha20-poly1305@openssh.com mac: <implicit> compression: none debug1: expecting ssh2_msg_kex_ecdh_reply debug1: server host key: ecdsa-sha2-nistp256 sha256:pathd/i/bustt1k3qkzjb4knjyiqjuofnpmpsot/5lg debug1: host 'ec2-34-196-57-20.compute-1.amazonaws.com' known , matches ecdsa host key. debug1: found key in /users/danniu/.ssh/known_hosts:24 debug1: rekey after 134217728 blocks debug1: ssh2_msg_newkeys sent debug1: expecting ssh2_msg_newkeys debug1: ssh2_msg_newkeys received debug1: rekey after 134217728 blocks debug1: skipping ssh-dss key /users/danniu/.ssh/id_dsa - not in pubkeyacceptedkeytypes debug1: ssh2_msg_service_accept received debug1: authentications can continue: publickey debug1: next authentication method: publickey debug1: offering rsa public key: /users/danniu/.ssh/github_rsa debug1: authentications can continue: publickey debug1: trying private key: /users/danniu/.ssh/clg-api-staging.pem debug1: authentications can continue: publickey debug1: no more authentication methods try. permission denied (publickey).

this message when attempting connect rds db via sequel pro: 

used command:  /usr/bin/ssh -v -n -s none -o controlmaster=no -o exitonforwardfailure=yes -o connecttimeout=10 -o numberofpasswordprompts=3 -i /users/danniu/.ssh/clg-api-staging.pem -o tcpkeepalive=no -o serveraliveinterval=60 -o serveralivecountmax=1 ec2-user@ec2-34-196-57-20.compute-1.amazonaws.com -l 55318:aa1tgl9qfl015rk.cuqlyug9ccbu.us-east-1.rds.amazonaws.com:3306  openssh_7.4p1, libressl 2.5.0 debug1: reading configuration data /users/danniu/.ssh/config debug1: reading configuration data /etc/ssh/ssh_config debug1: control socket " none" not exist debug1: connecting ec2-34-196-57-20.compute-1.amazonaws.com [34.196.57.20] port 22. debug1: fd 8 clearing o_nonblock debug1: connection established. debug1: key_load_public: no such file or directory debug1: identity file /users/danniu/.ssh/clg-api-staging.pem type -1 debug1: key_load_public: no such file or directory debug1: identity file /users/danniu/.ssh/clg-api-staging.pem-cert type -1 debug1: enabling compatibility mode protocol 2.0 debug1: local version string ssh-2.0-openssh_7.4 debug1: remote protocol version 2.0, remote software version openssh_6.6.1 debug1: match: openssh_6.6.1 pat openssh_6.6.1* compat 0x04000000 debug1: authenticating ec2-34-196-57-20.compute-1.amazonaws.com:22 'ec2-user' debug1: ssh2_msg_kexinit sent debug1: ssh2_msg_kexinit received debug1: kex: algorithm: curve25519-sha256@libssh.org debug1: kex: host key algorithm: ecdsa-sha2-nistp256 debug1: kex: server->client cipher: chacha20-poly1305@openssh.com mac: <implicit> compression: none debug1: kex: client->server cipher: chacha20-poly1305@openssh.com mac: <implicit> compression: none debug1: expecting ssh2_msg_kex_ecdh_reply debug1: server host key: ecdsa-sha2-nistp256 sha256:pathd/i/bustt1k3qkzjb4knjyiqjuofnpmpsot/5lg debug1: read_passphrase: can't open /dev/tty: device not configured debug1: permanently_drop_suid: 501 warning: permanently added 'ec2-34-196-57-20.compute-1.amazonaws.com,34.196.57.20' (ecdsa) list of known hosts. debug1: rekey after 134217728 blocks debug1: ssh2_msg_newkeys sent debug1: expecting ssh2_msg_newkeys debug1: ssh2_msg_newkeys received debug1: rekey after 134217728 blocks debug1: skipping ssh-dss key /users/danniu/.ssh/id_dsa - not in pubkeyacceptedkeytypes debug1: ssh2_msg_service_accept received debug1: authentications can continue: publickey debug1: next authentication method: publickey debug1: offering rsa public key: /users/danniu/.ssh/github_rsa debug1: authentications can continue: publickey debug1: trying private key: /users/danniu/.ssh/clg-api-staging.pem debug1: authentications can continue: publickey debug1: no more authentication methods try. permission denied (publickey).

if attempting connect rds using ssh, never going work. rds database service allows sql connections , not direct ssh or other administrator type access.


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more