Re: Unable to connect to Postgresql

On 04/09/2017 02:00 PM, John Iliffe wrote:
> On Sunday 09 April 2017 15:38:10 Adrian Klaver wrote:

>> Remember host != local
>>
>> host is for IP connections
>>
>> local is for socket connections
>
> Yes, I had forgotten that for the moment. I have the following line in the
> 'local' section of the pg_hba.conf file:
>
> local all all password
>
> and this in the 'host' section
>
> host all all 127.0.0.1/32 password
>
> and at the moment I can connect using this:
>
> $db_handle = pg_connect('dbname=yrarc host=localhost port=5432 user=yrcro
> password=yrreadonly');
>
> but NOT using this:
>
> $db_handle = pg_connect('dbname=yrarc user=yrcro password=yrreadonly');
>
> so I have a problem with the domain sockets.

I don't think it has been asked and for the sake of completeness, what
do you have listen_addresses set to in postgresql.conf?

To solve this is going to require starting as close to the Postgres
server as possible and use a consistent connection string between psql
and your PHP code. For the time being I would leave the Apache server
out of the loop as well as your workstation(as much as possible).

So:

1) Log into the machine with the Postgres server.

2) Using psql:

psql 'dbname=yrarc user=yrcro password=yrreadonly'

3) Using a standalone PHP script:

$db_handle = pg_connect('dbname=yrarc user=yrcro password=yrreadonly')

Report back.

>
> Based on the reference that Joe sent earlier, I do have a second domain
> socket on /var/pgsql but the problem is how do I get PHP to look there?
> There isn't any config file for mod_php and php-fpm has one but the location
> of the domain socket is the default - /tmp/.s.......
>
> I don't think this is the problem if this list unless someone happens to
> know the solution. If not, then thank you for all the work, and especially
> for the promptness of the responses. I'm not at all sure that I could
> have figured this out by myself.
>
> John
>>

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