Jump to content


Photo

Connection Lost Or Hung Over Vpn


  • Please log in to reply
11 replies to this topic

#1 Mitch

Mitch

    Advanced Member

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male

Posted 18 January 2011 - 11:31 PM

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.

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,923 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 18 January 2011 - 11:52 PM

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?


Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 Mitch

Mitch

    Advanced Member

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male

Posted 19 January 2011 - 06:10 PM

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.


connect_timeout	10
delayed_insert_timeout	300
innodb_lock_wait_timeout	50
innodb_rollback_on_timeout	OFF
interactive_timeout	28800
net_read_timeout	30
net_write_timeout	60
slave_net_timeout	3600
table_lock_wait_timeout	50
wait_timeout	28800


#4 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,923 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 19 January 2011 - 06:38 PM

Do you have any idea on how we can reproduce this? What is the exact VPN solution you are using?
Computers make your grey hair come off ....

Peter Laursen
Webyog

#5 Mitch

Mitch

    Advanced Member

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male

Posted 19 January 2011 - 08:32 PM

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.

#6 ashwin

ashwin

    Advanced Member

  • Members
  • PipPipPip
  • 275 posts
  • Gender:Male
  • Location:Bangalore, India

Posted 20 January 2011 - 05:11 AM

In order to investigate this issue we request you to provide us temporary access to your connection.
Please create support ticket by sending the details to mail-id : support@webyog.com

#7 Mitch

Mitch

    Advanced Member

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male

Posted 20 January 2011 - 01:51 PM

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.

#8 Mitch

Mitch

    Advanced Member

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male

Posted 05 February 2011 - 06:51 PM

I have permission to allow you into our VPN for debugging. Are you still interested in doing this?

#9 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,923 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 05 February 2011 - 07:16 PM

sure .. but it will only be after the weekend. I think we should stop communicating here (in a public Forum). Just send a mail to support@webyog.com with a link to this discussion. A (private) ticket will be created and we will continue there.
Computers make your grey hair come off ....

Peter Laursen
Webyog

#10 chrisbloom7

chrisbloom7

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 23 February 2011 - 10:27 PM

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)

#11 chrisbloom7

chrisbloom7

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 23 February 2011 - 10:45 PM

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.

#12 supersuf

supersuf

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 17 October 2012 - 10:09 AM

Any updates on this? I believe I am facing the same issue.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users