Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 4E137B5DC3C
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Aug 2011 09:37:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 57927-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Aug 2011 12:37:09 +0000 (UTC)
X-Greylist: delayed 01:56:45.125753 by SQLgrey-1.7.6
Received: from relay3-d.mail.gandi.net (relay3-d.mail.gandi.net
	[217.70.183.195])
	by mail.postgresql.org (Postfix) with ESMTP id D5220B5DBCE
	for <pgsql-admin@postgresql.org>; Thu, 18 Aug 2011 09:37:08 -0300 (ADT)
X-Originating-IP: 217.70.178.134
Received: from mfilter4-d.gandi.net (mfilter4-d.gandi.net [217.70.178.134])
	by relay3-d.mail.gandi.net (Postfix) with ESMTP id A4E51A807D;
	Thu, 18 Aug 2011 14:37:07 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at mfilter4-d.gandi.net
Received: from relay3-d.mail.gandi.net ([217.70.183.195])
	by mfilter4-d.gandi.net (mfilter4-d.gandi.net [10.0.15.180])
	(amavisd-new, port 10024)
	with ESMTP id uOi9R6nWJmhn; Thu, 18 Aug 2011 14:37:06 +0200 (CEST)
X-Originating-IP: 88.164.23.161
Received: from [192.168.0.11] (fb.ioguix.net [88.164.23.161])
	(Authenticated sender: jg@derorthais.net)
	by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id C434DA8081;
	Thu, 18 Aug 2011 14:37:05 +0200 (CEST)
Message-ID: <4E4D0771.20001@free.fr>
Date: Thu, 18 Aug 2011 14:37:05 +0200
From: "Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.18) Gecko/20110626 Icedove/3.1.11
MIME-Version: 1.0
To: Tom Browder <tom.browder@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Unable to login with phppgadmin on a remote host
References: 
 <CAFMGiz9DWRU4uYNTT3-y6GLYmPZ+DfATWhtEycfWX6aat6HZ9g@mail.gmail.com>
	<4E4CEC10.4060905@free.fr>
	<CAFMGiz_cp8_0118PkqRiDSpv96zcBMVsmJKhOR8Bey08GQRFgg@mail.gmail.com>
In-Reply-To: 
 <CAFMGiz_cp8_0118PkqRiDSpv96zcBMVsmJKhOR8Bey08GQRFgg@mail.gmail.com>
X-Enigmail-Version: 1.1.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201108/166
X-Sequence-Number: 38153

On 18/08/2011 13:54, Tom Browder wrote:
> On Thu, Aug 18, 2011 at 05:40,  (ioguix) de Rorthais <ioguix@free.fr> wrote:
>> Hello,
>> On 18/08/2011 01:20, Tom Browder wrote:
> ...
>>> I have these lines in my pg_hba.conf file:
>>>
>>> host  all             myuser         <a remote host IP>/32         md5
>>> host  all             postgres       <a remote host IP>/32         md5
>>>
>>> However, I cannot successfully login with phppgadmin on the remote host.
>>>
>>> I always get "login failed" whether I use myuser or postgres.
>>
>> Do you have errors in your postgresql log files about this connections
>> attempts ?
> 
> No, only some sql errors from an early user creation.

You should have some FATAL or ERROR entries about your attempts to
connect. That means phpPgAdmin doesn't even reach PostgreSQL.

>>> I have made these changes in /etc/phppgadmin files:
>>>
>>>   apache.conf:
>>>
>>>  config.inc.php:
>>>        $conf['servers'][0]['desc'] = 'mars-postgresql';
>>>        $conf['servers'][0]['host'] = 'local host ip address...';
>>>        //$conf['extra_login_security'] = true;
>>>        $conf['extra_login_security'] = false;
>>
>> What do you mean by 'local host ip address...' ? 127.0.0.1 ?
> 
> No, I had put in the actual server IP address but have changed and
> tried '', and 'localhost'--none have worked.
> 
>> Please, show us your full pg_hba.conf (without comments and public IP
>> address).
> 
> My pg_hba.conf:
> 
> local  all            all                                     md5
> host  all             all             127.0.0.1/32            md5
> host  all             all             ::1/128                 md5
> host  all             admin        xx.xxx.xxx.xx/32         md5
> host  all             postgres       xx.xxx.xxx.xx/32         md5

sounds good.
That means that you did set a password to user postgres ? did you try to
login with the following commands using your own system user (not postgres):

  psql postgres postgres
  psql -h 127.0.0.1 postgres myuser

first one use unix socket, second one inet.

>>> I have asked this of the phppgadmin group but I think it may be my
>>> postgresql setup.
> 
>> Looks like I missed it...where ?
> 
> Oops, I never sent the message, sorry, my mistake.
> 
> Thanks, Jehan-Guillaume.
> 
> -Tom