| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | ourdiaspora <ourdiaspora(at)protonmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: php connection failure |
| Date: | 2021-08-07 21:05:27 |
| Message-ID: | 156bf596-48c7-624f-8168-0cca5f5b35bf@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/7/21 1:09 PM, ourdiaspora wrote:
>
> On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | o1bigtenor | 2021-08-07 21:13:14 | Re: PostgreSQL reference coffee mug |
| Previous Message | ourdiaspora | 2021-08-07 20:09:19 | Re: php connection failure |