Re: Unable to connect to PostgreSQL server via PHP - Mailing list pgsql-general

From John Coulthard
Subject Re: Unable to connect to PostgreSQL server via PHP
Date
Msg-id BAY121-F355230C7B03563BA9CA2CFCFDC0@phx.gbl
Whole thread Raw
In response to Re: Unable to connect to PostgreSQL server via PHP  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unable to connect to PostgreSQL server via PHP  ("John Coulthard" <bahhab@hotmail.com>)
List pgsql-general


>From: Tom Lane <tgl@sss.pgh.pa.us>
>To: "John Coulthard" <bahhab@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP Date:
>Mon, 13 Aug 2007 10:09:15 -0400
>
>"John Coulthard" <bahhab@hotmail.com> writes:
> > That's not my problem though this is "could not connect to server:
> > Permission denied"  If it's denying permission I must have the
>permissions
> > set wrong but where to I start looking for them?
>
>"Permission denied" is a pretty strange error for a TCP connect failure,
>as that is not a filesystem operation.
>
>Are you able to connect with psql, or some other non-php client?
>Use "psql -h localhost" to make sure it tries a TCP connection not
>a Unix-socket connection.
>

Thanks. You mean like this?  This connects without an error.

[root@xyala john]# su webuser
[webuser@xyala john]$ psql -h localhost lumbribase
Welcome to psql 8.0.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

lumbribase=>

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/


pgsql-general by date:

Previous
From: "Lim Berger"
Date:
Subject: Re: "Out of memory" errors..
Next
From: "Scott Marlowe"
Date:
Subject: Re: non superuser creating flat files