pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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: Mon, 14 Aug 2006 19:06:00 +0100
Message-ID: <44E0BB88.1050500@mailnetwork.co.uk> (raw)
In-Reply-To: <2220.193.140.224.60.1155545323.squirrel@cs.hacettepe.edu.tr>
References: <2033.193.140.224.60.1155482848.squirrel@cs.hacettepe.edu.tr>
	<44DF7E5B.6070807@mailnetwork.co.uk>
	<2220.193.140.224.60.1155545323.squirrel@cs.hacettepe.edu.tr>

Excellent :)

No probs, and thanks for posting your solution, it may help someone else 
out in the future!

Andy.

Fatih Gulec wrote:
> I solve the problem by the help of Andy.
>
> 1. I change SELinux policy of the /tmp
>    [root@bulbul /]# chcon -R -h -t httpd_sys_script_rw_t /tmp
> 2. I change connection string
>    old : pgsql://postgres:bbmprens@127.0.0.1/prens
>    new : pgsql://postgres:bbmprens@unix(/tmp)/prens
>
> Then it works.
>
> Thank you so much Andy.
>
>   
>> 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
>>>
>>>
>>>
>>>
>>>
>>>       
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>        choose an index scan if your joining column's datatypes do not
>>        match
>>
>>     
>
>
> !DSPAM:37,44e0388d143291488815628!
>
>
>   




view thread (4+ messages)

Message-ID: <44E0BB88.1050500@mailnetwork.co.uk>
Permalink:  ../44E0BB88.1050500@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/44E0BB88.1050500@mailnetwork.co.uk

 · 

reply

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: <44E0BB88.1050500@mailnetwork.co.uk>
  References: <2033.193.140.224.60.1155482848.squirrel@cs.hacettepe.edu.tr> <44DF7E5B.6070807@mailnetwork.co.uk> <2220.193.140.224.60.1155545323.squirrel@cs.hacettepe.edu.tr> <44E0BB88.1050500@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