| From: | Keith Yanase <keith(dot)yanase(at)soterawireless(dot)com> |
|---|---|
| To: | Clemens Ladisch <clemens(at)ladisch(dot)de> |
| Cc: | "Bhavika Padidala (MINDTREE LIMITED)" <v-bhpadi(at)microsoft(dot)com>, "Prashanth Reddy Kalvakuntla (MINDTREE LIMITED)" <v-prkalv(at)microsoft(dot)com>, "Vikram Ramagiri (MINDTREE LIMITED)" <v-virama(at)microsoft(dot)com>, pgsql-odbc(at)postgresql(dot)org, support <support(at)mail(dot)support(dot)microsoft(dot)com> |
| Subject: | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |
| Date: | 2020-01-19 20:10:02 |
| Message-ID: | CADxFd5kvki-xUajEsXr9mDxaBpQ=bG2U_hqfr2vXwFnCB6SE_g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
I ran the command and when I tel psqlODBC to connect to localhost:5432 I
get this message in the terminal:
Channel 3: open failed: connect failed: connection refused
Are my connection settings in psqlODBC correct?
Data Source: PostgreSQL30
Database: database
Server: localhost
Port: 5432
I didn’t enter credentials (un/pw) since I’m connecting to localhost - is
that a correct assumption?
On Sun, Jan 19, 2020 at 10:58 AM Clemens Ladisch <clemens(at)ladisch(dot)de> wrote:
> Keith Yanase wrote:
> > The server only allows SSH tunneling. I’m able to establish the SSH
> tunnel with the command: ssh jupyter
> > but how do I tell psqlODBC to connect to that port?
>
> Run "ssh -L bindaddress:localport:remoteserver:remoteport sshserver", where
> "remoteserver" is the host name you want to connect to, from the point of
> view of the SSH server.
>
> So run "ssh -L localhost:5432:localhost:5432 jupyter", and tell psqlODBC to
> connect to localhost:5432.
>
>
> Regards,
> Clemens
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clemens Ladisch | 2020-01-19 20:40:43 | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |
| Previous Message | Clemens Ladisch | 2020-01-19 18:58:06 | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |