public inbox for [email protected]help / color / mirror / Atom feed
ssh tunneling 8+ messages / 5 participants [nested] [flat]
* ssh tunneling @ 2024-01-23 00:11 Juan Ignacio Fernigrini <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: Juan Ignacio Fernigrini @ 2024-01-23 00:11 UTC (permalink / raw) To: pgsql-odbc Good morning team, I hope this message finds you well. I am tasked with establishing a connection to my database using ODBC with SSH tunneling. Unfortunately, the current ODBC solution is not compatible. I have explored alternatives such as Devart, but it comes at a cost of $250. I am considering whether it would be more beneficial to invest this amount in developing the required feature within the existing open-source ODBC solution. Best regards, Juan Ignacio Fernigrini ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-23 21:06 Dave Cramer <[email protected]> parent: Juan Ignacio Fernigrini <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: Dave Cramer @ 2024-01-23 21:06 UTC (permalink / raw) To: Juan Ignacio Fernigrini <[email protected]>; +Cc: pgsql-odbc On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini < [email protected]> wrote: > Good morning team, > > I hope this message finds you well. > > I am tasked with establishing a connection to my database using ODBC with > SSH tunneling. Unfortunately, the current ODBC solution is not compatible. > I have explored alternatives such as Devart, but it comes at a cost of > $250. I am considering whether it would be more beneficial to invest this > amount in developing the required feature within the existing open-source > ODBC solution. > > Best regards, > Juan Ignacio Fernigrini > I'm not sure why psql odbc would not be able to use ssh tunneling. Can you expand upon that ? Dave Cramer www.postgres.rocks ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-23 21:25 Dave Cramer <[email protected]> parent: Dave Cramer <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: Dave Cramer @ 2024-01-23 21:25 UTC (permalink / raw) To: Juan Ignacio Fernigrini <[email protected]>; +Cc: pgsql-odbc On Tue, 23 Jan 2024 at 16:06, Dave Cramer <[email protected]> wrote: > > > On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini < > [email protected]> wrote: > >> Good morning team, >> >> I hope this message finds you well. >> >> I am tasked with establishing a connection to my database using ODBC with >> SSH tunneling. Unfortunately, the current ODBC solution is not compatible. >> I have explored alternatives such as Devart, but it comes at a cost of >> $250. I am considering whether it would be more beneficial to invest this >> amount in developing the required feature within the existing open-source >> ODBC solution. >> >> Best regards, >> Juan Ignacio Fernigrini >> > > I'm not sure why psql odbc would not be able to use ssh tunneling. Can you > expand upon that ? > Dave Cramer > www.postgres.rocks > see What is an SSH Tunnel & SSH Tunneling? <https://www.ssh.com/academy/ssh/tunneling#:~:text=SSH%20tunneling%20is%20a%20method%20of%20transport...; For details it is not part of the driver. Dave > > ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-23 21:49 Jon Raiford <[email protected]> parent: Dave Cramer <[email protected]> 0 siblings, 2 replies; 8+ messages in thread From: Jon Raiford @ 2024-01-23 21:49 UTC (permalink / raw) To: Dave Cramer <[email protected]>; Juan Ignacio Fernigrini <[email protected]>; +Cc: pgsql-odbc As Dave mentions, SSH tunneling should work ok. You need to make sure you set up the tunnel correctly. I would suggest testing this using something like netcat to make sure the tunnel is working. If you can connect to netcat with telnet and PostgreSQL is still not connecting then you may want to have a look at your pg_hba.conf configuration to make sure it is set up to accept connections from your SSH server. Jon From: Dave Cramer <[email protected]> Date: Tuesday, January 23, 2024 at 4:35 PM To: Juan Ignacio Fernigrini <[email protected]> Cc: [email protected] <[email protected]> Subject: Re: ssh tunneling On Tue, 23 Jan 2024 at 16:06, Dave Cramer <[email protected]> wrote: On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini <[email protected]<mailto:[email protected]>> wrote: Good morning team, I hope this message finds you well. I am tasked with establishing a connection to my database using ODBC with SSH tunneling. Unfortunately, the current ODBC solution is not compatible. I have explored alternatives such as Devart, but it comes at a cost of $250. I am considering whether it would be more beneficial to invest this amount in developing the required feature within the existing open-source ODBC solution. Best regards, Juan Ignacio Fernigrini I'm not sure why psql odbc would not be able to use ssh tunneling. Can you expand upon that ? Dave Cramer www.postgres.rocks<http://www.postgres.rocks; see What is an SSH Tunnel & SSH Tunneling?<https://www.ssh.com/academy/ssh/tunneling#:~:text=SSH%20tunneling%20is%20a%20method%20of%20transport...; For details it is not part of the driver. Dave ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-24 08:39 Jacobo Sánchez López <[email protected]> parent: Jon Raiford <[email protected]> 1 sibling, 1 reply; 8+ messages in thread From: Jacobo Sánchez López @ 2024-01-24 08:39 UTC (permalink / raw) To: [email protected] Maybe the original message is about SSH proxy instead of tunneling? The PostgreSQL protocol makes a SSH upgrade instead of starting the communication with SSH handshake and that is a problem when using some SSH proxies/load balancers which are nowadays common in cloud environments. I also wish there was a way to connect directly to a SSH socket but that is not about the driver but how PostgreSQL communication protocol I guess. Regards Jacobo On 1/23/2024 10:49 PM, Jon Raiford wrote: > > As Dave mentions, SSH tunneling should work ok. You need to make sure > you set up the tunnel correctly. I would suggest testing this using > something like netcat to make sure the tunnel is working. If you can > connect to netcat with telnet and PostgreSQL is still not connecting > then you may want to have a look at your pg_hba.conf configuration to > make sure it is set up to accept connections from your SSH server. > > Jon > > *From: *Dave Cramer <[email protected]> > *Date: *Tuesday, January 23, 2024 at 4:35 PM > *To: *Juan Ignacio Fernigrini <[email protected]> > *Cc: *[email protected] <[email protected]> > *Subject: *Re: ssh tunneling > > On Tue, 23 Jan 2024 at 16:06, Dave Cramer <[email protected]> > wrote: > > On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini > <[email protected]> wrote: > > Good morning team, > > I hope this message finds you well. > > I am tasked with establishing a connection to my database > using ODBC with SSH tunneling. Unfortunately, the current ODBC > solution is not compatible. I have explored alternatives such > as Devart, but it comes at a cost of $250. I am considering > whether it would be more beneficial to invest this amount in > developing the required feature within the existing > open-source ODBC solution. > > Best regards, > Juan Ignacio Fernigrini > > I'm not sure why psql odbc would not be able to use ssh tunneling. > Can you expand upon that ? > > Dave Cramer > > www.postgres.rocks <http://www.postgres.rocks; > > see What is an SSH Tunnel & SSH Tunneling? > <https://www.ssh.com/academy/ssh/tunneling#:~:text=SSH%20tunneling%20is%20a%20method%20of%20transport...; > > > For details it is not part of the driver. > > Dave > ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-24 16:39 Tom Lane <[email protected]> parent: Jacobo Sánchez López <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: Tom Lane @ 2024-01-24 16:39 UTC (permalink / raw) To: Jacobo Sánchez López <[email protected]>; +Cc: [email protected] =?UTF-8?Q?Jacobo_S=C3=A1nchez_L=C3=B3pez?= <[email protected]> writes: > Maybe the original message is about SSH proxy instead of tunneling? > The PostgreSQL protocol makes a SSH upgrade instead of starting the > communication with SSH handshake and that is a problem when using some > SSH proxies/load balancers which are nowadays common in cloud > environments. I also wish there was a way to connect directly to a SSH > socket but that is not about the driver but how PostgreSQL communication > protocol I guess. FYI, there's some work going on to make it possible to begin the connection with an SSL handshake: https://www.postgresql.org/message-id/flat/CAM-w4HOEAzxyY01ZKOj-iq=M4-VDk=vzQgUsuqiTFjFDZaebdg@mail.... If you'd like to see that move along, review and especially testing of the proposed patch would help make it happen. regards, tom lane ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-24 16:55 Jacobo Sánchez López <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 8+ messages in thread From: Jacobo Sánchez López @ 2024-01-24 16:55 UTC (permalink / raw) To: [email protected] Oh, thanks for letting me know. That sounds great, will take a look at it. Regards On 1/24/2024 5:39 PM, Tom Lane wrote: > FYI, there's some work going on to make it possible to begin the > connection with an SSL handshake: > > https://www.postgresql.org/message-id/flat/CAM-w4HOEAzxyY01ZKOj-iq=M4-VDk=vzQgUsuqiTFjFDZaebdg@mail.... ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: ssh tunneling @ 2024-01-26 18:19 Juan Ignacio Fernigrini <[email protected]> parent: Jon Raiford <[email protected]> 1 sibling, 0 replies; 8+ messages in thread From: Juan Ignacio Fernigrini @ 2024-01-26 18:19 UTC (permalink / raw) To: Jon Raiford <[email protected]>; +Cc: Dave Cramer <[email protected]>; pgsql-odbc Thanks, I'll look into it. El mar, 23 ene 2024 a la(s) 6:49 p.m., Jon Raiford ([email protected]) escribió: > As Dave mentions, SSH tunneling should work ok. You need to make sure you > set up the tunnel correctly. I would suggest testing this using something > like netcat to make sure the tunnel is working. If you can connect to > netcat with telnet and PostgreSQL is still not connecting then you may want > to have a look at your pg_hba.conf configuration to make sure it is set up > to accept connections from your SSH server. > > > > Jon > > > > *From: *Dave Cramer <[email protected]> > *Date: *Tuesday, January 23, 2024 at 4:35 PM > *To: *Juan Ignacio Fernigrini <[email protected]> > *Cc: *[email protected] <[email protected]> > *Subject: *Re: ssh tunneling > > > > > > On Tue, 23 Jan 2024 at 16:06, Dave Cramer <[email protected]> > wrote: > > > > > > On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini < > [email protected]> wrote: > > Good morning team, > > > > I hope this message finds you well. > > > > I am tasked with establishing a connection to my database using ODBC with > SSH tunneling. Unfortunately, the current ODBC solution is not compatible. > I have explored alternatives such as Devart, but it comes at a cost of > $250. I am considering whether it would be more beneficial to invest this > amount in developing the required feature within the existing open-source > ODBC solution. > > > > Best regards, > Juan Ignacio Fernigrini > > > > I'm not sure why psql odbc would not be able to use ssh tunneling. Can you > expand upon that ? > > Dave Cramer > > www.postgres.rocks > > > > see What is an SSH Tunnel & SSH Tunneling? > <https://www.ssh.com/academy/ssh/tunneling#:~:text=SSH%20tunneling%20is%20a%20method%20of%20transport...; > > > > > For details it is not part of the driver. > > > > Dave > > > > -- Atte Juan I Fernigrini ^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2024-01-26 18:19 UTC | newest] Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-01-23 00:11 ssh tunneling Juan Ignacio Fernigrini <[email protected]> 2024-01-23 21:06 ` Dave Cramer <[email protected]> 2024-01-23 21:25 ` Dave Cramer <[email protected]> 2024-01-23 21:49 ` Jon Raiford <[email protected]> 2024-01-24 08:39 ` Jacobo Sánchez López <[email protected]> 2024-01-24 16:39 ` Tom Lane <[email protected]> 2024-01-24 16:55 ` Jacobo Sánchez López <[email protected]> 2024-01-26 18:19 ` Juan Ignacio Fernigrini <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox