Re: Trouble connecting to database using PQconnectdb (C/libpq)

Tom Lane wrote:
> Joel Alpers <joel@jkalpers.com> writes:
>
>> New system:  Fedora 11, PostgreSQL 8.4
>>
>
> Fedora 11 enables selinux by default ...
>
>
>> *** Error - Can't connect to database "photodb" - could not connect to server: Permission denied
>>     Is the server running on host "192.168.111.7" and accepting
>>     TCP/IP connections on port 5432?
>>
>
> Almost certainly, this represents selinux thinking that apache shouldn't
> be making connections to random ports, and denying the socket open long
> before it ever has a chance to get to postgres.
>
> If you poke around in the selinux configuration options you can probably
> find a switch that opens this up, but I don't know offhand what it is.
>
> Or you could disable selinux, but if you're running a publicly visible
> webserver I'd strongly recommend against that.  selinux will save your
> bacon someday, but not if it's turned off.
>
>             regards, tom lane
>
>
Tom:

Thanks for the quick reply - looks like you were spot on with your analysis.

I temporarily set selinix to "permissive" and the web page works as it
should.

Now the trick will be to find a way to make them play well together -- I'll
check the postgres site where they have discussions archived...

Thanks again!!!

Joel.

--


+--------------------------------------------------------------------+
|  Joel K. Alpers
|  Expressive Black and White Images
|  http://www.jkalpers.com
+--------------------------------------------------------------------+