postgres connection woes...

shaniber

I have been attempting to connect to a postgres database through a php script for a couple of days now, and I am having a difficult time of it.

Specifically, when I attempt to connect to the database, it won't make the connection, but does not return an error message. Here's my script (code is available in a link on the page): (http://swamp.usask.ca/tests/php/db.php).

The database should be installed correctly, since I am able to connect to it through a perl cgi script: (http://swamp.usask.ca/cgi-bin/tests/db.cgi).

Here's the output of running the postmaster at debug level 4: (http://swamp.usask.ca/tests/php/db-output.html).

I've granted the UID that the webserver runs under ALL privelages, as well as the user db, which it should be connecting as. I think that I've also got my pg_hba.conf file setup correctly: (http://swamp.usask.ca/tests/php/pg_hba.conf.html).

Any insights into this problem would be greatly appreciated!

thanks,
shane doucette.

amcgrath

You are connecting, there're things wrong in your code, for instance, this:
if (!($connection=pg_pconnect("dbname=test host=localhost user=db"))); {

should be :
if (!($connection=pg_pconnect("dbname=test host=localhost user=db"))) {

or even more clear:
if (!$connection=pg_pconnect("dbname=test host=localhost user=db")) {

I ran your code and here and connected fine.

shaniber

d\'oh.

thanks for the extra set of eyes, Allan... how horribly embarrasing can you get. I blame the propane fumes in my office. removing the semicolon worked just fine. yeesh.

oh well, maybe all my problems will be this trivial. 🙂

appreciating the help,
shane.

Allen McGrath wrote:

You are connecting, there\'re things wrong in your code, for instance, this:
if (!($connection=pg_pconnect(\"dbname=test host=localhost user=db\"))); {

should be :
if (!($connection=pg_pconnect(\"dbname=test host=localhost user=db\"))) {

or even more clear:
if (!$connection=pg_pconnect(\"dbname=test host=localhost user=db\")) {

I ran your code and here and connected fine.

amcgrath

np, i was a lil unsure whether to post an answer cuz the code looked right... good luck

AMC