On 8/7/21 1:09 PM, ourdiaspora wrote:
On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
