Connection Lost Or Hung Over Vpn
Posted 18 January 2011 - 11:31 PM
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.
Posted 18 January 2011 - 11:52 PM
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?
Posted 19 January 2011 - 06:10 PM
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
Posted 19 January 2011 - 06:38 PM
Posted 19 January 2011 - 08:32 PM
If you can't reproduce it let me know and I'll investigate if I can set you up to access ours.
Posted 20 January 2011 - 05:11 AM
Please create support ticket by sending the details to mail-id : firstname.lastname@example.org
Posted 20 January 2011 - 01:51 PM
Posted 05 February 2011 - 06:51 PM
Posted 05 February 2011 - 07:16 PM
Posted 23 February 2011 - 10:27 PM
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)
Posted 23 February 2011 - 10:45 PM
Posted 17 October 2012 - 10:09 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users