From: | Ian Barwick <ian(at)2ndquadrant(dot)com> |
---|---|
To: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: phppgadmin : login failed |
Date: | 2015-05-28 09:04:10 |
Message-ID: | 5566DA0A.9030709@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | arnaud gaboury | 2015-05-28 09:05:33 | Re: phppgadmin : login failed |
Previous Message | arnaud gaboury | 2015-05-28 08:55:49 | phppgadmin : login failed |