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 nnn.nnn.nnn.nnn database_name -p 5432 -U user -W
>
> works fine.
>
> Like I wrote before, if I run the same script from the command line
> with the same php build...
> ie:
> cmd_line/> php db_test.php
>
> the script works fine and retrieves data fromt he database.
>
> If I try to serve the same php page via apache it
> can't connect, thus no $db object is returned from
> $db=DB::connect("pgsql://yada:[EMAIL PROTECTED]/databasename");
>
> I've tried running the php as various users including apache from
> the command line and it continues to work fine there. So, it's not
> a user permissions thing.
>
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 PHP that apache is using is connecting
via a socket instead of a port (or vice-versa)
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
