Re: remote connections to Windows based server - Mailing list pgsql-admin

From Jeff Frost
Subject Re: remote connections to Windows based server
Date
Msg-id Pine.LNX.4.64.0611171456110.23695@discord.home.frostconsultingllc.com
Whole thread Raw
In response to Re: remote connections to Windows based server  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: remote connections to Windows based server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Fri, 17 Nov 2006, Tom Lane wrote:

> Jeff Frost <jeff@frostconsultingllc.com> writes:
>> I believe you must list all 4 octets of the subnet.
>
> Oh, duh.  The comments in inet_aton() show that it is interpreting
> "10.6" in what most people nowadays would find a surprising way:
>
>         case 1:            /* a -- 32 bits */
>         case 2:            /* a.b -- 8.24 bits */
>         case 3:            /* a.b.c -- 8.8.16 bits */
>         case 4:            /* a.b.c.d -- 8.8.8.8 bits */
>
> ie, it is read as if it were "10.0.0.6" ... hence no match, but also no
> syntax error.

Wow, I sure would've never guessed that.
I confirmed the behavior on my windows test server here.

Paul, just add the 0s and you'll be golden.

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: remote connections to Windows based server
Next
From: Tom Lane
Date:
Subject: Re: remote connections to Windows based server