Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
Hi all,
I am now using getJSON function to get the content from an url, and the code is shown as below:
var params = {
proxyScheme: undefined /* STRING */,
headers: undefined /* JSON */,
ignoreSSLErrors: true /* BOOLEAN */,
useNTLM: undefined /* BOOLEAN */,
workstation: undefined /* STRING */,
useProxy: true /* BOOLEAN */,
withCookies: undefined /* BOOLEAN */,
proxyHost: 'proxy.companyname.com' /* STRING */,
url: "http://gateway-a.watsonplatform.net/visual-recognition/api/v3/classify?api_key=9cf5fa21fe8ff3d9eaa49d0319f329ae5ee7bb89&…" /* STRING */,
timeout: undefined /* NUMBER */,
proxyPort: '8080' /* INTEGER */,
};
// result: JSON
var result = Resources["ContentLoaderFunctions"].GetJSON(params);
I got the error message below:
Wrapped javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Cause: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
But when I change the url to https://feeds.citibikenyc.com/stations/stations.json, can get the content.
Can anyone help solve this problem? Thank!
Solved! Go to Solution.
Hi.
With that kind of error reported the cause is often that the certificate is missing from the Java keystore.
Is this a self-signed certificate? If so, try this procedure out:
Import the self-signed certificates from the external server into the ThingWorx trust store using the following steps:
trustStore is: C:\Program Files\Java\jre1.8.0_141\lib\security\cacerts
Let us know if this is successful or not.
-- Craig A.
The API key needs to be updated, but not influence the result.
Hi Ying Nang Zhang,
Is your problem resolved? I have a similar problem here.
Any response to this? I also am having this problem.
Was this on ThinWorx version 8?
I am seeing similar error, not sure what the core issue is?
Hello,
How did you solved the problem?
I am having the same problem.
Regards,
madhu
I had the same problem (EC2 Amazon Linux server, using TWX 8.1 Docker PostgreSQL), and it was not a self-signed certificate. The following worked for me:
Stop ThingWorx:
$ docker stop twxfoundation
Go to https://www.target_address.com/ and click on lock icon to view SSL certificates
Open Certificate and view Certificate Path - download each certificate in that path (Details -> Copy to File). Use first export option (must be X.509 certificate)
Upload downloaded certificates to your ThingWorx server
Import certificates into Docker keystores into TWX server, use following for reference:
https://adamtuttle.codes/TIL-adding-a-jvm-ssl-cert-docker/
https://stackoverflow.com/questions/21076179/pkix-path-building-failed-and-unable-to-find-valid-certification-path-to-requ/36427118#36427118
Find keystores in your TWX server (in my case Docker keystores, with a path that included "/docker/overla2"):
$ sudo find / -iname 'cacerts'
Import each certificate into each keystore, for example (storepass is "changeit" by default):
$ sudo keytool -importcert -alias myApiCert -keystore "/data/docker/overlay2/blahblah123/diff/opt/jdk1.8.0_92/jre/lib/security/cacerts" -file my_api_cert.cer -noprompt -storepass changeit
Hi,
I got this problem, while installing ThingWorx Navigate when connecting to Windchill,
I have solved it importing the Windchill signing certificate into Java Keystore.
Regards,
madhu
Hi there,
i had the same issue and as rajunall commented, you have to import the windchill certificate into the cacerts.
After doing so I run the tomcat configuration and in Java options you should add the following entry:
-Djavax.net.ssl.trustStore=C:\Program Files\Java\jdk1.8.0_92\jre\lib\security\cacerts
replace the cacerts path according to your installation
Hi.
With that kind of error reported the cause is often that the certificate is missing from the Java keystore.
Is this a self-signed certificate? If so, try this procedure out:
Import the self-signed certificates from the external server into the ThingWorx trust store using the following steps:
trustStore is: C:\Program Files\Java\jre1.8.0_141\lib\security\cacerts
Let us know if this is successful or not.
-- Craig A.
Hi Craig A.,with "java InstallCert externalserver:port",what the "port"should be?Thanks.