- This topic is empty.
January 18, 2011 at 11:31 pm #12230
SQLyog Ultimate 8.71 in WINE Ubuntu 10.04 64 bit
I use a VPN to connect to a remote network. I use SQLyog over that VPN to connect to the remote mysql server. The connection works fine, but if the program has been idle for a long time (hours), the next time I try to do anything that talks to mysql in that window, the program hangs as if the connection were dropped. I know that the VPN has not gone down because I use it in other programs successfully.
January 18, 2011 at 11:52 pm #31838
Please execute (after connecting to MySQL with SQLyog)
SHOW VARIABLES LIKE '%timeout%';
.. and paste the result here. If 'wait_timeout' is low try to set it higher (max setting is 28800 (seconds)) in the connections manager.
Do you have any option not to use the VPN. To use SSH tunnel for instance?
January 19, 2011 at 6:10 pm #31839
Timeout values below. I did not see this problem when I used an ssh tunnel (either my own outside of SQLyog or using the SQLyog tunnel). I “could” use ssh, but that is not as convenient for me when I move from remote to office and back.Code:connect_timeout 10
January 19, 2011 at 6:38 pm #31840
Do you have any idea on how we can reproduce this? What is the exact VPN solution you are using?
January 19, 2011 at 8:32 pm #31841
It is a standard PPTP VPN. The hardware on the host side is a FortiGate firewall, client is Ubuntu 10.04 with native PPTP client.
If you can't reproduce it let me know and I'll investigate if I can set you up to access ours.
January 20, 2011 at 5:11 am #31842
January 20, 2011 at 1:51 pm #31843
I will investigate the feasibility of doing so. It may be a while as I'm out of town for a week. I will let you know.
February 5, 2011 at 6:51 pm #31844
I have permission to allow you into our VPN for debugging. Are you still interested in doing this?
February 5, 2011 at 7:16 pm #31845
February 23, 2011 at 10:27 pm #31846chrisbloom7Member
I have found that this happens if the VPN connection closes/drops and is then re-established. The most frustrating part is that the entire connection window freezes so you can't get back to any other tab but the one that was currently open. I just lost about 4 hours worth of work (my fault for not saving it earlier, but still frustrating).
In my case, I'm on a PPTP connection in OS X 10.6 using the built-in VPN utility.
EDIT: More details – Running SqlYog Community v8.61 via CrossOver (Wine bottle manager for Mac)
February 23, 2011 at 10:45 pm #31847chrisbloom7Member
I was really upset about losing my work so I was leaving the dead connection window open, just ignoring the problem. Much to my surprise and delight the window appears to have reestablished connection again. Mind you this was after having the VPN connection open again for at least 30 or 40 minutes, as well as after opening new connection windows to the same MySQL server. Maybe it is a timeout issue, but thankfully not to the tune of 28800 seconds.
October 17, 2012 at 10:09 am #31848supersufMember
Any updates on this? I believe I am facing the same issue.
February 21, 2017 at 5:12 pm #31849danfareMember
Same thing is happening to me. Very frustrating.
- You must be logged in to reply to this topic.