search

prabowomurti / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

[REQ] Specify Keep Alive time #760

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
I connect to a database trough a firewall, and that firewall drops any 
connection which is idle for 15 minutes. So it would be great to specify the 
time in which a keep-alive ping is sent (or just reduce it to 10min).

Thanks for Sequel Pro!

Original issue reported on code.google.com by google%m...@gtempaccount.com on 9 Jul 2010 at 10:57

GoogleCodeExporter commented 9 years ago 
Hi Alex,

If you have keepalive enabled (set in Preferences > Network), the keepalive 
should be sent every 60 seconds… does it currently look as if the firewall is 
dropping the connection?

Original comment by rowanb@gmail.com on 9 Jul 2010 at 11:29

GoogleCodeExporter commented 9 years ago 
I've enabled the keep-alive.
tcpdump didn't show any packets except those I request.
(sudo tcpdump -i en0 host x.x.x.x)
the firewall drops the connection after 15 minutes idle.
I'm using the 0.98 version.

Original comment by google%m...@gtempaccount.com on 9 Jul 2010 at 12:00

GoogleCodeExporter commented 9 years ago 
Hi Alex,

I've tested both 0.9.8 and the nightlies with the tcpdump command you posted 
(using en1 as I'm on wifi!) and saw the keepalive packets firing every 60 
seconds, as expected.  I've tested this with MySQL 5.0, 3, and 4.0 servers.  
Are there any other circumstances that could have affected this?  Did you try 
tcpdump directly after connecting, or was it after the connection may have 
reconnected automatically (eg after computer sleep)? I assume you're using 
direct connections, rather than SSH?

Original comment by rowanb@gmail.com on 16 Jul 2010 at 9:44

GoogleCodeExporter commented 9 years ago 
After a restart of the Mac (and SequelPro) that promlem is gone. (but at the 
time I made the report, I had that problem even after a restart).
now it works great, sorry for the complications.

Original comment by google%m...@gtempaccount.com on 9 Aug 2010 at 12:42

GoogleCodeExporter commented 9 years ago 
Has this problem re-appeared at any point?
If not I'll close this bug soon.

Original comment by schlabbe...@gmail.com on 19 Sep 2010 at 8:29

GoogleCodeExporter commented 9 years ago 
Closing after no further feedback.

Original comment by stuart02 on 20 Oct 2010 at 11:49