Re: php connection failure

On 8/11/21 4:09 AM, ourdiaspora wrote:

> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> For sign-in today via commands below, the log file shows nothing new, only the old errors:
> "
> psql -d cpacweb -U cpacapsql (9.6.16)
> Type "help" for help.
>
> cpacweb=> \q
> psql -d cpacweb -h localhost -U cpaca Password for user cpaca:
> psql (9.6.16)
> SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
> Type "help" for help.
>
> cpacweb=> \q
> "
>
> The connection to postgresql seems OK now (thank you), but the php web page continues to fail to connect to the database:

Is the Web server/PHP app on the same machine as the Postgres server?

If it is on the same machine what happens if you do?:

$dbconn = pg_connect("dbname=cpacweb user=cpaca") or die("Could not
connect");

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com