tableau / TabPy

Execute Python code on the fly and display results in Tableau visualizations:
https://tableau.github.io/TabPy/
MIT License
1.56k stars 598 forks source link

SSL Authentication Issue with Tableau Online #503

Closed DuttSahil closed 2 years ago

DuttSahil commented 3 years ago

Environment information:

Issue when trying to integrate with Tableau online and our own instance of Tabpy, we are trying to accomplish this on our end with authentication and getting the following issue below:

An` error occurred while communicating with the Analytics Extension. {"message":"javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"}}

We have done the following:

Additional note:

scallybrian commented 2 years ago

I am having the exact same issue - would appreciate an update!

dleskosky commented 2 years ago

Hi @DuttSahil and @scallybrian. I believe that the issue is that you ingested the chain cert into the OS for the machine that is hosting TabPy. You need to put the cert into a directory and then specify the absolute path to the cert and key file in your TabPy config file.

Please also note that TabPy requires a full cert chain in the cert file that is located at the path specified in the TABPY_CERTIFICATE_FILE config setting.

Please let me know if this works for you.

nmannheimer commented 2 years ago

@DuttSahil and @scallybrian I'm going to close this issue for now, feel free to re-open if needed.

corngk commented 2 years ago

@dleskosky I am having same issue now. I have followed your instruction with no luck. I can access the tabpy server from my Tableau Desktop. I can also open it from browser without problems. Somehow the Tableau online server have difficulties finding the certificate file.

dleskosky commented 2 years ago

Hi @corngk! By "browser" do you mean Tableau Server or do you mean that you are able to see that TabPy is running when you go to the particular port that it is running on in your browser? Also would you be able to share the exact error message that you are receiving?

corngk commented 2 years ago

Hi @dleskosky thanks for your reply!

I mean I can open the tabpy server (https://tabpyserver.xxx:9004) from a browser and I can see the tabpy page with no problem. I can login from the page successfully. I see no error in the log screen.

The error I got is exactly same with @DuttSahil : An error occurred while communicating with the Analytics Extension. javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

dleskosky commented 2 years ago

Hey @corngk! Try doing what they describe here and see if that helps at all.