From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unable to connect to Postgresql |
Date: | 2017-04-07 22:58:15 |
Message-ID: | ea3c41cf-17b2-d4e6-4591-a47457f7113c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-04-07 23:51:57 | Re: Unable to connect to Postgresql |
Previous Message | Adrian Klaver | 2017-04-07 22:51:33 | Re: Unable to connect to Postgresql |