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

phppgadmin config - access denied



I'm running Postgres without any problems.  I'm able to connect to
various DB's, etc.

Recently I apt-get installed phppgadmin but have had a difficult time
signing in through phppgadmin at

http://localhost/phppgadmin/index.php

I've read the phppgadmin docs carefully and have done everything
necessary, but I'm still getting "access denied" when trying to sign in.
It always says I'm using the wrong username/password, although I know
that I am using the correct ones.

In /etc/phppgadmin/config.inc.php I have:

$cfgServers[1]['local']         = true;
$cfgServers[1]['host']          = 'localhost';
$cfgServers[1]['port']          = '5432';
$cfgServers[1]['adv_auth']      = true;

$cfgServers[1]['user']          = '';   // if you are not using
   adv_auth, enter the username to connect all the time
$cfgServers[1]['password']      = '';   // if you are not using adv_auth
   and a password is required enter a password
$cfgServers[1]['only_db']       = '';   // if set to a db-name, only
   this db is accessible

In /etc/postgresql/pg_hba.conf I have:

local        all                                   password
host         all         127.0.0.1     255.0.0.0   ident sameuser
host         all         0.0.0.0       0.0.0.0     reject

In /etc/postgresql/postgresql.conf I have:

tcpip_socket = 1

All of this is straight per the docs for phppgadmin.  But obviously I'm
missing something.

Thanks in advance for any clues or hints.

Kevin

-- 
Kevin Coyner
mailto: kevin@rustybear.com
GnuPG key: 1024D/8CE11941

Attachment: pgpIDvFhaGC62.pgp
Description: PGP signature


Reply to: