Re: pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:27 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:

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

The returned message is fifferent but it doesn't work too. Se below

% psql --host=127.0.0.1/32 --dbname=mattermost
--username=mmuser

psql: could not translate host name "127.0.0.1/32" to address: Name or
service not known
% psql --host=127.0.0.1/24 --dbname=mattermost
--username=mmuser

psql: could not translate host name "127.0.0.1/24" to address: Name or
service not known

--
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>

--

google.com/+arnaudgabourygabx
<https://plus.google.com/_/notifications/emlink?emr=05814804238976922326&emid=CKiv-v6PvboCFcfoQgod6msAAA&path=%2F116159236040461325607%2Fop%2Fu&dt=1383086841306&ub=50>