Re: postgresql connection failure

On 06/08/2021 13:35, ourdiaspora wrote:

Readers, After a day and half trying and failing, time to ask! :) Command terminal: sudo psql -d cpacweb -h localhost -U cpaca psql: FATAL: no pg_hba.conf entry for host "::1", user "cpaca", database "cpacweb", SSL on FATAL: no pg_hba.conf entry for host "::1", user "cpaca", database "cpacweb", SSL off SHOW hba_file; /etc/postgresql/9.6/main/pg_hba.conf sudo nano /etc/postgresql/9.6/main/pg_hba.conf local all postgres peer TYPE DATABASE USER ADDRESS METHOD ================================= "local" is for Unix domain socket connections only ================================================== local all all peer IPv4 local connections: ======================= host all all 127.0.0.1/32 md5 IPv6 local connections: ======================= host all all ::1/128 md5 Allow replication connections from localhost, by a user with the ================================================================ replication privilege. ====================== #local replication postgres peer #host replication postgres 127.0.0.1/32 md5 #host replication postgres ::1/128 md5 local cpacweb cpaca ::1/128 trust Also tried: <html>

     <head>

     	Generic CPAC database
     </head>

     <body>

     	<?php
     		error_reporting(E_ALL);

pg_connect("host=localhost port=5432 dbname=cpacweb"); echo pg_dbname(); ?>

     </body>

</html> No success, but: <html>

     <head>

     	Generic CPAC
     </head>

     <body>

     	<?php
     		//echo '<p>Hello World</p>'

     		/*successful test of configuration of apache http server*/
     		phpinfo();
     	?>

     </body>

</html> returns a successful web page of system information details. Please how to connect successfully to the postgresql database?

This looks to be more of a problem with your Postgres DB not allowing the connection than anything specific to PHP. Couple of seconds Googling the first error brings up a SO post where someone suggests editing your postgresql.conf file adding the line: listen_addresses = '*' However, I would recommend only allowing the addresses you actually know that should be connecting to this DB. It also lists some advice about what changes you need to make to your pg_hba.conf to allow access for all users with an encrypted password, but you don't appear to actually be using a password on your database (none of your connection strings have one, and the error is about something else). I would always use a password for any DB, regardless of how locked down it may be in other areas. -- Ashley Sheridan https://www.ashleysheridan.co.uk