[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Re: [BUGS] BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it
From: Tudor Barascu <tudorbarascu () yahoo ! com>
Date: 2013-05-29 8:37:19
Message-ID: 1369816639.184.YahooMailNeo () web120906 ! mail ! ne1 ! yahoo ! com
[Download RAW message or body]
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 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.
[Attachment #3 (text/html)]
<html><body><div style="color:#000; background-color:#fff; font-family:times new \
roman, new york, times, serif;font-size:12pt"><div id="yiv1931553888"><div><div \
style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times \
new roman', 'new york', times, serif; font-size: 12pt;"><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55" style="font-family: 'times new \
roman', 'new york', times, serif; font-size: 12pt;">Hi and thank you for \
replying.</div><div id="yiv1931553888yui_3_7_2_32_1369752645284_55" \
style="font-family:'times new roman', 'new york', times, serif;font-size:12pt;" \
class="yui_3_7_2_30_1369816275730_55"><br></div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55" style="font-family: 'times new \
roman', 'new york', times, serif; font-size: 12pt;">I have tried using the FQDN \
without success.<br></div><div id="yiv1931553888yui_3_7_2_32_1369752645284_55" \
style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; \
color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">The reverse \
DNS server was already setup.</div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55" style="font-family:'times new roman', \
'new york', times, serif;font-size:16px;color:rgb(0, 0, \
0);background-color:transparent;font-style:normal;" \
class="yui_3_7_2_30_1369816275730_57">After installing <span style="font-size: \
12pt;"> bridge-utils in order to run the host command and I discovered the \
reverse dns had config problems</span></div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55" style="font-family:'times new roman', \
'new york', times, serif;font-size:16px;color:rgb(0, 0, \
0);background-color:transparent;font-style:normal;" \
class="yui_3_7_2_30_1369816275730_57"><span style="font-size: 12pt;">(something you \
suggested)</span></div><div id="yiv1931553888yui_3_7_2_32_1369752645284_55" \
style="font-family:'times new roman', 'new york', times, \
serif;font-size:16px;color:rgb(0, 0, \
0);background-color:transparent;font-style:normal;" \
class="yui_3_7_2_30_1369816275730_57"><span style="background-color: transparent; \
font-size: 16px;"><br></span></div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55" style="font-family:'times new roman', \
'new york', times, serif;font-size:16px;color:rgb(0, 0, \
0);background-color:transparent;font-style:normal;" \
class="yui_3_7_2_30_1369816275730_57"><span style="background-color: transparent; \
font-size: 16px;">$host laptop</span><br></div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_75" style="font-family: 'times new \
roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); \
background-color: transparent; font-style: normal;"><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55" style="background-color: \
transparent;">laptop.biroul.gis has address 192.168.111.6<br \
id="yiv1931553888yui_3_7_2_32_1369752645284_94"></div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55">$host 192.168.111.6</div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_55">Host 6.111.168.192.in-addr.arpa. not \
found: 3(NXDOMAIN)</div><div><br></div><div>I have fixed the reverse DNS \
configuration and now all is alright.</div><div><br></div><div>Thank \
you,</div><div>Tudor </div></div><div \
id="yiv1931553888yui_3_7_2_32_1369752645284_75" style="font-family: 'times new \
roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); \
background-color: transparent; font-style: normal;"><br></div> <div \
style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;" \
id="yiv1931553888yui_3_7_2_32_1369752645284_60" \
class="yiv1931553888yui_3_7_2_32_1369752645284_59"> <div style="font-family: 'times \
new roman', 'new york', times, serif; font-size: 12pt;" \
class="yiv1931553888yui_3_7_2_32_1369752645284_63"> <div dir="ltr" \
id="yiv1931553888yui_3_7_2_32_1369752645284_97"> <hr size="1"> <font size="2" \
face="Arial" id="yiv1931553888yui_3_7_2_32_1369752645284_99"> <b><span \
style="font-weight:bold;">From:</span></b> Peter Eisentraut \
<peter_e@gmx.net><br> <b><span style="font-weight:bold;">Sent:</span></b> \
Tuesday, May 28, 2013 4:03 PM<br> <b><span \
style="font-weight:bold;">Subject:</span></b> Re: [BUGS] BUG #8172: entering the \
hostname in the address column in pg_hba.conf doesn't work as it should<br> </font> \
</div> <div class="yiv1931553888y_msg_container" \
id="yiv1931553888yui_3_7_2_32_1369752645284_74"><br>On 5/21/13 3:41 AM, <a \
rel="nofollow" ymailto="mailto:tudorbarascu@yahoo.com" target="_blank" \
href="mailto:tudorbarascu@yahoo.com">tudorbarascu@yahoo.com</a> wrote:<br>> In \
pg_hba.conf I have the following setup:<br>> host all \
all laptop md5<br>> <br>> \
Although the hostname gets resolved by the system (LAN DNS server) I still<br>> \
get the no pg_hba.conf entry error.<br><br>Check that the following works:<br><br>$ \
host laptop<br>$ host x.x.x.x<br><br>where x.x.x.x is the IP address that the first \
command printed. Those<br>need to match.<br><br>I suspect that you need to \
write a fully-qualified domain name in<br>pg_hba.conf, and you need to set up the \
reverse DNS.<br><br><br><br><br></div> </div> </div> \
</div></div></div></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic