Thread: BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
From
tudorbarascu@yahoo.com
Date:
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
Re: BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
From
Peter Eisentraut
Date:
On 5/21/13 3:41 AM, tudorbarascu@yahoo.com wrote: > 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. 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.
Re: BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
From
Tudor Barascu
Date:
Hi and thank you for replying.=0A=0AI have tried using the FQDN without suc= cess.=0A=0AThe reverse DNS server was already setup.=0AAfter installing=A0= =A0bridge-utils in order to run the host command and I discovered the rever= se dns had config problems=0A(something you suggested)=0A=0A$host laptop=0A= =0Alaptop.biroul.gis has address 192.168.111.6=0A=0A$host 192.168.111.6=0AH= ost 6.111.168.192.in-addr.arpa. not found: 3(NXDOMAIN)=0A=0AI have fixed th= e reverse DNS configuration and now all is alright.=0A=0AThank you,=0ATudor= =A0=0A=0A=0A________________________________=0A From: Peter Eisentraut <pet= er_e@gmx.net>=0ASent: Tuesday, May 28, 2013 4:03 PM=0ASubject: Re: [BUGS] B= UG #8172: entering the hostname in the address column in pg_hba.conf doesn'= t work as it should=0A =0A=0AOn 5/21/13 3:41 AM, tudorbarascu@yahoo.com wro= te:=0A> In pg_hba.conf I have the following setup:=0A> host=A0 =A0 all=A0 = =A0 all=A0 =A0 laptop=A0 =A0 =A0 =A0 =A0 md5=0A> =0A> Although the hostna= me gets resolved by the system (LAN DNS server) I still=0A> get the no pg_h= ba.conf entry error.=0A=0ACheck that the following works:=0A=0A$ host lapto= p=0A$ host x.x.x.x=0A=0Awhere x.x.x.x is the IP address that the first comm= and printed.=A0 Those=0Aneed to match.=0A=0AI suspect that you need to writ= e a fully-qualified domain name in=0Apg_hba.conf, and you need to set up th= e reverse DNS.