search

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

TabPy failed to work on server #318

Closed odiwan1991 closed 5 years ago

odiwan1991 commented 5 years ago

Environment information:

Describe the issue All certificates are declared and valid. Tableau Server uses the same certificates.

Current Tableau Server config: vizqlserver.extsvc.host http://127.0.0.1 vizqlserver.extsvc.port 9004 vizqlserver.allow_insecure_scripts true vizqlserver.script.disabled true

Expected behavior On local machine everything is working fine. I think that issue is related to SSL.

Screenshots Screenshot_1

Screenshot_2

Thank you a lot for you attention!

nmannheimer commented 5 years ago

Hey @odiwan1991,

One thing to try right away, the vizqlserver.script.disabled parameter is a little confusing, but the actual setting to allow external connection is false :

https://onlinehelp.tableau.com/current/server-linux/en-us/cli_security_tsm.htm#vizql-extsvc-ssl-list

"Disable scripts originating from the external service from running on Tableau Server. Default is true. To allow scripts from the external service to run on Tableau Server, set to false."

odiwan1991 commented 5 years ago

hi @nmannheimer Thanks for prompt response. I've changed settings accordingly however got the same error.

nmannheimer commented 5 years ago

Are you seeing pings from Tableau Server in the CLI where you're running TabPy? ie failed connection attempts? From your config, it looks like you put the endpoint as http, but if you've configured SSL certs you'll want to make that https://127.0.0.1

edit - from your image it looks like you are, try changing the endpoint to https

odiwan1991 commented 5 years ago

@nmannheimer sounds reasonable, I didn't note it. Can you please clarify how to make this changes?

nmannheimer commented 5 years ago

just set vizqlserver.extsvc.host to https://127.0.0.1

nmannheimer commented 5 years ago

@odiwan1991 can you also let me know which version of Server you are using?

odiwan1991 commented 5 years ago

Hi! Server version is Tableau Server Version: 2019.1.2.

odiwan1991 commented 5 years ago

@nmannheimer i've changed vizqlserver.extsvc.host to https://127.0.0.1 and got the following error Screenshot_1

nmannheimer commented 5 years ago

Are you seeing anything on the TabPy command line when you are trying to connect?

odiwan1991 commented 5 years ago

No

odiwan1991 commented 5 years ago

BTW i've upgraded TapPy to latest version

nmannheimer commented 5 years ago

My apologies, I missed this when you shared your Server version. Secure connection for TabPy was added in Tableau Server version 2019.2. Secure Connection for RServe was added in 2019.1, which is why the capability exists to set those parameters in your 2019.1 version of Tableau Server. To communicate securely with TabPy, you will need to upgrade your Tableau Server to 2019.2.

odiwan1991 commented 5 years ago

Thank you! I'll try it and get back with results ASAP

0golovatyi commented 5 years ago

@odiwan1991 Are you still experiencing the issue or it has been resolved?

DimaVS1991 commented 5 years ago

Hi @0golovatyi and @nmannheimer. Sorry for keeping you with no feedback for so long. I was on holidays.

Unfortunately I am experiencing this issue. I have upgraded Tableau Server to 2019.2.2. vizqlserver.allow_insecure_scripts is set to true vizqlserver.script.disabled is set tot true

All certificates are declared in default.conf file

However i got this reposnse from TabPy server: [WARNING] (iostream.py:iostream:1518): SSL Error on 816 ('127.0.0.1', 63148): [SSL: HTTP_REQUEST] http request (_ssl.c:833)

And this from Tableau Server: image

Can you please help me to figure this out?

jnegara commented 5 years ago

@DimaVS1991 It looks like you've configured a plaintext connection in Tableau. Make sure you've checked "require SSL", provided a certificate, and that your host name begins with "https://".