Re: Unable to connect to Postgresql

On 04/07/2017 02:38 PM, John Iliffe wrote:
> When I attempt to run any web application php cannot open a database
> because of failure to connect. (Please disregard the programme name, it is
> running in mod_php, not as an fcgi module). The (php) message is:
>
> --------------------------
> [Fri Apr 07 17:03:28.597101 2017] [php7:warn] [pid 1797:tid
> 140599445419776] [client 192.168.1.10:45127] PHP Warning: pg_connect():
> Unable to connect to PostgreSQL server: could not connect to server: No
> such file or directory\n\tIs the server running locally and
> accepting\n\tconnections on Unix domain socket
> "/tmp/.s.PGSQL.5432"? in /httpd/iliffe/testfcgi.php on line 121
> ----------------------------
>
> The proper socket does exist:
>
> -------------------------------------
> ls -al /tmp | grep PGSQL
> srwxrwxrwx. 1 postgres postgres 0 Apr 7 16:53 .s.PGSQL.5432
> -rw-------. 1 postgres postgres 49 Apr 7 16:53 .s.PGSQL.5432.lock
>
> ss -a | grep 5432
> u_str LISTEN 0 128 /tmp/.s.PGSQL.5432 30480 * 0
> -------------------------------------
>
> Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit log shows
> no hits on Postgresql.
>
> Postgresql version number is 9.6.2
>
> As expected, the postgresql log shows nothing since the last start up.

Well the last time this happened the answer was this:

https://www.postgresql.org/message-id/25543.1489081789%40sss.pgh.pa.us

>
> Thanks in advance.
>
> John
> =====================================
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com