Re: [PHP-DB] Connection issues with pgsql?
OOPS! /me hangs head in shame... That's what it was. Guess that's what I get for always using PHPlib's abstraction layer... I hardly ever use the actual pg_*() functions anymore. Thanks for putting up with me. ;) Nathaniel Price http://www.thornvalley.com "Who is General Failure and why is he reading my hard drive?" - Original Message - From: "Jennifer Goodie" <[EMAIL PROTECTED]> To: "Nathaniel Price" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 1:27 PM Subject: RE: [PHP-DB] Connection issues with pgsql? > Check the documentation on pg_query. > http://www.php.net/manual/en/function.pg-query.php > > It expects the link identifier as the first argument and the query as the > second. Switch your arguments and you might have some luck. > > The manual is always a great place to look for answers to things like this. > > -Original Message- > From: Nathaniel Price [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 11:05 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Connection issues with pgsql? > > > Hi, I just installed PHP with pgsql support, and it doesn't seem to work > properly, although I don't see why it shouldn't. > > I'm running the following script: > error_reporting (E_ALL); > $myconn = pg_connect("dbname=thornvalley"); > $res = pg_query('select * from test;', $myconn); > print_r(pg_fetch_row($res)); > ?> > > and this is what I get back: > Warning: pg_query(): supplied argument is not a valid PostgreSQL link > resource in /var/www/html/dbtest.php on line 4 > > Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result > resource in /var/www/html/dbtest.php on line 5 > > without any other clues as to what might be happening. 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. > > I'm not sure what's going on; just so that you know, I'm using the RPM-based > install of Apache 2.0.44, PHP 4.3.1 and PostgreSQL 7.3.2 that comes with > Mandrake Linux 9.1. All of the necessary support packages (AFAIK) have been > installed and are visible with phpinfo() (i.e. there's a pgsql section), and > I have defined an apache user in the PostgreSQL database... so, any clues as > to what might be going on? > > > Nathaniel Price http://www.thornvalley.com > "Who is General Failure and why is he reading my hard drive?" > > > -- > 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 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Connection issues with pgsql?
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:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 4:23 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> > To: "'Nathaniel Price'" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Friday, March 28, 2003 12:24 PM > Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] > > > Sent: Friday, March 28, 2003 2:05 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] 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
RE: [PHP-DB] Connection issues with pgsql?
Check the documentation on pg_query. http://www.php.net/manual/en/function.pg-query.php It expects the link identifier as the first argument and the query as the second. Switch your arguments and you might have some luck. The manual is always a great place to look for answers to things like this. -Original Message- From: Nathaniel Price [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connection issues with pgsql? Hi, I just installed PHP with pgsql support, and it doesn't seem to work properly, although I don't see why it shouldn't. I'm running the following script: and this is what I get back: Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/dbtest.php on line 4 Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/html/dbtest.php on line 5 without any other clues as to what might be happening. 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. I'm not sure what's going on; just so that you know, I'm using the RPM-based install of Apache 2.0.44, PHP 4.3.1 and PostgreSQL 7.3.2 that comes with Mandrake Linux 9.1. All of the necessary support packages (AFAIK) have been installed and are visible with phpinfo() (i.e. there's a pgsql section), and I have defined an apache user in the PostgreSQL database... so, any clues as to what might be going on? Nathaniel Price http://www.thornvalley.com "Who is General Failure and why is he reading my hard drive?" -- 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
Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "'Nathaniel Price'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 12:24 PM Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] > > Sent: Friday, March 28, 2003 2:05 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] 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
RE: [PHP-DB] 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:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 2:05 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Connection issues with pgsql? > > > Hi, I just installed PHP with pgsql support, and it doesn't > seem to work > properly, although I don't see why it shouldn't. > > I'm running the following script: > error_reporting (E_ALL); > $myconn = pg_connect("dbname=thornvalley"); > $res = pg_query('select * from test;', $myconn); > print_r(pg_fetch_row($res)); > ?> > > and this is what I get back: > Warning: pg_query(): supplied argument is not a valid PostgreSQL link > resource in /var/www/html/dbtest.php on line 4 > > Warning: pg_fetch_row(): supplied argument is not a valid > PostgreSQL result > resource in /var/www/html/dbtest.php on line 5 > > without any other clues as to what might be happening. 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. > > I'm not sure what's going on; just so that you know, I'm > using the RPM-based > install of Apache 2.0.44, PHP 4.3.1 and PostgreSQL 7.3.2 that > comes with > Mandrake Linux 9.1. All of the necessary support packages > (AFAIK) have been > installed and are visible with phpinfo() (i.e. there's a > pgsql section), and > I have defined an apache user in the PostgreSQL database... > so, any clues as > to what might be going on? > > > Nathaniel Price http://www.thornvalley.com > "Who is General Failure and why is he reading my hard drive?" > > > -- > 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