Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X - Mailing list pgsql-novice

From Lola Lee
Subject Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
Date
Msg-id 41C020AD.6020903@his.com
Whole thread Raw
Responses Re: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
List pgsql-novice
I am running the latest version of OS X on my PowerBook.  When I try to
access my 7.4.3 Postgresql installation (I used the package from
entropy.ch), I get this message "Login disallowed for security reasons.
". So, I checked ph_hba.conf and this is how it is set up right now:


Code:
local   all         all                                             trust
# IPv4-style local connections:
host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust


  So I ought to be able to access the database server at
http://127.0.0.1/phpPgAdmin/, unless I'm missing something. Also, I
checked conf.inc.php for phpPgAdmin, as follows:


Code:
// Display name for the server on the login screen
$conf['servers'][0]['desc'] = 'PostgreSQL';

// Hostname or IP address for server.  Use '' for UNIX domain socket.
$conf['servers'][0]['host'] = '127.0.0.1';

// Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;

// Change the default database only if you cannot connect to template1
$conf['servers'][0]['defaultdb'] = 'template1';

// Specify the path to the database dump utilities for this server.
// You can set these to '' if no dumper is available.
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';

I also tried setting extra_login_security in config.inc.php, to true,
and to false, but that doesn't work in both cases.  When I access the
database server in Terminal as postgres, it works just fine.

I'm totally clueless as to why this is happening.  I've had previous
installations of Postgresl and had no problems.

--
Lola - mailto:lola@his.com
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
Terrorism delenda est! (Terrorism must be destroyed utterly!)
I'm in Bowie, MD, USA, halfway between DC and Annapolis.

pgsql-novice by date:

Previous
From: "Sam"
Date:
Subject: tsearch2 installation problem
Next
From: Geoffrey
Date:
Subject: Re: postgresql compile errors