Обсуждение: pg_connect fails, pgsql works

Hello All,

I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
version 8.2.3.   I think that TCP connections are enabled correctly in
the server's pg_hba.conf and I can successfully connect from the client
using pgsql.  However, trying to use pg_connect() w/ a call like:

$con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
sslmode='allow' user='test' password='mypassword' dbname='test'")


fails saying:

 Unable to connect to PostgreSQL server: could not connect to server:
Permission denied\n\tIs the server running on host
"postgres1.ngdc.noaa.gov" and accepting\n\tTCP/IP connections
on port 5432?

I'm perplexed since I can connect w/ pgsql from the same workstation
using the same database, user, password.

Can anyone help me out here?

Thanks!

-- john

On 10/03/2008 17:37, John Cartwright wrote:

> $con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
> sslmode='allow' user='test' password='mypassword' dbname='test'")

I don't think you need to quote the host, uid, etc - try it without the
single quotes, e.g.

"host=postgres1.ngdc.noaa.gov port=5432 sslmode=allow user=test [....]"

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

Thanks for your suggestion Ray, but I get the same error even w/o the
values being single-quoted.

-- john


Raymond O'Donnell wrote:
> On 10/03/2008 17:37, John Cartwright wrote:
>
>> $con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
>> sslmode='allow' user='test' password='mypassword' dbname='test'")
>
> I don't think you need to quote the host, uid, etc - try it without
> the single quotes, e.g.
>
> "host=postgres1.ngdc.noaa.gov port=5432 sslmode=allow user=test [....]"
>
> HTH,
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> ---------------------------------------------------------------

On 10/03/2008 20:06, John Cartwright wrote:
> Thanks for your suggestion Ray, but I get the same error even w/o the
> values being single-quoted.

In that case I'm perplexed too! You ought to re-post to pgsql-general -
that list is a *lot* more active than this one, so you'd have a better
chance of having your problem solved.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

are you sure it's not some kind of firewall issue?

can you post your pg_hba conf to make sure it's set up properly?

Only other thing i can think of is to try changing the host to IP address form, in case there's some kind of DNS resolution problem.

hope that helps,

-Jovan

John Cartwright wrote:
> I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
> version 8.2.3.   I think that TCP connections are enabled correctly in
> the server's pg_hba.conf and I can successfully connect from the client
> using pgsql.  However, trying to use pg_connect() w/ a call like:
>
> $con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
> sslmode='allow' user='test' password='mypassword' dbname='test'")
>
> fails saying:
>
> Unable to connect to PostgreSQL server: could not connect to server:
> Permission denied\n\tIs the server running on host
> "postgres1.ngdc.noaa.gov" and accepting\n\tTCP/IP connections
> on port 5432?
>
> I'm perplexed since I can connect w/ pgsql from the same workstation
> using the same database, user, password.


Are you using all the same options when starting psql?  What psql
command are you issuing?  Are you running psql on the same system that
runs apache/php?

Thanks for the suggestion Jovan.  It turned out to be a SELinux
permissions issue that only affected apache processes.

-- john

F. Jovan Jester wrote:
> are you sure it's not some kind of firewall issue?
>
> can you post your pg_hba conf to make sure it's set up properly?
>
> Only other thing i can think of is to try changing the host to IP
> address form, in case there's some kind of DNS resolution problem.
>
> hope that helps,
>
> -Jovan
>
>
> On 3/10/08, *John Cartwright* <John.C.Cartwright@noaa.gov
> <mailto:John.C.Cartwright@noaa.gov>> wrote:
>
>     Hello All,
>
>     I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql
>     server
>     version 8.2.3.   I think that TCP connections are enabled correctly in
>     the server's pg_hba.conf and I can successfully connect from the
>     client
>     using pgsql.  However, trying to use pg_connect() w/ a call like:
>
>     $con = pg_connect("host='postgres1.ngdc.noaa.gov
>     <http://postgres1.ngdc.noaa.gov>' port=5432
>     sslmode='allow' user='test' password='mypassword' dbname='test'")
>
>
>     fails saying:
>
>       Unable to connect to PostgreSQL server: could not connect to server:
>     Permission denied\n\tIs the server running on host
>     "postgres1.ngdc.noaa.gov" and accepting\n\tTCP/IP
>     connections
>     on port 5432?
>
>     I'm perplexed since I can connect w/ pgsql from the same workstation
>     using the same database, user, password.
>
>     Can anyone help me out here?
>
>     Thanks!
>
>     -- john
>
>
>
>     --
>     Sent via pgsql-php mailing list (pgsql-php@postgresql.org
>     <mailto:pgsql-php@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-php
>
>
>
>