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/
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.. |