Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-19 Thread Justin Patrin
On Thu, 19 Aug 2004 08:44:39 -0700, pw <[EMAIL PROTECTED]> wrote: > > > Justin Patrin wrote: > > > > > > Did you try: > > if(PEAR::isError($db)) { > > echo $db->getMessage().' '.$db->getUserInfo(); > > } > > > > It's probably because: > > 1) the postgres the module isn't in the PHP that apache

Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-19 Thread pw
Justin Patrin wrote: Did you try: if(PEAR::isError($db)) { echo $db->getMessage().' '.$db->getUserInfo(); } It's probably because: 1) the postgres the module isn't in the PHP that apache is using 2) the postgres module isn't loaded in the PHP that apache is using 3) the postgres module in the P

Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-18 Thread Justin Patrin
On Wed, 18 Aug 2004 14:23:49 -0700, pw <[EMAIL PROTECTED]> wrote: > > > Matthew Sims wrote: > > > > And check to see that PostgreSQL is accepting network connections rather > > than localhost. Is it listening to a port? > > > > Connecting remotely to postgres via the command line: > > psql -h n

Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-18 Thread pw
Matthew Sims wrote: And check to see that PostgreSQL is accepting network connections rather than localhost. Is it listening to a port? Connecting remotely to postgres via the command line: psql -h nnn.nnn.nnn.nnn database_name -p 5432 -U user -W works fine. Like I wrote before, if I run the same

Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-18 Thread pw
Justin Patrin wrote: Can't help you unless you give us an error... There's no error. DB_Error::toString() returns the following. [: message="" code=0 mode= level= prefix="" info=""] Peter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-18 Thread Matthew Sims
> On Wed, 18 Aug 2004 12:53:25 -0700, pw <[EMAIL PROTECTED]> wrote: >> Hello, >> >> I have an interesting problem with PostgreSQL >> via PearDB and PHP 4.3.3 . >> >> I have a php page that opens a remote connection >> to a Postgres database, performs a query, lists >> the results and then closes th

Re: [PHP] PHP/PearDB works on commandline but not via http....

2004-08-18 Thread Justin Patrin
On Wed, 18 Aug 2004 12:53:25 -0700, pw <[EMAIL PROTECTED]> wrote: > Hello, > > I have an interesting problem with PostgreSQL > via PearDB and PHP 4.3.3 . > > I have a php page that opens a remote connection > to a Postgres database, performs a query, lists > the results and then closes the connec

[PHP] PHP/PearDB works on commandline but not via http....

2004-08-18 Thread pw
Hello, I have an interesting problem with PostgreSQL via PearDB and PHP 4.3.3 . I have a php page that opens a remote connection to a Postgres database, performs a query, lists the results and then closes the connection. If I run the php from the command line the connection and query work fine. Php