Re: HTTPGETCLOB woes -- MIDRANGE-L

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