Re: remote connections to Windows based server

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Paul Forgey <paulf(at)aphrodite(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: remote connections to Windows based server
Date: 2006-11-17 22:58:39
Message-ID: Pine.LNX.4.64.0611171456110.23695@discord.home.frostconsultingllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 17 Nov 2006, Tom Lane wrote:

> Jeff Frost <jeff(at)frostconsultingllc(dot)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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-11-17 23:26:16 Re: remote connections to Windows based server
Previous Message Tom Lane 2006-11-17 22:54:56 Re: remote connections to Windows based server