Re: sshd time out
Thanks!! Me too!! On 2014-11-04 17:23, Michael Havens wrote: so glad you worked that out , man! :-)~MIKE~(-: On Tue, Nov 4, 2014 at 1:17 PM, Keith Smith wrote: Thank you to those of you who replied. Interesting experience. I was uploading a data dump into MySql. My "Konsole" did not show any activity for about an hour and a half. Then I get the message "Write failed: Broken pipe". This morning I erased the database I had uploaded last night because there was no way to tell if the import was complete. The import was about 600MB. Last night I had added "ServerAliveInterval 5" to my sshd config. This morning when I did the upload it took about 3 minutes. It looks like all the data is there. That means my shell must have been hung for well over an hour. Thanks again for all the ideas and feedback!! Keith On 2014-11-04 10:40, der.hans wrote: Am 04. Nov, 2014 schwätzte Keith Smith so: moin moin Keith, Last night I shelled into a web server I am working on and issue the command to upload data into MySql from the command line. The process took about an hour and a half. Then I received the message "Write failed: Broken pipe". In researching, apparently sshd timed out. I'm guessing the process completed... But how would I know? Check MySQL to see if all of the data loaded. The ssh connection was killed, so you don't know how the shell did. If you need to run long commands on remote systems, use screen or tmux on the remote system. That will keep the shell running even if the network connection is killed. It also allows you to reconnect to the shell. screen -S mysession # Start a screen session named mysession screen -x mysession # reconnect to the screen session named mysession -a d # disconnect from an active screen session If you already run screen locally you can either run screen within screen or you can start a new xterm, then connect out. I also recommend the ServerAliveInterval, but I set it to 5 minutes. I used that for all ssh connections. ServerAliveInterval 300 ciao, der.hans --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1] -- Keith Smith --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1] Links: -- [1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss -- Keith Smith --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss
Re: sshd time out
so glad you worked that out , man! :-)~MIKE~(-: On Tue, Nov 4, 2014 at 1:17 PM, Keith Smith wrote: > > > Thank you to those of you who replied. Interesting experience. > > I was uploading a data dump into MySql. My "Konsole" did not show any > activity for about an hour and a half. Then I get the message "Write > failed: Broken pipe". > > This morning I erased the database I had uploaded last night because there > was no way to tell if the import was complete. > > The import was about 600MB. > > Last night I had added "ServerAliveInterval 5" to my sshd config. > > This morning when I did the upload it took about 3 minutes. It looks like > all the data is there. That means my shell must have been hung for well > over an hour. > > Thanks again for all the ideas and feedback!! > > Keith > > > > > On 2014-11-04 10:40, der.hans wrote: > >> Am 04. Nov, 2014 schwätzte Keith Smith so: >> >> moin moin Keith, >> >> Last night I shelled into a web server I am working on and issue the >>> command to upload data into MySql from the command line. The process took >>> about an hour and a half. >>> >>> Then I received the message "Write failed: Broken pipe". In >>> researching, apparently sshd timed out. >>> >>> I'm guessing the process completed... But how would I know? >>> >> >> Check MySQL to see if all of the data loaded. >> >> The ssh connection was killed, so you don't know how the shell did. >> >> If you need to run long commands on remote systems, use screen or tmux on >> the remote system. That will keep the shell running even if the network >> connection is killed. It also allows you to reconnect to the shell. >> >> screen -S mysession # Start a screen session named mysession >> screen -x mysession # reconnect to the screen session named mysession >> >> -a d # disconnect from an active screen session >> >> If you already run screen locally you can either run screen within screen >> or you can start a new xterm, then connect out. >> >> I also recommend the ServerAliveInterval, but I set it to 5 minutes. I >> used that for all ssh connections. >> >> ServerAliveInterval 300 >> >> ciao, >> >> der.hans >> --- >> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org >> To subscribe, unsubscribe, or to change your mail settings: >> http://lists.phxlinux.org/mailman/listinfo/plug-discuss >> > > -- > Keith Smith > --- > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org > To subscribe, unsubscribe, or to change your mail settings: > http://lists.phxlinux.org/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss
Re: sshd time out
Thank you to those of you who replied. Interesting experience. I was uploading a data dump into MySql. My "Konsole" did not show any activity for about an hour and a half. Then I get the message "Write failed: Broken pipe". This morning I erased the database I had uploaded last night because there was no way to tell if the import was complete. The import was about 600MB. Last night I had added "ServerAliveInterval 5" to my sshd config. This morning when I did the upload it took about 3 minutes. It looks like all the data is there. That means my shell must have been hung for well over an hour. Thanks again for all the ideas and feedback!! Keith On 2014-11-04 10:40, der.hans wrote: Am 04. Nov, 2014 schwätzte Keith Smith so: moin moin Keith, Last night I shelled into a web server I am working on and issue the command to upload data into MySql from the command line. The process took about an hour and a half. Then I received the message "Write failed: Broken pipe". In researching, apparently sshd timed out. I'm guessing the process completed... But how would I know? Check MySQL to see if all of the data loaded. The ssh connection was killed, so you don't know how the shell did. If you need to run long commands on remote systems, use screen or tmux on the remote system. That will keep the shell running even if the network connection is killed. It also allows you to reconnect to the shell. screen -S mysession # Start a screen session named mysession screen -x mysession # reconnect to the screen session named mysession -a d # disconnect from an active screen session If you already run screen locally you can either run screen within screen or you can start a new xterm, then connect out. I also recommend the ServerAliveInterval, but I set it to 5 minutes. I used that for all ssh connections. ServerAliveInterval 300 ciao, der.hans --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss -- Keith Smith --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss
Re: sshd time out
Am 04. Nov, 2014 schwätzte Keith Smith so: moin moin Keith, Last night I shelled into a web server I am working on and issue the command to upload data into MySql from the command line. The process took about an hour and a half. Then I received the message "Write failed: Broken pipe". In researching, apparently sshd timed out. I'm guessing the process completed... But how would I know? Check MySQL to see if all of the data loaded. The ssh connection was killed, so you don't know how the shell did. If you need to run long commands on remote systems, use screen or tmux on the remote system. That will keep the shell running even if the network connection is killed. It also allows you to reconnect to the shell. screen -S mysession # Start a screen session named mysession screen -x mysession # reconnect to the screen session named mysession -a d # disconnect from an active screen session If you already run screen locally you can either run screen within screen or you can start a new xterm, then connect out. I also recommend the ServerAliveInterval, but I set it to 5 minutes. I used that for all ssh connections. ServerAliveInterval 300 ciao, der.hans -- # http://www.LuftHans.com/http://www.PhxLinux.org/ # Strangers are friends just waiting to happen!--- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss
Re: sshd time out
Add " ServerAliveInterval 60" to ~/.ssh/config to keep that from annoying you. You'll know if your data xfer is incomplete. If it didn't exit clean before that, probably not. -mb On 11/04/2014 09:10 AM, Keith Smith wrote: Hi, Last night I shelled into a web server I am working on and issue the command to upload data into MySql from the command line. The process took about an hour and a half. Then I received the message "Write failed: Broken pipe". In researching, apparently sshd timed out. I'm guessing the process completed... But how would I know? Thank, Keith --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss
Re: sshd time out
On 2014-11-04 07:10, Keith Smith wrote: command to upload data into MySql from the command line. The process took about an hour and a half. Then I received the message "Write failed: Broken pipe". In researching, apparently sshd timed out. Many networking appliances that do NAT close connections after a period of inactivity. This period usually ranges from 30 to 120 minutes, and may not be adjustable. This is why I have keepalive.sh in my ~/bin/ : #!/bin/sh while true ; do echo -n '.' sleep 300 done ...start whatever's going to take a long time in the background, then start keepalive.sh in the foreground, connection won't drop. I'm guessing the process completed... But how would I know? Check the mysql DB for the last row in the dump you were loading, of course. -- Crow202 Blog: http://crow202.org/wordpress There is no Darkness in Eternity But only Light too dim for us to see. --- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss