Re: Unable to connect to PostgreSQL server via PHP

From: "John Coulthard" <bahhab(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to connect to PostgreSQL server via PHP
Date: 2007-08-13 15:34:19
Message-ID: BAY121-F355230C7B03563BA9CA2CFCFDC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "John Coulthard" <bahhab(at)hotmail(dot)com>
>CC: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP Date:
>Mon, 13 Aug 2007 10:09:15 -0400
>
>"John Coulthard" <bahhab(at)hotmail(dot)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(at)xyala john]# su webuser
[webuser(at)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-08-13 15:56:59 Re: non superuser creating flat files
Previous Message Lim Berger 2007-08-13 15:29:09 Re: "Out of memory" errors..