Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

PHP Failing to connect to Postgres on CentOS 7

General Tech Bugs & Fixes

Max. 2000 characters
Replies

usr_profile.png

User

( 5 months ago )

 

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

php -r '$link=@pg_connect("host=fakehost.edu port=5432 dbname=db user=user password=totallynotthepassword");if($link){echo "connected";} else { echo "no dice";}'

This results in a very happy "connected"

However, when I have the 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:

<html>
 <head>
  <title>PHP Test</title>
 </head>
 <body>
 <?php
$link=@pg_connect("host=fakehost.edu port=5432 dbname=db user=user password=totallynotthepassword");if($link){echo "connected";} else { echo "no dice";}
?>
 </body>
</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.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif