Re: DB Error: connect failed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxx/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@xxxxxxxxx/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@xxxxxxxxxxxxxx so that your
>>        message can get through to the mailing list cleanly
>>
>> !DSPAM:37,44df4bd2143293352620759!
>>
>>
>>
>
>
> ---------------------------(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
>



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux