pgAccess & phpPgAdmin with postgresql under FC6

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

 



I'm trying to access a postgresql database via the graphical frontends
pgAccess and phpPgAdmin, running under FC6 (completely up-to-date via
yum). The access control file, pg_hba.conf, contains

# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
host all all 192.168.0.3 255.255.255.255 md5

and I've edited /etc/init.d/postgresql to launch the postmaster with
the -i option to allow remote connections.

With pgAccess, I am unable to open the database using the host
localhost (couldn't open socket: host is unreachable), but using the
ip (192.168.0.3) works fine; at least after adding the final line
shown in my pg_hba.conf above.

With phpPgAdmin, when I enter http://localhost/phpPgAdmin in the
browser, I'm delivered to phpPgAdmin login page, but cannot login/open
the database (error message: login failed). However, when I enter
http://192.168.0.3/phpPgAdmin in the browser (the line that works for
pgAcess), I can't even get to the login screen message: (error
message: Forbidden: You don't have permission to access /phpPgAdmin on
this server).

I have read through the docs and online forums, and experimented with
various settings in pg_hba.conf, config.inc.php, php.ini,
/etc/init.d/postgresql, postgresql.conf, etc., as described in various
posts, but I'm stumped. I haven't seen this exact behavior described
before and was hoping it might enable on of you to tell me what I'm
missing or where I might look next.

Thanks for your help.

Daniel
___________________________
"Truth is our most valuable commodity--let us economize." -- Mark Twain


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux