Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: GeoffreyDate: 2004-12-15 12:39:54
Subject: Re: postgresql compile errors
Previous:From: Keith WorthingtonDate: 2004-12-15 03:39:56
Subject: Re: status variables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group