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 1m60Qn-0002Fw-MM for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jul 2021 00:49:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m60Qm-0006Ze-MA for pgsql-admin@arkaria.postgresql.org; Wed, 21 Jul 2021 00:49:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m60Qm-0006ZH-CD for pgsql-admin@lists.postgresql.org; Wed, 21 Jul 2021 00:49:48 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m60Qk-0002NP-87 for pgsql-admin@lists.postgresql.org; Wed, 21 Jul 2021 00:49:48 +0000 Received: by mail-ot1-x336.google.com with SMTP id j1-20020a0568302701b02904d1f8b9db81so558899otu.12 for ; Tue, 20 Jul 2021 17:49:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=ymBx6MOw65X4DgMxVttnDMOmufR4EP+xxOk5gA8e44s=; b=YFqG5sGTvxyxtTI4V9grJHK8RG+0u/m2Bn/4ryp7GxsweflfwPqZCKWQHPzeQe4qdv m8DRM878yacGJSUogf8LHmIqX3bo0VXn5DWYfqb2nalCFIMNfd3H1EaMK2r2xRtKgrYV WKLJ2uGGu4GtUxl4VUywpV3y+cCdg7J0zQilgV2vq3aYc3z4YkiTED0V8uZKIkmdCVUy bDVBxtO+XbgonbGbC/C1Q5QYzbL/V4S9Yl1hoIXry9BQVW8JQxkHJVN5yGnKS3fLL4tF LeDrQYx+MU1ECvHfink88rFOF49h+q6tAyTjafi24dTl+4LH9AGAvn2SgXNGrV91WTP6 di3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=ymBx6MOw65X4DgMxVttnDMOmufR4EP+xxOk5gA8e44s=; b=jHn44xRn+OD1VsT6+y1E4BDA3a9wnGUH1hlwIYeR2E+BYhGlMAaez7HRoPv6IwysOm yHl/HA2IUF/0MtZcwD3QYUcGRzq6kNMx9dOLY0rrHTfBgGTnAFW2MsU3kAheZSDAX0EW wjx+p4+JEuHAMVYpmghvXuNX/DQfFj3SyYflMOWpoW9+y3jVuvJD7GWYxaX/CB2D6ubX rfi2psKrr3ZwgYyGOtPwEUy0GUjLttWxWLMFvSLt8dUbv3FDa4BKrgDlb1hvoz7Z9dtm YVRf2h6YEu+iXf16ln5rPP0RGT8iaffsge7rgyXXSYAYdluhZlhQnuj/sgvPc2CBWW81 qU7w== X-Gm-Message-State: AOAM533QBMncB8Z+yELXTMJSJop5kYjuF1/+eeJWzkdyEZldYJO9v2B/ Q8n2s6ZW9LKt9Tq/m8t0M+ZRCDsNTnI= X-Google-Smtp-Source: ABdhPJxyLk17ENLLVktEPZa5R/1YAZQbVnZI/MBHV/iZL2MnoKWkO+dxsLgHftkjOO9f0mj5L+c96g== X-Received: by 2002:a9d:6a50:: with SMTP id h16mr10730185otn.369.1626828583983; Tue, 20 Jul 2021 17:49:43 -0700 (PDT) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id n14sm4463364ota.57.2021.07.20.17.49.42 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 20 Jul 2021 17:49:43 -0700 (PDT) Subject: Re: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4 To: pgsql-admin@lists.postgresql.org References: <1671906036.754266.1626734918424.ref@mail.yahoo.com> <1671906036.754266.1626734918424@mail.yahoo.com> <1121133744.303360.1626822351105@mail.yahoo.com> From: Ron Message-ID: <012581cb-993e-651d-77a2-afaa30a05a29@gmail.com> Date: Tue, 20 Jul 2021 19:49:42 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <1121133744.303360.1626822351105@mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------6CE45D51CC556FCC2F538970" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------6CE45D51CC556FCC2F538970 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit - 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. > > Thanks. Kevin > > > On Tuesday, July 20, 2021, 11:02:31 AM PDT, Jeff Janes > wrote: > > > On Mon, Jul 19, 2021 at 6:48 PM Kevin Struckhoff > > 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  test: > > 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_hba, as you are not getting far enough for that to kick > in yet. > > Cheers, > > Jeff > > -- Angular momentum makes the world go 'round. --------------6CE45D51CC556FCC2F538970 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit - 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.

Thanks. 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@yahoo.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  test:

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_hba, as you are not getting far enough for that to kick in yet.

Cheers,

Jeff



--
Angular momentum makes the world go 'round.
--------------6CE45D51CC556FCC2F538970--