BUG #8244: Stack Builder 3.1.0 fails with an http proxy because of an incorrect HTTP Host header value

From: jannevelink(at)anwb(dot)nl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8244: Stack Builder 3.1.0 fails with an http proxy because of an incorrect HTTP Host header value
Date: 2013-06-20 16:47:04
Message-ID: E1Upi0m-00047b-CZ@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8244
Logged by: Jos Annevelink
Email address: jannevelink(at)anwb(dot)nl
PostgreSQL version: 9.2.4
Operating system: Windows 7
Description:

Stack Builder fails to retrieve
http://www.postgresql.org/applications-v2.xml. This used to work in the old
days when we had direct access to the internet. Now we sitting behind
proxies.

My conclusion now is that this error is due to an incorrect HTTP Host header
value.

I experimented a little and changed the proxy to localhost 7777. I also
started a local "nc -l 7777" (nc, i.e "netcat" inside X-Windows on top of
Cygwin). Here is what Stack Builder send and nc received:

GET http://www.postgresql.org/applications-v2.xml HTTP/1.0
Host: localhost
User-Agent: wxWidgets 2.x

The error seems to be the Host header value. It mentions the proxy host
("localhost"), but should mention the targeted HTTP server
("www.postgresql.org").

If all this still works for others, then my situation may be compounded by
all kinds of traffic auditing and filtering "services" in our company proxy
server stopping the (invalid) request from ever getting to
www.postgresql.org.

When I use telnet targeting our proxy server and use GET ... HTTP/1.1 in
combination with "Host: www.postgresql.org", then the request gets thru and
the requested xml file is returned.

I've installed postgresql-9.2.4-1-windows-x64.exe and I'm running its Stack
Builder 3.1.0. All on top the latest Windows 7 Enterprise (64 bit version).

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-06-20 19:28:33 Re: BUG #8242: No way to debug "subquery must return only one column" error
Previous Message tim.kane 2013-06-20 15:08:25 BUG #8243: Order by with column ordinal and collate - fails to parse