Re: [GENERAL] 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.

Meant to add to previous post:

What happens if you try to connect to the database using psql?

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


--
Adrian Klaver
adrian.klaver@aklaver.com