From: | John Cartwright <John(dot)C(dot)Cartwright(at)noaa(dot)gov> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: php pg_connect fails, pgsql works - RESOLVED |
Date: | 2008-03-10 23:15:27 |
Message-ID: | 47D5C10F.4080803@noaa.gov |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, the command-line client works fine that way.
Turns out the problem was SELinux permissions that had to be
specifically enabled.
Thanks for the suggestions and the help.
-- john
Scott Marlowe wrote:
> On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
> <John(dot)C(dot)Cartwright(at)noaa(dot)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' port=5432
>> sslmode='allow' user='test' password='mypassword' dbname='test'")
>>
>
> if you do psql like so, can it connect?
>
> psql -h postgres1.ndgc.noaa.gov -U test test
>
> ?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2008-03-10 23:47:05 | Re: Trigger to run @ connection time? |
Previous Message | Scott Marlowe | 2008-03-10 22:46:42 | Re: php pg_connect fails, pgsql works |