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

From Melvin Davidson
Subject Re: pg_hba.conf : bad entry for ADDRESS
Date
Msg-id CANu8Fizyz6QokP+6iRq=uZZ+xLkJJxWOGcaUNAo+9+2ykjeWdQ@mail.gmail.com
Whole thread Raw
In response to pg_hba.conf : bad entry for ADDRESS  (arnaud gaboury <arnaud.gaboury@gmail.com>)
Responses Re: pg_hba.conf : bad entry for ADDRESS  (arnaud gaboury <arnaud.gaboury@gmail.com>)
List pgsql-general


On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury <arnaud.gaboury@gmail.com> wrote:
I am deploying mattermost on my machine following their documentation[0].

My machine network settings:
----------------------------------
$ ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN
group default qlen 1
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host
       valid_lft forever preferred_lft forever
2: host0@if4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue
state UP group default qlen 1000
    link/ether 0e:7f:c3:fb:25:b1 brd ff:ff:ff:ff:ff:ff link-netnsid 0
    inet 192.168.1.94/24 brd 192.168.1.255 scope global host0
       valid_lft forever preferred_lft forever
    inet6 fe80::c7f:c3ff:fefb:25b1/64 scope link
       valid_lft forever preferred_lft forever
--------------------------------------------------------------------

There is a public IP with a domain name (http works OK).

I entered this line in pg_hab.conf:
------------------------------
 host     mattermost         mmuser      127.0.0.1       md5
--------------------------------------------------------

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
------------------------------------

What am I doing wrong?

Thank you for help








[0]https://docs.mattermost.com/install/prod-rhel-7.html
--

google.com/+arnaudgabourygabx


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


You need to change your entry from this
 host     mattermost         mmuser      127.0.0.1       md5

to this
 host     mattermost         mmuser      127.0.0.1/32       md5
or this
 host     mattermost         mmuser      127.0.0.1/24       md5
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: arnaud gaboury
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS
Next
From: Francisco Olarte
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS