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

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

From
Lola Lee
Date:
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.

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

From
John DeSoi
Date:
Hi Lola,

On Dec 15, 2004, at 6:31 AM, Lola Lee wrote:

> 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:

This is in the FAQ document in the phpPgAdmin main directory:

Q: For some users I get a "Login disallowed for security" message.

A: Logins via phpPgAdmin with no password or certain usernames (pgsql,
    postgres, root, administrator) are denied by default. Before
changing this
    behaviour (setting $conf['extra_login_security'] to false in the
    config.inc.php file) please read the PostgreSQL documentation about
client
    authentication and understand how to change PostgreSQL's pg_hba.conf
to
    enable passworded local connections.



Best,

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


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

From
Lola Lee
Date:
John DeSoi said the following on 12/15/04 3:09 PM:

>
> This is in the FAQ document in the phpPgAdmin main directory:
>
> Q: For some users I get a "Login disallowed for security" message.
>
> A: Logins via phpPgAdmin with no password or certain usernames (pgsql,
>    postgres, root, administrator) are denied by default. Before changing
> this
>    behaviour (setting $conf['extra_login_security'] to false in the
>    config.inc.php file) please read the PostgreSQL documentation about
> client
>    authentication and understand how to change PostgreSQL's pg_hba.conf to
>    enable passworded local connections.
>

I did read the FAQ, and I did follow the directions.  I was hoping those
who have OS X setups could shed light on configurations that would work
for these particular setups.


--
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.

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

From
John DeSoi
Date:
On Dec 15, 2004, at 3:23 PM, Lola Lee wrote:

> I did read the FAQ, and I did follow the directions.  I was hoping
> those who have OS X setups could shed light on configurations that
> would work for these particular setups.

The only differences I see from my configuration is that I'm using

$conf['servers'][0]['host'] = '';

and I have password security enabled for local connections. If you
really don't want to enter passwords, you can setup a .pgpass file in
your home directory for psql access. And of course the browser will
happily remember your password.

At least you might want to give this setup a try and see if it sheds
any light on the problem with your current setup.

Best,

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL