Problems connecting (from php to pg)

Hello all,

I've the "standard connection error":

Unable to connect to PostgreSQL server: could not connect to server:
Permission denied.
Is the server running on host "localhost" and accepting TCP/IP
connections on port 5432?

The system is, yes, running and -I think- accepting TCP/IP connections
(I've tested this with netstat, I can connect to it with psql -h
localhost, and so).

In the server where I am testing this I have FC7 installed, so the php
and the pgsql-php packages are:

PHP Version 5.2.6
PostgreSQL(libpq) Version 8.2.7

I think that there is a problem in the pgsql-php module. I've created
a ssh tunnel, and trying the connection to the same database from
other server (with PHP Version 5.2.5-3 and pgsql that supports
postgresql 8.3.0).

The postgresql version in the server is the 8.3.0.

What can we do? I am doing these tests with a simple php code (just a
pg_connect()).

Thanks in advance,
Carlos.

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Problems connecting (from php to pg)

2008/6/7 Carlos Costa :
> Hello all,
>
> I've the "standard connection error":
>
> Unable to connect to PostgreSQL server: could not connect to server:
> Permission denied.
> Is the server running on host "localhost" and accepting TCP/IP
> connections on port 5432?
>
> The system is, yes, running and -I think- accepting TCP/IP connections
> (I've tested this with netstat, I can connect to it with psql -h
> localhost, and so).
>
> In the server where I am testing this I have FC7 installed, so the php
> and the pgsql-php packages are:
>
> PHP Version 5.2.6
> PostgreSQL(libpq) Version 8.2.7
>
> I think that there is a problem in the pgsql-php module. I've created
> a ssh tunnel, and trying the connection to the same database from
> other server (with PHP Version 5.2.5-3 and pgsql that supports
> postgresql 8.3.0).
>
> The postgresql version in the server is the 8.3.0.
>
> What can we do? I am doing these tests with a simple php code (just a
> pg_connect()).
>
> Thanks in advance,
> Carlos.
>
> --
> Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php
>
Did you check your pg_hba.conf file ???

Bye :)
--
Daniel Carrero Canales

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Problems connecting (from php to pg)

Thank you, Daniel and all. My problem was not related to pg, but to
selinux. I disabled selinux, and all runs fine now.

On Mon, Jun 9, 2008 at 10:17 PM, Daniel Alejandro wrote:
> 2008/6/7 Carlos Costa :
>> Hello all,
>>
>> I've the "standard connection error":
>>
>> Unable to connect to PostgreSQL server: could not connect to server:
>> Permission denied.
>> Is the server running on host "localhost" and accepting TCP/IP
>> connections on port 5432?
>>
>> The system is, yes, running and -I think- accepting TCP/IP connections
>> (I've tested this with netstat, I can connect to it with psql -h
>> localhost, and so).
>>
>> In the server where I am testing this I have FC7 installed, so the php
>> and the pgsql-php packages are:
>>
>> PHP Version 5.2.6
>> PostgreSQL(libpq) Version 8.2.7
>>
>> I think that there is a problem in the pgsql-php module. I've created
>> a ssh tunnel, and trying the connection to the same database from
>> other server (with PHP Version 5.2.5-3 and pgsql that supports
>> postgresql 8.3.0).
>>
>> The postgresql version in the server is the 8.3.0.
>>
>> What can we do? I am doing these tests with a simple php code (just a
>> pg_connect()).
>>
>> Thanks in advance,
>> Carlos.
>>
>> --
>> Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-php
>>
> Did you check your pg_hba.conf file ???
>
> Bye :)
> --
> Daniel Carrero Canales
>

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php