I'm using SSH tunneling to get into a Vertica database running on a Debian machine remotely, but it only works probably 10% of the time that I attempt to connect. Usually I get the following error:
SQL Error [100176] [HY000]: [Vertica][VJDBC](100176) Failed to connect to host localhost on port 5433. Reason: Connection refused: connect
[Vertica][VJDBC](100176) Failed to connect to host localhost on port 5433. Reason: Connection refused: connect
[Vertica][VJDBC](100176) Failed to connect to host localhost on port 5433. Reason: Connection refused: connect
Connection refused: connect
I can SSH into the machine using putty without any issue. Is there anything I can do to solve this problem?