Re: phppgadmin : login failed

On Thu, May 28, 2015 at 11:04 AM, Ian Barwick <ian(at)2ndquadrant(dot)com> wrote:
> On 15/05/28 17:55, arnaud gaboury wrote:
> (...)
>> I can't log from the phppgadmin. I have login failed.
>> First, I am not sure if I shall log with my unix account or postgres
>> role (I guess the latter one).
>>
>> Log:
>> LOG: database system is ready to accept connections
>> LOG: connection received: host=[local]
>> LOG: connection received: host=::1 port=39999
>> FATAL: no pg_hba.conf entry for host "::1", user "mediawiki",
>> database "postgres", SSL off
>>
>> I see there is a problem in my pg_hba.conf, but can't see how to set
>> up it correctly.
>
>> pg_hba.conf
>> ----------------------
>> # TYPE DATABASE USER ADDRESS METHOD
>>
>> # "local" is for Unix domain socket connections only
>> local all all md5
>> # IPv4 local connections:
>> host all all 127.0.0.1/32 md5
>> # IPv6 local connections:
>> --------------------------------------
>
> Looks like you're missing an entry for IPv6 in pg_hba.conf; something
> like this:
>
> host all all ::1/128 md5

YES. I just uncommented the line a few mn ago and now it is OK.

TY
>
>
> Regards
>
> Ian Barwick
>
> --
> Ian Barwick http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

--

google.com/+arnaudgabourygabx