BUG #8244: Stack Builder 3.1.0 fails with an http proxy because of an incorrect HTTP Host header value - Mailing list pgsql-bugs

From jannevelink@anwb.nl
Subject BUG #8244: Stack Builder 3.1.0 fails with an http proxy because of an incorrect HTTP Host header value
Date
Msg-id E1Upi0m-00047b-CZ@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8244
Logged by:          Jos Annevelink
Email address:      jannevelink@anwb.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).

pgsql-bugs by date:

Previous
From: boraldomaster@gmail.com
Date:
Subject: BUG #8242: No way to debug "subquery must return only one column" error
Next
From: Tom Lane
Date:
Subject: Re: BUG #8242: No way to debug "subquery must return only one column" error