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@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
---------------------------(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!
