PHP Failing to connect to Postgres on CentOS 7

manpreet Best Answer 2 years ago

I can connect to my database by running php via the bash:

php -r '$ref="https://forum.tuteehub.com/tag/link">link=@pg_connect("host=fakehost.edu port=5432 dbname=db user=user password=totallynotthepassword");if($ref="https://forum.tuteehub.com/tag/link">link){echo "connected";} else { echo "no dice";}'

This results in a very happy "connected"

However, when I have the ref="https://forum.tuteehub.com/tag/exact">exact same PHP in a file served by Apache and go to that page, I get a very sad: "no dice"

Here is the code from the php file:

<ref="https://forum.tuteehub.com/tag/html">html>
 
  
 
 <ref="https://forum.tuteehub.com/tag/body">body>
 ref="https://forum.tuteehub.com/tag/link">link=@pg_connect("host=fakehost.edu port=5432 dbname=db user=user password=totallynotthepassword");if($ref="https://forum.tuteehub.com/tag/link">link){echo "connected";} else { echo "no dice";}
?>
 ref="https://forum.tuteehub.com/tag/body">body>
ref="https://forum.tuteehub.com/tag/html">html>

I thought it had to do with the apache user, but i just tested the same code su'ed to that user and it connected.