Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X

From: Lola Lee <lola(at)his(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
Date: 2004-12-15 11:31:57
Message-ID: 41C020AD.6020903@his.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)his(dot)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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Geoffrey 2004-12-15 12:39:54 Re: postgresql compile errors
Previous Message Keith Worthington 2004-12-15 03:39:56 Re: status variables