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
