pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Cartwright <John.C.Cartwright@noaa.gov>
To: pgsql-php@postgresql.org
Subject: pg_connect fails, pgsql works
Date: Mon, 10 Mar 2008 11:37:51 -0600
Message-ID: <47D571EF.8020408@noaa.gov> (raw)

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 
&quot;postgres1.ngdc.noaa.gov&quot; 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




view thread (7+ messages)  latest in thread

Message-ID: <47D571EF.8020408@noaa.gov>
Permalink:  ../47D571EF.8020408@noaa.gov/
Also on:    postgresql.org/message-id/47D571EF.8020408@noaa.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: John.C.Cartwright@noaa.gov
  Subject: Re: pg_connect fails, pgsql works
  In-Reply-To: <47D571EF.8020408@noaa.gov>
  References: <47D571EF.8020408@noaa.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox