PHP is connecting to AWS PostgreSQL 14.6 from local machine but not from web server

Asked May 03 '23 at 19:40

Active May 04 '23 at 10:14

Viewed 25 times

The PHP is connecting to an AWS PostgreSQL 11.5 database from the web server. It has the same VPC's as the one I am trying to connect to.

Here is the PHP code that works when connecting to the database from local machine:

$db = pg_connect( "$host $port $dbname $credentials" );
if(!$db) {
 echo "Error : Unable to open database\n";
} else {
 echo "Opened database successfully\n";
}

When the php is loaded from the web browser, it displays:

"Error : Unable to open database"

How can I fix this issue?

edited May 04 '23 at 10:14

Arpit Jain

1,599
9
23

asked May 03 '23 at 19:40

AlanGood113

Have you checked the web server error log? – Jason K May 03 '23 at 19:42
Try calling `pg_last_error($db);` to find out _why_ it failed. – Sammitch May 03 '23 at 19:51
pg_last_error($db); is blank, which probably means that there is no error – AlanGood113 May 03 '23 at 20:27
Also the server error logs are not giving a description of the error. – AlanGood113 May 03 '23 at 20:33
Are you manually able to connect to the database? Do inbound rules for database instances allow public access? – Arpit Jain May 04 '23 at 04:25
Yes, I can connect to the database from my local machine. The inbound rules are the same as the other databases that I can connect to from online. – AlanGood113 May 04 '23 at 15:26

PHP is connecting to AWS PostgreSQL 14.6 from local machine but not from web server

0 Answers0