Error connecting to DB via ssh with Python on Windows

Question

I have a snippet of code that allows me to connect to my psql DB via ssh in Python. It works perfectly on Ubuntu 18.10 (via VirtualBox) but fails every time on windows with an error that it can't reach the remote host and port.

I'm been developing a user interface that can query data from a remote DB (logs etc.) and visualize it.

All of the development has been done using Spyder3 on Ubuntu 18.10. I never had an issue until I tried to execute the same code on Windows 10.

I tried Telnet to both the localhost:port and remote host:port (via ssh) and it works. Having looked up all the possible answers on stackoverflow and other places, I still haven't been able to fix the issue. The fact that it works on one environment and not on the other, while on the same machine, tells me it's some sort of environment setting but I don't know what it could be.

The code:

import psycopg2
import logging
logging.basicConfig(level=logging.DEBUG)

from sshtunnel import SSHTunnelForwarder

PORT = 5432
REMOTE_HOST = '111.222.111.222'
REMOTE_SSH_PORT = 22
curs = None
conn = None


server = SSHTunnelForwarder((REMOTE_HOST, REMOTE_SSH_PORT),
     ssh_username='username',
     ssh_password='password',
     remote_bind_address=('localhost', PORT),
     local_bind_address=('localhost', PORT))

server.start()
conn = psycopg2.connect(database='db_name', user='db_username', password='db_password', host='127.0.0.1', port='5432')
curs = conn.cursor()

Expected: A successful connection to ssh and subsequent successful log-in to the database. This works on Ubuntu 18.10 via VirtualBox on the same machine.

Actual result: 2019-01-02 10:54:51,489 ERROR Problem setting SSH Forwarder up: Couldn't open tunnel localhost:5432 <> localhost:5432 might be in use or destination not reachable

Alexandros · Accepted Answer · 2019-01-08 05:58:24Z

1

I realized that my local postgres (psql) service was interfering with the port mapping as it was also using port 5432. Once I disabled the service, it worked like a charm.

answered Jan 8, 2019 at 5:58

Alexandros

5532 gold badges7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ybl · Accepted Answer · 2019-01-02 10:53:10Z

0

I may be wrong, but I think the remote_bind_address should be set to your server's private IP. As this is where the remote machine would communicate to your machine.

 remote_bind_address=(<PRIVATE_SERVER_IP>, PORT)

answered Jan 2, 2019 at 10:53

ybl

1,63512 silver badges17 bronze badges

1 Comment

Alexandros Over a year ago

Thanks for the quick answer. I just tried it but it unfortunately doesn't work on Windows. On Ubuntu, it works in the same way as having 'localhost' there.

Collectives™ on Stack Overflow

Error connecting to DB via ssh with Python on Windows

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related