Обсуждение: Problem with connection to host (wrong host)

Поиск
Список
Период
Сортировка

Problem with connection to host (wrong host)

От
Mike Martin
Дата:
Hi
I am just setting up a postgres server, details
Host 192.168.0.3
pg_hba.conf
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             192.168.0.0/32            ident
# IPv6 local connections:
host    all             all             127.0.0.1/32            ident

host    all             all             ::1/128                 ident

postgresql.conf
listen_addresses-'*'

however when I try to connect from my laptop (ip 192.168.0.2) I get

psql -h 192.168.0.3 -U usevideo -W
Password for user usevideo:
psql: FATAL:  no pg_hba.conf entry for host "192.168.0.2", user "usevideo", database "usevideo", SSL off

So a bit confused, is psql ignoring the host parameter

thanks


Re: Problem with connection to host (wrong host)

От
Peter Eisentraut
Дата:
On 3/31/18 11:44, Mike Martin wrote:
> Hi
> I am just setting up a postgres server, details
> Host 192.168.0.3
> pg_hba.conf
> # TYPE  DATABASE        USER            ADDRESS                 METHOD
> 
> # "local" is for Unix domain socket connections only
> local   all             all                                     peer
> # IPv4 local connections:
> host    all             all             192.168.0.0/32
> <http://192.168.0.0/32>            ident

This entry should probably be something like

192.168.0.0/24

Writing .0/32 doesn't make much sense.

> # IPv6 local connections:
> host    all             all             127.0.0.1/32
> <http://127.0.0.1/32>            ident
> 
> host    all             all             ::1/128                 ident
> 
> postgresql.conf
> listen_addresses-'*'
> 
> however when I try to connect from my laptop (ip 192.168.0.2) I get
> 
> psql -h 192.168.0.3 -U usevideo -W
> Password for user usevideo:
> psql: FATAL:  no pg_hba.conf entry for host "192.168.0.2", user
> "usevideo", database "usevideo", SSL off
> 
> So a bit confused, is psql ignoring the host parameter

.3 is the host you are connecting to, as seen from the client.

.2 is the host your connection is coming from, as seen from the server.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Problem with connection to host (wrong host)

От
Melvin Davidson
Дата:


On Sat, Mar 31, 2018 at 11:44 AM, Mike Martin <redtux1@gmail.com> wrote:
Hi
I am just setting up a postgres server, details
Host 192.168.0.3
pg_hba.conf
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             192.168.0.0/32            ident
# IPv6 local connections:
host    all             all             127.0.0.1/32            ident

host    all             all             ::1/128                 ident

postgresql.conf
listen_addresses-'*'

however when I try to connect from my laptop (ip 192.168.0.2) I get

psql -h 192.168.0.3 -U usevideo -W
Password for user usevideo:
psql: FATAL:  no pg_hba.conf entry for host "192.168.0.2", user "usevideo", database "usevideo", SSL off

So a bit confused, is psql ignoring the host parameter

thanks


>So a bit confused, is psql ignoring the host parameter

It is not ignoring your entry, you simply have not entry
for the laptop you are connecting from,
So simply add the following:

host    all             all             192.168.0.2/32            ident                <- note, you may have to change the authentication method depending on your environment



--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!