Re: phppgadmin : login failed

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