Re: php connection failure
| От | Adrian Klaver |
|---|---|
| Тема | Re: php connection failure |
| Дата | |
| Msg-id | 156bf596-48c7-624f-8168-0cca5f5b35bf@aklaver.com обсуждение исходный текст |
| Ответ на | Re: php connection failure (ourdiaspora <ourdiaspora@protonmail.com>) |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: