Re: php connection failure

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: ourdiaspora <ourdiaspora(at)protonmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: php connection failure
Date: 2021-08-07 23:53:13
Message-ID: CAKFQuwamKeRDUQRMCn3Ht1VFotd4a2cGArb_1=BBPbVTXC0org@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, August 7, 2021, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> ourdiaspora <ourdiaspora(at)protonmail(dot)com> writes:
> > psql -d cpacweb -h 127.0.0.1 -U cpaca
> > psql: could not connect to server: Connection refused
> > Is the server running on host "127.0.0.1" and accepting
> > TCP/IP connections on port 5432?
>
> Hm --- this suggests that you've got a kernel packet filter (i.e.
> software firewall) that is not passing traffic for 5432.

Agreed.

>
> It's not very clear how it worked before if that were in place
> previously, but since you've said zero about what the working
> configuration looked like, that's the best I've got.
>
>
I don’t see where it ever did. Only local connections ever were shown to
have worked and nothing has been said the non-local connections stopped
working, just that none of the changes to config files got them to work
(which makes sense as it doesn’t seem our configuration is at fault, at
least not exclusively).

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ourdiaspora 2021-08-07 23:54:04 Re: php connection failure
Previous Message David G. Johnston 2021-08-07 23:50:18 Re: php connection failure