On 8/7/21 1:09 PM, ourdiaspora wrote:
>
> On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
>>> Since further configuration, remain unable to connect to the php database.
>>
>> Further configuration of what?
>>
>
> The postgresql configuration file:
>
> SHOW hba_file;
> /etc/postgresql/9.6/main/pg_hba.conf
> SHOW config_file;
> /etc/postgresql/9.6/main/postgresql.conf
>
>> After the configuration change did you restart the server?
>>
>
> Yes; the php web page recognised changes, for example removal of the comment instruction:
> "
> <html>
> <head>
> Generic CPAC
> </head>
> <body>
> <?php
> //echo '<p>Hello World</p>'
> /*successful test of configuration of apache http server*/
> phpinfo();
> ?>
> </body>
> </html>
> "
That is the Apache server restarting. I was asking about restarting the
Postgres server. Was that done?
>
>> Is the pg_hba.conf file the correct one for the database instance?
>>
>
> Changes were made to the function 'listen_addressess' to the configuration file shown in above.
The connection was reaching the database so the 'listen_addresses' is
correct. The issue is with the settings in pg_hba.conf and the
connection being attempted. There have been similar problems with
various OSes and their handling of localhost/120.0.0.2/::1.
So for the machine that is running the Postgres server:
1) OS and version?
2) The contents of /etc/hosts
3) What happens if you do?:
psql -d cpacweb -h 127.0.0.1 -U cpaca
>
>
>> What does:
>>
>> pg_lsclusters
>>
>> show?
>>
>
> pg_lsclusters
> Ver Cluster Port Status Owner Data directory Log file
> 9.6 main 5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log
>
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com