Re: [GENERAL] Unable to connect to Postgresql - Mailing list pgsql-general

From Joe Conway
Subject Re: [GENERAL] Unable to connect to Postgresql
Date
Msg-id 1517b27c-2482-4466-1ca9-62b2a0f5bfd5@joeconway.com
Whole thread Raw
In response to Re: [GENERAL] Unable to connect to Postgresql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] Unable to connect to Postgresql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: [GENERAL] Unable to connect to Postgresql  (John Iliffe <john.iliffe@iliffe.ca>)
List pgsql-general
On 04/07/2017 05:35 PM, Adrian Klaver wrote:
> On 04/07/2017 05:03 PM, John Iliffe wrote:

>>>> Running on Fedora 25 with SELinux in PERMISSIVE mode.  The audit log
>>>> shows no hits on Postgresql.

>> My going in position was/still is, that this is a SELinux security
>> problem
>> but I am finding SELinux to be the most opaque and badly documented
>> software
>> that I have ever had to deal with, which is why it is running in
>> permissive
>> mode at the moment.
>
> Well what I know about SELinux would fit in the navel of a flea(tip of
> the hat to David Niven), so I can not be of much help there. The reason
> I am returned this thread to the list, there are folks that do
> understand it.

If SELinux is running in permissive I don't see how it could be at fault
for your issue. Did you verify that (getenforce)?

>> --------------------------
>> [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 ----------------------------

This might be a silly question, but is PHP running on the same server as
Postgres?

HTH,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


Attachment

pgsql-general by date:

Previous
From: John Iliffe
Date:
Subject: Re: [GENERAL] Unable to connect to Postgresql
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] SELECT and RowExclusiveLock