Related

Product Managed MySQL, Redis, Postgres on DigitalOcean Product
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

Question

Cannot access the host to connect a database via SSH tunneling while getting "Permission denied (publickey)."

Posted April 12, 2020 585 views
Databases

After running docker and creating an own PostgreSql database in a droplet, I can access the host via “ssh root@xx.xx.xx.xx” but I cant connect to the database via SSH tunneling. Here is the command and its response:

root@ubuntu-database:~# ssh -L 5432:localhost:5432 -N -f -l root XX.XX.XX.XX Permission denied (publickey).

I'be assigned the droplet with SSH security rather than using one-time email. Currently, I really have no idea of what is the cause of the problem -whether it’s from the droplet configuration, docker, PostgreSql setting, or SSH usage. I’m an amateur and quite new for this matter. Please kindly help.

Thank you very much.

Add a comment
valorvignette
By:
valorvignette

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
KFSys April 12, 2020

Hi @valorvignette,

Using SSH Tunneling won’t get your SSH key automatically like using plain SSH. You’ll need to pass it down the command you use.

ssh -N -L 5432:127.0.0.1:5432-i /path/to/ssh/key root@XXX.XXX.XXX.XXX

Please don’t forget to chage both the path and the XXX. with your actual IP address.

Regads,
KDSys

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help