Re: phppgadmin : login failed

Поиск
Список
Период
Сортировка
От arnaud gaboury
Тема Re: phppgadmin : login failed
Дата
Msg-id CAK1hC9t2UWYEGwfyNr71atqcGRV55YDZ+uvtUirVFKtd2D1r7A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: phppgadmin : login failed  (Ian Barwick <ian@2ndquadrant.com>)
Список pgsql-general
On Thu, May 28, 2015 at 11:04 AM, Ian Barwick <ian@2ndquadrant.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


В списке pgsql-general по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: phppgadmin : login failed
Следующее
От: Chris Mair
Дата:
Сообщение: Re: 9.4.2 -> 9.4.3