Re: pg_hba.conf : bad entry for ADDRESS - Mailing list pgsql-general

From arnaud gaboury
Subject Re: pg_hba.conf : bad entry for ADDRESS
Date
Msg-id CAK1hC9v3=g=ZF5FG9=36hqKNyRWnZOSfhm97VY_Vnde-sOnbyg@mail.gmail.com
Whole thread Raw
In response to Re: pg_hba.conf : bad entry for ADDRESS  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_hba.conf : bad entry for ADDRESS  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> On 08/25/2016 07:18 AM, arnaud gaboury wrote:
>>
>> I am deploying mattermost on my machine following their documentation[0].
>
>
>> There is a public IP with a domain name (http works OK).
>>
>> I entered this line in pg_hab.conf:
>
>
> I assume you mean pg_hba.conf
>
>> ------------------------------
>>  host     mattermost         mmuser      127.0.0.1       md5
>> --------------------------------------------------------
>>
>
> Make sure that is the *only* line referencing 127.0.0.1.
>
>
>> Now when testing:
>> --------------------------------------
>> % psql --host=127.0.0.1 --dbname=mattermost --username=mmuser --password
>> Password for user mmuser:
>> psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user
>> "mmuser", database "mattermost", SSL off
>> ------------------------------------
>
>
> Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the
> pg_hba.conf.
>
> FTR: I have deployed Mattermost and it works wonderfully.

The issue is solved (see my replies). By any chance, did you deploy on
Fedora? There is no official package and I must build my own .rpm.


>
> JD
>
>
>
> --
> Command Prompt, Inc.                  http://the.postgres.company/
>                         +1-503-667-4564
> PostgreSQL Centered full stack support, consulting and development.
> Everyone appreciates your honesty, until you are honest with them.



--

google.com/+arnaudgabourygabx


pgsql-general by date:

Previous
From: arnaud gaboury
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS