Re: HTTPGETCLOB woes -resolved -- MIDRANGE-L

No that wasn't it.
Of course, I needed to pass the Authorization header in a <httpHeader> element via the 2nd parameter.
Duuhh!

Cheers, Peter

-----Original Message-----
From: Peter Connell
Sent: Thursday, 2 March 2017 7:46 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: [IE] Re: HTTPGETCLOB woes

I suspect you're correct Jack.
It's failing on the internal url, which I tested first, but a further test succeeds with an 3rd party url that I know we accessed via the proxy.
Maybe the proxy is not configured to allow the internal url.

Cheers, Peter

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Kingsley
Sent: Wednesday, 1 March 2017 11:36 PM
To: Midrange Systems Technical Discussion
Subject: [IE] Re: HTTPGETCLOB woes

Take a stab at it, sounds like the issue might be in the squid server. I had never heard of a squid server so I googled the error showing in your post.

X-Squid-Error" value="ERR_ACCESS_DENIED 0

Get various hits on this, here is one of them.

Looks like you need to look in the squid logs etc.

https://sourceforge.net/p/proxytunnel/mailman/message/27874832/

On Wed, Mar 1, 2017 at 3:43 AM, Peter Connell <Peter.Connell@xxxxxxxxxxx>
wrote:

This works with an HTTP request to the server (which listens on port
86) SELECT cast(RESPO00001 as varchar(1000)),
cast(RESPO00002 as varchar(1000))
FROM TABLE(SYSTOOLS.HTTPGETCLOBVERBOSE
('http://baycorp1:86/www/wow.htm','') ) AS HTTPDATA

But not with an HTTPS (same server also listens on 443) for the same page.
SELECT cast(RESPO00001 as varchar(1000)),
cast(RESPO00002 as varchar(1000))
FROM TABLE(SYSTOOLS.HTTPGETCLOBVERBOSE
('https://baycorp1/www/wow.htm','') ) AS HTTPDATA

RESPO00002 returns the HTTP response header as <?xml version="1.0"
encoding="UTF-8" ?> <httpHeader responseCode="403">
<responseMessage>Forbidden</responseMessage>
<header name="HTT P_RESPONSE_CODE" value="HTTP/1.1 403 Forbidden"/>
<header name="Server" value="squid/3.5.20"/> <header
name="Content-Language" value= "en"/> <header name="X-Cache"
value="MISS from npprlxpx001.corp.dmz"/> <header name="Via" value="1.1
npprlxpx001.corp.dmz (squid/3.5. 20)"/> <header name="Content-Type"
value="text/html;charset=utf-8"/> <header name="Date" value="Wed, 01
Mar 2017 08:32:20 GMT"/> <head er name="Vary"
value="Accept-Language"/> <header name="X-Squid-Error"
value="ERR_ACCESS_DENIED 0"/> <header name="X-Cache-Lookup" val
ue="NONE from npprlxpx001.corp.dmz:3128"/> <header
name="Content-Length" value="3612 header name="Connection"
value="keep-alive"/ header name="Mime-Version" value="1.0"/>
</httpHeader>

The HTTPS request goes via a squid proxy server.
I have my SystemDefault.properties set as

java.version=1.7.0
os400.secureApplication=QIBM_HTTP_SERVER_SERVICES
javax.net.ssl.trustStore=/QOpenSys/QIBM/ProdData/JavaVM/
jdk60/32bit/jre/lib/security/cacerts_copy
javax.net.ssl.trustStorePassword=topsecret
https.proxyHost=10.9.31.37
https.proxyPort=3128

Anyone hazard a guess at the problem?
Can't find much that helps regarding proxies and
SYSTOOLS.HTTPGETVERBOSE when I google it.

Regards, Peter

############################################################## This
correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy
or rely on any part of this correspondence if you are not the intended
recipient. Any views expressed in this message are those of the
individual sender, except where the sender expressly, and with
authority, states them to be the views of Veda. If you need
assistance, please contact Veda :- Australia http://www.veda.com.au/
contact-us New Zealand http://www.veda.co.nz/contact-veda
##############################################################
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
############################################################## This correspondence is for the named person's use only. It may contain confidential or legally privileged information, or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Veda. If you need assistance, please contact Veda :- Australia http://www.veda.com.au/contact-us New Zealand http://www.veda.co.nz/contact-veda ##############################################################