| From: | ourdiaspora <ourdiaspora(at)protonmail(dot)com> |
|---|---|
| To: | |
| 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 20:09:19 |
| Message-ID: | YkLdfOX_3gv9n7MfrpTel4LhjQiTtv30opOMkZ3vwMcnfK14ZXCMYdxYBQdEIJxbb4YS8fhBi9FdLocsw81gCAZ08f0v3UvdVdhWU3r1-bg=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>
"
> 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.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2021-08-07 21:05:27 | Re: php connection failure |
| Previous Message | Jehan-Guillaume de Rorthais | 2021-08-07 19:48:01 | Re: PostgreSQL reference coffee mug |