Re: php connection failure

On 8/7/21 1:09 PM, ourdiaspora wrote:
> 
> On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver  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:
> "
> 
> 	
> 		Generic CPAC
> 	
> 	
> 		 			//echo '
Hello World
'
> 			/*successful test of configuration of apache http server*/
> 			phpinfo();
> 		?>
> 	
> 
> "

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