From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
To: Fatih Gulec <fatihg@cs.hacettepe.edu.tr>
Cc: pgsql-php@postgresql.org
Subject: Re: DB Error: connect failed
Date: Sun, 13 Aug 2006 20:32:43 +0100
Message-ID: <44DF7E5B.6070807@mailnetwork.co.uk> (raw)
In-Reply-To: <2033.193.140.224.60.1155482848.squirrel@cs.hacettepe.edu.tr>
References: <2033.193.140.224.60.1155482848.squirrel@cs.hacettepe.edu.tr>
Faith,
I'm guessing one of 2 things is happening here:
- PHP is connecting through the Unix socket in /tmp, and permissions are
wrong on the /tmp directory for the Apache user
- Something like TCP wrappers is blocking localhost connections
Try changing the connection host to the machine's ethernet IP address
instead of 127.0.0.1, this will give you a clue if this is the case.
You could also examine the PostgreSQL logs - I doubt if it would log
this error, but it's worth a shot.
Andy.
Fatih Gulec wrote:
> Here is the problem :
> System : Fedora Core 5
> Application server : Apache (comes with Fedora base installation)
>
> 1. I could not connect to postgresql in php code whicih uses pear packet
> DB. Here is the error code :
> DB Error: connect failed [nativecode=Unable to connect to PostgreSQL
> server: could not connect to server: Permission denied Is the server
> running on host "127.0.0.1" and accepting TCP/IP connections on port
> 5432?] ** pgsql://postgres:bbmprens@127.0.0.1/prens
>
> 2. By the way I can connect that db from an other machine which the system
> is Windows XP and program is default PgAdmin.
> 2. Alsa I can connect and use from a windows machine with the sama php
> code that connects to the dbms which works on the Fedora Core 5.
> 3. The user and password are tested by using pgsql command, in command
> prompt.
>
> Thanks...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
> !DSPAM:37,44df4bd2143293352620759!
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: andy.shellam-lists@mailnetwork.co.uk, fatihg@cs.hacettepe.edu.tr
Subject: Re: DB Error: connect failed
In-Reply-To: <44DF7E5B.6070807@mailnetwork.co.uk>
References: <2033.193.140.224.60.1155482848.squirrel@cs.hacettepe.edu.tr> <44DF7E5B.6070807@mailnetwork.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox