Sorry for not fully reading your post. That's what I get 4 spd rdng. Just another WAG--have you tried using get_resource_type() on $myconn? That may tell you whether the thing exists after its creation, and if it does, it should tell you "pgsql link" as the resource type. I'd suspect that if it doesn't know the type that the postgresql interface is not enabled. Again, sorry for shooting from the hip with the first answer. dwb > -----Original Message----- > From: Nathaniel Price [mailto:seoman@myrealbox.com] > Sent: Friday, March 28, 2003 4:23 PM > To: php-db@lists.php.net > Subject: Re: Connection issues with pgsql? > > > As I said in my first post, I tried the following connection > strings as > well: > "dbname=thornvalley user=apache password=[passwd]" > "dbname=thornvalley user=apache password=[passwd] > host=localhost port=5432" > > and had the same results. After messing around with > pg_hba.conf (I set local > authentication to 'password' instead of 'ident', I was able > to get an error > message /when I used the wrong password/: > > Warning: pg_connect() [function.pg-connect]: Unable to > connect to PostgreSQL > server: FATAL: Password authentication failed for user "apache" . in > /var/www/html/dbtest.php on line 3 > error > > If I used the correct password, that message would not > appear. Furthermore, > when I added the line > echo "$myconn = ".$myconn; > to my script after pg_connect(), I would get: > > $myconn = Resource id #2 > > which suggessts to me that it is successful in connecting to > the db server, > but, for some reason PHP is unable to use the connection > after that. Like I > said, it's weird. I have no idea why it's doing that. > > ----- Original Message ----- > From: "Dave Brunberg" <DBrunberg@FBLEOPOLD.com> > To: "'Nathaniel Price'" <seoman@thornvalley.com>; > <php-db@lists.php.net> > Sent: Friday, March 28, 2003 12:24 PM > Subject: RE: Connection issues with pgsql? > > > > I'd suggest building a connection string, explicitly > defining the user and > > password. Maybe it would give you a more descriptive error that way > > ("invalid user", etc.). > > > > The other thing I've done is do something like this: > > > > $database = pg_connect ($conn_string) > > or die ("Help! No connection to the database! Error: " . > > pg_last_error()); > > > > > > That may give you some more diagnostic info? > > > > dwb > > > -----Original Message----- > > > From: Nathaniel Price [mailto:seoman@myrealbox.com] > > > Sent: Friday, March 28, 2003 2:05 PM > > > To: php-db@lists.php.net > > > Subject: Connection issues with pgsql? > [snip] > > > I have > > > tried using > > > other connection strings as well: > > > "dbname=thornvalley user=apache password=[passwd]" > > > "dbname=thornvalley user=apache password=[passwd] > > > host=localhost port=5432" > > > > > > with the same result. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
