Question

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

Posted April 12, 2020 415 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.

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

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

Submit an Answer