Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tabpy server awaits for the user to hit Enter on the tabpy server Console for the Tableau connection to establish/finish #619

Closed
Nishantha2006 opened this issue Sep 27, 2023 · 1 comment
Labels

Comments

@Nishantha2006
Copy link

Nishantha2006 commented Sep 27, 2023

Environment information:

  • OS: Windows Server 2019
  • Python version: 3.7.6
  • TabPy release: Tabpy 2.9.0
    Describe the issue
    I've installed tabpy 2.9.0 on a python 3.7.6 python environment on a Windows Server 2019 server. Created a new conf file on a copy of default.conf with below updates:

TABPY_PWD_FILE = C:/Program Files/Microsoft/PyForMLS/Lib/site-packages/tabpy/tabpy_server/common/Password/users.txt

TABPY_LOG_DETAILS = true

Added a new user into the users.txt file.

Started the tabpy server from powershell console using below command:

tabpy --config "C:\Program Files\Microsoft\PyForMLS\Lib\site-packages\tabpy\tabpy_server\common\tabpy-server.conf"
PS C:\WINDOWS\system32> tabpy --config "C:\Program Files\Microsoft\PyForMLS\Lib\site-packages\tabpy\tabpy_server\common\tabpy-server.conf"
2023-09-26,13:20:05 [INFO] (app.py:app:300): Parsing config file C:\Program Files\Microsoft\PyForMLS\Lib\site-packages\tabpy\tabpy_server\common\tabpy-server.conf
2023-09-26,13:20:05 [INFO] (app.py:app:363): Setting max request size to 104857600 bytes
2023-09-26,13:20:05 [INFO] (app.py:app:527): Loading state from state file c:\program files\microsoft\pyformls\lib\site-packages\tabpy\tabpy_server\state.ini
2023-09-26,13:20:05 [INFO] (util.py:util:51): Parsing passwords file C:/Program Files/Microsoft/PyForMLS/Lib/site-packages/tabpy/tabpy_server/common/Password/users.txt...
2023-09-26,13:20:05 [INFO] (util.py:util:87): Authentication is enabled
2023-09-26,13:20:05 [INFO] (app.py:app:411): Call context logging is enabled
2023-09-26,13:20:05 [INFO] (app.py:app:181): Initializing TabPy...
2023-09-26,13:20:05 [INFO] (callbacks.py:callbacks:43): Initializing TabPy Server...
2023-09-26,13:20:05 [INFO] (app.py:app:185): Done initializing TabPy.
2023-09-26,13:20:05 [INFO] (callbacks.py:callbacks:64): Initializing models...
2023-09-26,13:20:05 [INFO] (app.py:app:152): Web service listening on port 9004

Using Tableau Desktop Pro2022.3 running on a Windows 10 workstation, I then connect to this Tabpy server by providing Server name, port, username and password. The connection is hanging, until I hit Enter on the above console at which point on Tableau desktop side, it shows a successful connection been established, and on the PS console it shows below details confirming this connection.
2023-09-27,10:06:23 [INFO] (base_handler.py:base_handler:85): Call ID: 8456a5b4-ceb1-4b5c-a4d0-75a932fa279e, Caller: sanitised ip, Method: GET, URL: http://sanitised server name:9004/info, Client: Tableau Desktop Pro2022.3
2023-09-27,10:10:45 [INFO] (web.py:web:2246): 200 GET /info (10.71.6.38) 261328.03ms

The tabpy server is running under my userid.

Is there a way to automate this connection acceptance please, without a user having to hit Enter?

To Reproduce
Steps to reproduce the behavior: what commands to run, what files to modify, where to look for an error.
Covered in above description already.

Expected behavior
A clear and concise description of what you expected to happen.
The connection from Tableau desktop to work without having a user to hit Enter on the tabpy server console.

Screenshots
If applicable, add screenshots to help explain your problem.
Logs seen on the tablpy server console is added to the description area already.

Additional context
Add any other context about the problem here.

@Nishantha2006
Copy link
Author

The issue had been with the conf file having forward slashes in TABPY_PWD_FILE setting. Once they were converted to backslashes, the issue was gone. Connections establish straightway without having to hit Enter anymore.

TABPY_PWD_FILE = C:\Program Files\Microsoft\PyForMLS\Lib\site-packages\tabpy\tabpy_server\common\Password\users.txt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant