From: John DeSoi <desoi@pgedit.com>
To: Davenport, Julie <JDavenport@ctcd.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: Hussey, Latasha <LHussey@ctcd.edu>
Subject: Re: problems logging in through phpPgAdmin
Date: Mon, 26 Sep 2011 14:58:21 -0400
Message-ID: <11CC03F4-DF27-480E-B447-287100732A6B@pgedit.com> (raw)
In-Reply-To: <53AA753E5EA4A14784092D825AD4FD3D046D64E2@CTC3650D.campus.ctcd.org>
References: <53AA753E5EA4A14784092D825AD4FD3D046D6234@CTC3650D.campus.ctcd.org>
<671131D5-CF9A-4B19-8A4F-DC3352213E01@pgedit.com>
<53AA753E5EA4A14784092D825AD4FD3D046D64E2@CTC3650D.campus.ctcd.org>
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
>
> 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
psql -U postgres -h 127.0.0.1
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: desoi@pgedit.com, JDavenport@ctcd.edu, LHussey@ctcd.edu
Subject: Re: problems logging in through phpPgAdmin
In-Reply-To: <11CC03F4-DF27-480E-B447-287100732A6B@pgedit.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox