Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rU3k3-008bcu-FX for pgsql-odbc@arkaria.postgresql.org; Sun, 28 Jan 2024 11:54:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rU3j1-008V8d-Ol for pgsql-odbc@arkaria.postgresql.org; Sun, 28 Jan 2024 11:53:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rTQmh-000xYK-AY for pgsql-odbc@lists.postgresql.org; Fri, 26 Jan 2024 18:18:35 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rTQmd-003Vpq-O6 for pgsql-odbc@postgresql.org; Fri, 26 Jan 2024 18:18:34 +0000 Received: by mail-wr1-x432.google.com with SMTP id ffacd0b85a97d-3394dc2ae23so1000524f8f.2 for ; Fri, 26 Jan 2024 10:18:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706293109; x=1706897909; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=10eIMLkHQNKlXzYos+PfH2pw8TlABjdENim+J/yxNJk=; b=L3x4+yffgqgl8ZuDZO6H9NopwdQHIvSaO86WMD4Ex9tjjeJQFYjL7or8DuVVZPhZEe 57EMRhyUEidXdT8iiXWAX/lD/PTrKHqharIip3sFFfdYYB/FZKJvbEFYhH2TjvRg5NBi Cv+WlPMTvxoNeIx74eHgJzPzc8qrLsdtQaRLNgPjASk28XaQyyp/7iY4bgeW+mrDNEvR O2r5E21iSOAGp+WJWafD1qVCx3APF2TB2erjv7Ob0kffuwdfXQDCvC//EExxo2aHgJQs o42HNdbkPtQfpkOLtCyHhC5RNWmIt5p1NNnGLAo0koE4xnDiEOHOK6/Vc8GEMo9zgPzr Xfdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706293109; x=1706897909; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=10eIMLkHQNKlXzYos+PfH2pw8TlABjdENim+J/yxNJk=; b=dH488OtYSEvTeDCSySUV7kuXPkIgajCdXa+3whoAvR+WTf6lXOwttF5q72SG3EGaKp 4FmJUEhoiQk4ZnOu66I1lga0u87BQFS5jnVO/oqi0+aCW9UwMHTdClYIPblJRnB5ME45 X2De/FjrplavkquRMFU3BRsfeZrogtF3uPVtpEGeF9sftMFjgjGaF5te23TkG+HLFHRr x4qwbifjamU/7P4u6GtjpYl0Iik7PPkEtTCWuRgaOmN2YQ5IzaGHImpELTjOsd8CMO/p UUJdw079Cvfl+cZb7dkk4/HsBg1YIOou+nkTxCH8jToMHz8onQmr+FfIY8zpBdaIFKfK OBTQ== X-Gm-Message-State: AOJu0YyDeQE23vNwjNv62hUvjJp67D+xsD3lP4fCwdQn29n4i8k4/okf 63gNT8ZTYbXyuCQJBotxVjIl8BoaKuYl14Y0Uu14aaNMaKE1cT8D0FgjZT37mnOqcP6XZM28ynE xnooVLHtFCtBJOheLQ+nVnMrgQfZcoUwS X-Google-Smtp-Source: AGHT+IF1CbDTOkLW5p/5YK6KV2CwxIre1d+Oeo7++kDnsx5EYyMqjF1WdZzexUDzvoIbBbAjybbl+mMUSUImbGf+KBs= X-Received: by 2002:a5d:650f:0:b0:339:3f40:ffc3 with SMTP id x15-20020a5d650f000000b003393f40ffc3mr15998wru.207.1706293109054; Fri, 26 Jan 2024 10:18:29 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Juan Ignacio Fernigrini Date: Fri, 26 Jan 2024 15:19:50 -0300 Message-ID: Subject: Re: ssh tunneling To: Jon Raiford Cc: Dave Cramer , "pgsql-odbc@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000a5e387060fdd52c3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a5e387060fdd52c3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks, I'll look into it. El mar, 23 ene 2024 a la(s) 6:49=E2=80=AFp.m., Jon Raiford (raiford@labware= .com) escribi=C3=B3: > 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 wa= nt > to have a look at your pg_hba.conf configuration to make sure it is set u= p > to accept connections from your SSH server. > > > > Jon > > > > *From: *Dave Cramer > *Date: *Tuesday, January 23, 2024 at 4:35=E2=80=AFPM > *To: *Juan Ignacio Fernigrini > *Cc: *pgsql-odbc@postgresql.org > *Subject: *Re: ssh tunneling > > > > > > On Tue, 23 Jan 2024 at 16:06, Dave Cramer > wrote: > > > > > > On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini < > juanfernigrini@gmail.com> 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 yo= u > expand upon that ? > > Dave Cramer > > www.postgres.rocks > > > > see What is an SSH Tunnel & SSH Tunneling? > > > > > > For details it is not part of the driver. > > > > Dave > > > > --=20 Atte Juan I Fernigrini --000000000000a5e387060fdd52c3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, I'll look into it.=C2=A0

El mar, 23 ene 202= 4 a la(s) 6:49=E2=80=AFp.m., Jon Raiford (raiford@labware.com) escribi=C3=B3:

As Dave mentions, SSH= tunneling should work ok. You need to make sure you set up the tunnel corr= ectly. I would suggest testing this using something like netcat to make sur= e 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.

=C2=A0<= /span>

Jon

=C2=A0<= /span>

From: Dave Cramer <davecramer@postgres.= rocks>
Date: Tuesday, January 23, 2024 at 4:35=E2=80=AFPM
To: Juan Ignacio Fernigrini <juanfernigrini@gmail.com>
Cc: p= gsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
Subject: Re: ssh tunneling

=C2=A0

=C2=A0

On Tue, 23 Jan 2024 at 16:06, Dave Cramer <davecr= amer@postgres.rocks> wrote:

=C2=A0

=C2=A0

On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrin= i <juanfer= nigrini@gmail.com> wrote:

Good morning team,

=C2=A0

I hope this message finds you well.

=C2=A0

I am tasked with establishing a connection to my dat= abase using ODBC with SSH tunneling. Unfortunately, the current ODBC soluti= on is not compatible. I have explored alternatives such as Devart, but it c= omes at a cost of $250. I am considering whether it would be more beneficial to invest this amount in developing th= e required feature within the existing open-source ODBC solution.=

=C2=A0

Best regards,
Juan Ignacio Fernigrini

=C2=A0

I'm not sure why psql odbc would not be able to = use ssh tunneling. Can you expand upon that ?

Dave Cramer

=C2=A0

=C2=A0

For details it is not part of the driver.<= /u>

=C2=A0

Dave=C2=A0

=C2=A0



--
Atte Juan I Fernigrini


=


--000000000000a5e387060fdd52c3--