BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
The following bug has been logged on the website:
Bug reference: 8172
Logged by: Barascu Tudor
Email address: tudorbarascu@yahoo.com
PostgreSQL version: 9.2.4
Operating system: Centos 6.4 kernel 2.6.32-358.6.2.el6.x86_64
Description:
In pg_hba.conf I have the following setup:
host all all laptop md5
Although the hostname gets resolved by the system (LAN DNS server) I still
get the no pg_hba.conf entry error.
If I enter the hostname and ip in the hosts file all works well.
I get the following error: (it seems the host name gets resolved but after
the deny)
2013-05-21 10:26:12 EEST:192.168.1.6(51513):sde@gisdb:[1997]: FATAL: 28000:
no pg_hba.conf entry for host "192.168.1.6", user "sde", database "gisdb",
SSL off
2013-05-21 10:26:12 EEST:192.168.1.6(51513):sde@gisdb:[1997]: DETAIL:
Client IP address resolved to "192.168.1.6", forward lookup not checked.
2013-05-21 10:26:12 EEST:192.168.1.6(51513):sde@gisdb:[1997]: LOCATION:
ClientAuthentication, auth.c:479
Thank you,
Tudor
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On 5/21/13 3:41 AM, tudorbarascu@yahoo.com wrote:
In pg_hba.conf I have the following setup:
host all all laptop md5Although the hostname gets resolved by the system (LAN DNS server) I still
get the no pg_hba.conf entry error.
Check that the following works:
$ host laptop
$ host x.x.x.x
where x.x.x.x is the IP address that the first command printed. Those
need to match.
I suspect that you need to write a fully-qualified domain name in
pg_hba.conf, and you need to set up the reverse DNS.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi and thank you for replying.
I have tried using the FQDN without success.
The reverse DNS server was already setup.
After installing bridge-utils in order to run the host command and I discovered the reverse dns had config problems
(something you suggested)
$host laptop
laptop.biroul.gis has address 192.168.111.6
$host 192.168.111.6
Host 6.111.168.192.in-addr.arpa. not found: 3(NXDOMAIN)
I have fixed the reverse DNS configuration and now all is alright.
Thank you,
Tudor
________________________________
From: Peter Eisentraut <peter_e@gmx.net>
Sent: Tuesday, May 28, 2013 4:03 PM
Subject: Re: [BUGS] BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
On 5/21/13 3:41 AM, tudorbarascu@yahoo.com wrote:
In pg_hba.conf I have the following setup:
host all all laptop md5Although the hostname gets resolved by the system (LAN DNS server) I still
get the no pg_hba.conf entry error.
Check that the following works:
$ host laptop
$ host x.x.x.x
where x.x.x.x is the IP address that the first command printed. Those
need to match.
I suspect that you need to write a fully-qualified domain name in
pg_hba.conf, and you need to set up the reverse DNS.