Re: pg_hba.conf : bad entry for ADDRESS - Mailing 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

--

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.