tableau / TabPy

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

Tableau Prep Builder cannot connect to tabpy server with https #502

Closed Rahovski closed 3 years ago

Rahovski commented 3 years ago

Describe the issue When i used in Tableau prep builder https connection to tabpy server, then requests fail. With http tabpy server worked correct (address:port) But when i use https connection ( https://address:port), then i don't see any requests in debug's log. изображение But if i open this address in browser, i see, that server is working correct изображение

To Reproduce

  1. Create x509 certificate in pem code(default) openssl genrsa -aes256 -out prk.key 2048 openssl req -new -key prk.key -out tabpy_cert_req.csr openssl x509 -req -in tabpy_cert_req.csr -signkey prk.key -out tabpy_cert_req.crt sudo cp tabpy_cert_req.crt /usr/local/share/ca-certificates/ sudo update-ca-certificates
  2. Change tabpy config file
    [TabPy]
    TABPY_PORT = 49140
    TABPY_TRANSFER_PROTOCOL = https
    TABPY_CERTIFICATE_FILE = /home/tableauBeta2020/tabpy_dir/tabpy_sec/tabpy_cert_req.crt
    TABPY_KEY_FILE = /home/tableauBeta2020/tabpy_dir/tabpy_sec/prk.key
    TABPY_LOG_DETAILS = true
    TABPY_EVALUATE_TIMEOUT = 90
  3. Start tabpy in venv tabpy --config=/home/tableauBeta2020/tabpy_dir/conf_tab_py.conf Start_log: log_debug_after_Start_server.txt
  4. Downloaded certificate to desktop изображение
  5. Make connection with https изображение

Expected behavior It was expected that after opening the page with https request, it will be possible to create a connection tableau prep builder with tabpy.

Rahovski commented 3 years ago

Finded a solution. Need was write correct Common Name (e.g. server FQDN or YOUR name), when i was signing a certificate. Common Name (e.g. server FQDN or YOUR name) [] : ip-address