Re: pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)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(at)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(at)postgresql(dot)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.