From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | ourdiaspora <ourdiaspora(at)protonmail(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: php connection failure |
Date: | 2021-08-08 01:15:39 |
Message-ID: | 2860895.1628385339@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
ourdiaspora <ourdiaspora(at)protonmail(dot)com> writes:
> psql -d cpacweb -U cpaca
> psql: FATAL: Peer authentication failed for user "cpaca"
The reason that's able to make a connection to the PG server
is that it's not going through TCP at all, but a Unix socket.
I'd guess at this point that your configuration never worked
for TCP connections --- either localhost or not --- because
your kernel packet filter isn't permitting it. It's a gold
plated certainty that the default packet filter configuration
wouldn't allow traffic to port 5432 from off-machine. Whether
it would allow such traffic from localhost is less certain,
but the symptoms you're showing sure look like yours doesn't.
Saying you haven't touched that configuration doesn't excuse
you from investigating it.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bikal Gurung | 2021-08-08 13:33:03 | Re: Test mail for pgsql-general |
Previous Message | Adrian Klaver | 2021-08-08 00:51:45 | Re: php connection failure |