SSH Connection Using Pgadmin4 on Ubuntu 16.04
source link: https://snakeycode.wordpress.com/2019/06/06/ssh-connection-using-pgadmin4-on-ubuntu-16-04/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SSH Connection Using Pgadmin4 on Ubuntu 16.04
Pgadmin4 has a GUI for connecting to a remote DB. Seems pretty straight forward. And then you get this error:
module ‘paramiko’ has no attribute ‘Ed25519Key’
After some googling you find this Stack Overflow post. Looks like you need to install paramiko 2.4. If you follow the instructions in SO, you end up with a failed install due to missing dependencies. Turns out there is no pre-built distribution of paramiko 2.4 for Ubuntu 16.04.
If you move on the the SO answer that suggests editing /usr/lib/python3/dist-packages/sshtunnel.py. I tried that. It was easy. Only two lines needed to be removed. However after that, I kept getting errors like ‘Could not establish session to SSH gateway’ and ‘Could not connect to gateway’.
Eventually I solved the problem by creating an ssh tunnel from the Ubuntu command line and then connecting to the tunnel in pgadmin.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK