Python Forum
[PyQt] SSH port forwarding and connection to SQL Server in separate threads freezes
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[PyQt] SSH port forwarding and connection to SQL Server in separate threads freezes
#25
(Dec-02-2019, 06:51 PM)Denni Wrote: okay so how are you implementing
1) The PuTTY connection (which establishes the SSH connection to the database?)
2) The communication from the program to the database via the PuTTY connection
The connection via PuTTY established port forwarding over SSH so the in order to talk to SQL Server I need to establish connection to localhost at 1433 port (PuTTY is forwarding remote port on which SQL Server listens to localhost)

(Dec-02-2019, 06:51 PM)Denni Wrote: Also have you tested this as a standalone process without a Thread -- aka you run the program it talks to the database through PuTTY and gets a reply? Nothing complicated and no GUI just straight python
Yes I did and it works without problem. The only thing I have not tried is to establish port forwarding over SSH and then connection to SQL Server without GUI. However I guess it should also use threading.
Reply


Messages In This Thread
RE: SSH port forwarding and connection to SQL Server in separate threads freezes - by jan_pips - Dec-03-2019, 01:17 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  GUI freezes while executing a callback funtion when a button is pressed abi17124 5 7,523 Jul-10-2019, 12:48 AM
Last Post: FullOfHelp
  [Tkinter] tkinter freezes by clicking button Zatox11 33 25,910 Apr-10-2018, 09:03 AM
Last Post: Zatox11
  Running telnet loop freezes GUI reedhallen 1 3,470 Jan-27-2018, 10:24 PM
Last Post: j.crater
  Clock freezes - wx.python glib problem strongheart 3 4,066 Oct-10-2017, 03:36 AM
Last Post: strongheart

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020