Subject: Re: problems logging in through phpPgAdmin
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: John DeSoi <desoi@pgedit.com>
In-Reply-To: 
 <53AA753E5EA4A14784092D825AD4FD3D046D64E2@CTC3650D.campus.ctcd.org>
Date: Mon, 26 Sep 2011 14:58:21 -0400
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	"Hussey, Latasha" <LHussey@ctcd.edu>
Content-Transfer-Encoding: quoted-printable
Message-Id: <11CC03F4-DF27-480E-B447-287100732A6B@pgedit.com>
References: 
 <53AA753E5EA4A14784092D825AD4FD3D046D6234@CTC3650D.campus.ctcd.org>
	<671131D5-CF9A-4B19-8A4F-DC3352213E01@pgedit.com>
	<53AA753E5EA4A14784092D825AD4FD3D046D64E2@CTC3650D.campus.ctcd.org>
To: "Davenport, Julie" <JDavenport@ctcd.edu>


On Sep 26, 2011, at 2:19 PM, Davenport, Julie wrote:

> If I use this combination:
> local   all         all                               trust
> host    all     all     127.0.0.1/32    md5
> or this:
> local   all         all                               md5
> host    all     all     127.0.0.1/32    md5
>=20
> then we cannot login at all -- even if we put in the correct password, =
we get "Login Failed" on the screen, and we just see " FATAL:  password =
authentication failed for user "postgres"" in the log under pg_log.


And you say you tested psql from the command line like this=20

psql -U postgres -h 127.0.0.1=20

and it prompts you for the password and accepts the one you are entering =
with phpPgAdmin?

And PHP is running on the same server as Postgres?

What is the IP address used in your phpPgAdmin configuration? If it is =
not 127.0.0.1, you might need to use the explicit IP address in your =
pg_hba.conf.

Best,


John DeSoi, Ph.D.