pgAccess & phpPgAdmin with postgresql under FC6

[Craig White]

On Fri, 2007-02-02 at 11:46 -0800, parishd wrote:
> On 2/2/07, parishd <parishd at gmail.com> wrote:
> > On 2/2/07, Craig White <craig at tobyhouse.com> wrote:
> > >
> > > I would venture to guess that you are running into SELinux issues...
> > >
> >
> > Dang, normally the first thing I check, but didn't this time and guess
> > what?  Thanks for the nudge Craig!  It's strange that I was getting no
> > errors about it in /var/log/messages _until_ I disabled selinux; now
> > I'm getting a denied message although it's not being enforced.
> >
> > Still have the strangeness of being able to access the dbs via
> > pgAccess with the ip address but not localhost, and via phpPgAdmin via
> > localhost but not the ip, but at least I'm in.
> >
> > Thanks again.
> >
> > Daniel
> >
> Neglected to mention that the access to the db via phpPgAdmin was
> solved by checking the "Allow HTTPD scripts and modules to network
> connect to databases" in the SELinux tab of
> system-config-securitylevel under Modify SELinux Policy/HTTPD Service.
----
I was gonna get around to that once you confirmed that it was SELinux
that was blocking your efforts.

The other issue is very possibly the md5 access for the 'postgres' user
which is probably blocked from executing the binary since a connection
attempt using md5 would require the 'user postgres' to execute the
binary.

Craig