BUG #2118: could not connect to server
The following bug has been logged online:
Bug reference: 2118
Logged by: zhuge xiao
Email address: zhuge@Rinaix.cn
PostgreSQL version: 8.0.3
Operating system: Linux ( FC4 )
Description: could not connect to server
Details:
Help me!
I have edited the program testlibpq.c which is copied from the PostgreSQL
document to make it become a CGI program. And I have succeeded to compile
the programme, testlibpq.c from the command line:
[zhuge@xiao2 src]$ cc -o testlibpq testlibpq.c -lpq
And it can run from the command line:
[zhuge@xiao2 src]$ ./testlibpq
Then, I copied the excuteable program to the CGI directory,
/var/www/cgi-bin. And let it run from the Mozilla Firefox browser whose URL
was http://localhost/cgi-bin/testlibpq. But I failed. The result was that
the below message was displayed in the browser:
could not connect to server: Permission denied
Is the server running locally and accepting connections on Unix domain
socket "/tmp/.s.PGSQL.5432"?
The above message was produced by the below code:
if (PQstatus(conn) != CONNECTION_OK)
{
fprintf(stdout, PQerrorMessage(conn));
exit_nicely(conn);
}
How can I do? Please help me!
Thank you very much.
zhuge@Rinaix.cn
Hi,
On Tue, 2005-12-20 at 08:44 +0000, zhuge xiao wrote:
PostgreSQL version: 8.0.3
Operating system: Linux ( FC4 )
Description: could not connect to server
Details:
I have edited the program testlibpq.c which is copied from the PostgreSQL
document to make it become a CGI program. And I have succeeded to compile
the programme, testlibpq.c from the command line:
[zhuge@xiao2 src]$ cc -o testlibpq testlibpq.c -lpqAnd it can run from the command line:
[zhuge@xiao2 src]$ ./testlibpqThen, I copied the excuteable program to the CGI directory,
/var/www/cgi-bin. And let it run from the Mozilla Firefox browser whose URL
was http://localhost/cgi-bin/testlibpq. But I failed. The result was that
the below message was displayed in the browser:
could not connect to server: Permission denied
Is the server running locally and accepting connections on Unix domain
socket "/tmp/.s.PGSQL.5432"?
Is postmaster running?
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
"zhuge xiao" <zhuge@Rinaix.cn> writes:
could not connect to server: Permission denied
Is the server running locally and accepting connections on Unix domain
socket "/tmp/.s.PGSQL.5432"?
"Permission denied" indicates a file permissions problem. Check the
permissions on /tmp and on the socket file itself. If you have SELinux
enabled in enforcing mode, you might also have a SELinux policy problem
--- is your selinux-policy package up to date?regards, tom lane
Tom Lane,
I have read the email you mailed me. And I have SELinux enabled in permissive mode and the testlibpq program can run. I am very happy. In the future, I will use the PostgreSQL and give up the MySQL and other databases. I think the PostgreSQL is better than the others.
Thank you very much.
zhuge xiao <zhuge@Rinaix.cn>
Tom Lane wrote:
Show quoted text
"zhuge xiao" <zhuge@Rinaix.cn> writes:
could not connect to server: Permission denied
Is the server running locally and accepting connections on Unix domain
socket "/tmp/.s.PGSQL.5432"?"Permission denied" indicates a file permissions problem. Check the permissions on /tmp and on the socket file itself. If you have SELinux enabled in enforcing mode, you might also have a SELinux policy problem --- is your selinux-policy package up to date?regards, tom lane
Import Notes
Resolved by subject fallback
Tom Lane,
I have read the email you mailed me yesterday. And I
have SELinux enabled in permissive mode and the
testlibpq program can run. I am very happy. In the
future, I will use the PostgreSQL and give up the
MySQL and other databases. I think the PostgreSQL is
better than the others.
Thank you very much.
zhuge xiao <zhuge@Rinaix.cn>
Tom Lane wrote:
"zhuge xiao" <zhuge@Rinaix.cn> writes:
could not connect to server: Permission denied
Is the server running locally and accepting
connections on Unix domain
socket "/tmp/.s.PGSQL.5432"?
"Permission denied" indicates a file permissions
problem. Check the
permissions on /tmp and on the socket file itself.
If you have SELinux
enabled in enforcing mode, you might also have a
SELinux policy problem
--- is your selinux-policy package up to date?regards, tom lane
__________________________________________
Yahoo! DSL � Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
Import Notes
Resolved by subject fallback