Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6GTj-000075-1Q for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jul 2021 17:57:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6GTi-0007d0-0d for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jul 2021 17:57:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6GTh-0007cs-Ey for pgsql-admin@lists.postgresql.org; Wed, 21 Jul 2021 17:57:53 +0000 Received: from sonic317-32.consmr.mail.ne1.yahoo.com ([66.163.184.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6GTf-00014p-3c for pgsql-admin@lists.postgresql.org; Wed, 21 Jul 2021 17:57:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1626890269; bh=Ly6muqHr2THjUh8P5cpemUYNOCSKpwi7R3hEp/TrLdM=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=P/fbjAeDSBUPNEZC6pqeLFflYokiPmYDdsvCRy3Jt0bipStf4sImdLUFUfjYnRR6TGMb9pVHvSR+OfFOnYEBRFroIoLdnCfIDU68rAgDK+OFquRqmU/Nb4j/hay60hwqwpSiV9f9XkSWT3h1Z4eTtk4Jk1c/0yEKnjsRBKhoSRpNdzITo9IOY2k3c2oJa9l1u1pjirCKBwTjMk7irjK69u7WzFYU5wmSIug0JivQ7Bw2yrmYzAvtioh9frVo5YPX+GQHvvgMG/uQcDtP7mvofrJ1xB6BLfBOJLBsE/xbVvi6Su2uBP2NjhJW3ZpQs3/oJVB8BJljZjNwvB9ikF1gPQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1626890269; bh=pcWOljKLCaoqPsx7Ukh7XM8i081Re/SeaoOkvhMXd7e=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=GBe+dS/JYWna8pB6u47npTzP5N09GBXu8/md8HoSba4SFn1u1/tNauajbq14OsgY+9ylgnxUoDVfjlHwJxmOoMycr5XjfECu4TnmMXPqWM4ByLHO2tsk6exzI6XH5CTdbv/WNVcQu6rkaMcskrhxOmCY6iu8N+J+wmop5YWWoRDuqynlMXwdpZR4mKZNGNnp8f0+bDwXUOE7bdJlRnnltCjtdb429d8bQSdyiA1ti89e05Ix+uzB9i0uqjvVqkF0GdRY77F95HRjlk46cnUmoKfJOtsMMfyHzF3Pqf3/MuvORtferzlTvhGJ2ez+F8kEudDT1sptaclNAv93bwfDPg== X-YMail-OSG: gbeHK7YVM1lPga1H9k81f9dCVNMooulbvxnGfYRLMxZc_RYM6xdFbKjPvuhnMzc lsCM3t9MSsblQ4KmZKzk8uEfWksYckw_RkMGeDt9Z6l2ujqCc.tqOHuXkQNY2lWxIsUX8cvirNA. 6iirdW.ebFf58uvcojmdbmt3hXAj2.3.fa41huAJ7rCfEeGfCmvcGX1uekBDIsNNOKYd_4fZLekC AWhpvgdN1azPaVurkFVmDm9ybTCsaLcaqp2Cp01uZXUh2VKXgoQT64mVrqU0qTdoFvSHoUtRizcE y223sjHaPAmCCeujpKCui6lVAuIJPLBm5QHesJ2O55nO9DW5BUo1edPQAGG1LiPlFssZLvEkxVF4 jLcYiNAyKpJFQfxM0AhAdjvVsFB3o1adlBC9WRzPcZe0fkC6LPqWAabH.Qifnm77.TPm7DlecyV. HtIZoVGmMa0F0sRcvR.hseJQBV6Ft9NPnjojVqe5hsZwToKjbKvB2_TKv.GcdjXYy6y88fuiTaZT vx2tEOsw5BX_k0tYOlVamkwm_A6MzJyPiZSiPSPt4pnV59e4rTInSNFuWavkHdr1xiB6BLwnbqTS p6MtZ7fSO9J2qCZzLDQnSYoGPdEfpcqFoL6E8GgswLiXr_qP_Sa8SFUHuZMIa8ojlkX8RXnswuoB 9Ztr35LRdtLseB2d4p7Oy5jBfck_VCiS_w11TBjcmZ8GwGSKzjRnj5qKwbQKO6Ipn7InJpxqn_OY x40k4_mNuAXetfyDiinfRujZ10e94xLUnhSsp3khsIple6KmQJQaLyoPFbt1xXx1n_hKfExytxeY BAmoVExY3SvGs72P7JqVyMIxTwqk87MkH59meVQYJCcm3yYChIdjtrgEQ5xoaoww2RDCvDUEVh8o guzbw6B_ITM4HTCc5kUnT9uDY5jU4mBTt7zULwrMno9u0niBvwz2Re3l4FR5Nyp8y3vIs1YxIF8H M39FfFAB08Ssp0gwMkj0J52xsoO.52VUs0RdPZp_7ohgd4DdNTRKmsVhIbxYJcaDjxnbsjVIO43f 7oWAKo.i98YbSKYxbQhEMtY9OgK7mnGkx6buJfY9MLpGNaTNjEDepugomDP88.4Ah2168iropNHI aygCSXO1otJsKwSNQmnEL.p4tU21K3MLHZ1L.DjJtwgf_NuFv_Q7ZyuUzMNX1zDLgrkmBlHziddU j1Vfa2o3O3t4ofXPreq9QpMT0Bs46Ic2XuZTMDDxMNl_ltmvH4KOEBK..30zqlRx2Ze7er6DRedj cfzuxU7L3DgXBDzWHcyUBZAvQZgXTqs024JL0WhcUjIYrPB9R9ifhm_FQCfml7zOaZElm0OjVylg .NoWEZnvSxscV1l8NIWM1pTRaYq5NEhmwOgxlHh4uyzsUNu_Tit2udJz0EBxTLDQIx8qjizhldGI vECSzAztNFjP.XHOEAMufdAPD4ClTDCyLz7w5x3ySypsVBYmqBR5UQBr_RqWT4R_0KuQpe5s001n NGvbfS2zckmVym5smRrtt4MxFUklcr.D144zkg4e_s2SQILg9fsZogeIDKUlgsg0B.g4KHngO.bj T9FwteGxEQWrbv2ayrOzRFHEi.FnP8DbrGjaZSRiSjZZvHtj3X1c7g3LfQdo6ko7OuxWC_KhOG6J ytMYeP1iGuWXHd6AWAom1xcYdxqdWrIUs5SetQvbk4j62mWrq1cU.NkM_QPyV7_88WY02mu5CQCT 8D5nRbTAEZ._zsD2fxPpTQPDglA37Kssc8piKTOVRUmIi_AbvFYNNfytrGJ6vjxnkh6Krb8nPsjn mQZU_VQjcDqBd7JmjQdyOBz8hyi.suI_MdDGDcMlNenktbEefsbrhIb9Z1pysrjPuWOtILd60OZT 4CK4GyRuy3iw.3MSajpq94Ur48h.w9I3ukgIesQJSTA1DV_PoFVLxyKGNOvPxqLxVl6gv6knGM4N nCYu5NBQe7xZ4gCNhI4tCHBJvrATmHbaFseJFA6BSA6luQUOdMRIx13gAjY1Xn0wVnpHjuOqTuYK uhHYdCiuJEZMB4BFaHL0b1UIeO2f9vcyPQ99gY5MizLqTpf6oRVcrbSndU9tRyx.p9kAeq0Pno0N ebXOPTDU3Yp.4jFJJf9uFJqxx3Q52B0DS.6EvWBeWarHstd63Ecv0haUB2PdQAU4rJCqrUb2tBi_ g1RFnoVlfbE1auHBNJUoSzt7cjt4ab3YrnCtllS73OJ.X01359ow0ooLk1SDD0EgJ0ymwu4DQUZ7 NTi3s7x6AK__bmzxSFCYpFcmYmNFeb17KKkaOqgMoPDB6vvE5Cy.vrg_DmQwDG5PJ7p.tNVYT.tX txNYUwz0llNNO4Twlh5eBEyouRxTXz2rfB1p38iSUVG5bhbuK8Mwhn6s9szutEBB4SIfcY9U1bkU alygHN5O9fU2IFPnP0A4hoVo2ladVqnu5C1O276zm19myIL1HC0lKJV3Ahx.pN3sqYh5ooMgxr71 5S1t8bFuRcK.cQ9OgUeucXjJxtTbOxUtjN5QuxtbljN3UmHwOmMNd1r30S80AHZjx6vuvJ_Yeqym LfEK3zLmhE4bCnqiJuTJ59vFmyB7qhWAsFzVDjFerXn2clciCJKuDQbjYJ97HA5gk_O08MpkVJIm nj9y6znxXp4Q.KoQ6YBqnNJfKzIIyM624jwP.JHY9Rxj80FbLp96lcNPPY7O5pqNoQ3bomte6CKl cOr7s X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Wed, 21 Jul 2021 17:57:49 +0000 Date: Wed, 21 Jul 2021 17:57:44 +0000 (UTC) From: Kevin Struckhoff To: "pgsql-admin@lists.postgresql.org" , Ron Message-ID: <940545580.1388617.1626890264641@mail.yahoo.com> In-Reply-To: <012581cb-993e-651d-77a2-afaa30a05a29@gmail.com> References: <1671906036.754266.1626734918424.ref@mail.yahoo.com> <1671906036.754266.1626734918424@mail.yahoo.com> <1121133744.303360.1626822351105@mail.yahoo.com> <012581cb-993e-651d-77a2-afaa30a05a29@gmail.com> Subject: Re: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1388616_1498098993.1626890264638" X-Mailer: WebService/1.1.18469 YMailNorrin Content-Length: 11622 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1388616_1498098993.1626890264638 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable using netstat -tlpn: tcp=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 0 127.0.0.1:5432=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = 0.0.0.0:*=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 LISTEN=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1142/postmaster tcp=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 0 192.168.56.101:5432=C2=A0=C2=A0=C2=A0=C2=A0 0.0.0.0:*=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 LISTE= N=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1142/postmaster tcp6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 = ::1:5432=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 :::*=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 LISTE= N=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1142/postmaster telnettting to 5432 fails. Ports 22 and 9090 are open/listening and telnetting just fine. The problem = must be on the Win 10 side. Thanks. Kevin=20 On Tuesday, July 20, 2021, 5:49:59 PM PDT, Ron wrote: =20 =20 - run netcat to ee if postgres is listening on port 5432. - then telnet to port 5432 to see if it's open. =20 On 7/20/21 6:05 PM, Kevin Struckhoff wrote: =20 =20 I'm running Oracle VBox 6.1. What doesn't make sense is that I can connec= t via putty, WinSCP and even at port 9090 for the CentOS web client (cockpi= t) using the static IP address.=20 I suspect there's a bug in VBox, because my other VM uses just a single n= etwork adaptor set to Bridged mode and it connects just fine. However, it o= nly works at home and not on the road. Hence the need for a static IP. =20 Thanks. Kevin =20 =20 On Tuesday, July 20, 2021, 11:02:31 AM PDT, Jeff Janes wrote: =20 =20 On Mon, Jul 19, 2021 at 6:48 PM Kevin Struckhoff wrote: =20 Hi,=20 Just installed 13.3 on CentOS 8 runnning on a VM on my win 10 laptop. = =20 =20 What is your VM software? =20 =C2=A0=20 I am getting an error while running the odbc connection=C2=A0 test:=20 =20 could not connect to server: connection timed out. =20 =20 Connection timeouts are almost always caused by firewalls or gateways.=C2= =A0 It can't be due to pg_hba, as you are not getting far enough for that t= o kick in yet.=20 Cheers,=20 Jeff =20 =20 =20 --=20 Angular momentum makes the world go 'round. =20 ------=_Part_1388616_1498098993.1626890264638 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
using netstat -tlpn:

tcp   &nbs= p;    0      0 127.0.0.1:5432 =          0.0.0.0:*   = ;            LISTEN&= nbsp;     1142/postmaster
tcp    = ;    0      0 192.168.56.101:5432&n= bsp;    0.0.0.0:*       &= nbsp;       LISTEN    &nb= sp; 1142/postmaster
tcp6       0 = ;     0 ::1:5432      &nb= sp;         :::*   &= nbsp;           &nbs= p;    LISTEN      1142/postmaster
telnettting to 5432 fail= s.

Por= ts 22 and 9090 are open/listening and telnetting just fine. The problem mus= t be on the Win 10 side.

Thanks. Kevin


=20
=20
On Tuesday, July 20, 2021, 5:49:59 PM PDT, Ron <ronl= johnsonjr@gmail.com> wrote:


- run netcat to ee if postgres is listening on port 5432.
- then telnet to port 5432 to see if it's open.

On 7/20/21 6:05 PM, Kevin Struckhoff wrote:
I'm running Oracle VBox 6.1. What doesn't make sense is that I can connect via putty, WinSCP and even at port 9090 for the CentOS web client (cockpit) using the static IP address.

I suspect there's a bug in VBox, because my other VM uses just a single network adaptor set to Bridged mode and it connects just fine. However, it only works at home and not on the road. Hence the need for a static IP.

Thank= s. Kevin


On Tuesday, July 20, 2021, 11:02:31 AM PDT, Jeff Janes <jeff.janes@gmail.com> wrote:


On Mon, Jul 19, 2021 at 6:48 PM Kevin Struckhoff <kevinstruckhoff@yaho= o.com> wrote:
Hi,

Just installed 13.3 on CentOS 8 runnning on a VM on my win 10 laptop.

What is your VM software?

 
I am getting an error while running the odbc connection  tes= t:

could not connect to server: connection timed out.

Connection timeouts are almost always caused by firewalls or gateways.  It can't be due to pg_hb= a, as you are not getting far enough for that to kick in yet.

Cheers,

Jeff


=20
--
Angular momentum makes the world go 'round.
------=_Part_1388616_1498098993.1626890264638--