<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<title></title>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
<meta http-equiv="Content-Style-Type" content="text/css"/>
</head>
<body>
<div align="left"><font face="Arial"><span style=" font-size:12pt">DXSpidermen,</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">I have reposted my 30 Mar message, which asks for assistance in sorting out
a perplexing user disconnect problem. Any help would be greatly
appreciated.</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Thanks,</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Dave</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">------- Forwarded message follows -------</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><i>Date sent:</i></span></font><font face="Arial"><span style=" font-size:12pt"> Fri, 30 Mar 2012 08:48:23 -0400</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><i>From:</i></span><span style=" font-size:12pt"> "Dave Hawes" <dave.n3rd@verizon.net></span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><i>Subject:</i></span><span style=" font-size:12pt"> [Dxspider-support] User Disconnects when Script Runs</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><i>To:</i></span><span style=" font-size:12pt"> dxspider-support@dxcluster.org</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><i>Send reply to:</i></span><span style=" font-size:12pt"> n3rd@arrl.net,</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"> The DXSpider Support list <dxspider-support@dxcluster.org></span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><i>Priority:</i></span><span style=" font-size:12pt"> normal</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Many of our users construct spot filters using the "by_state" feature. To keep
the state data current, a crontab entry runs a script each Wednesday at
0130Z to fetch the data and load it. The problem is that each Wednesday at
0130Z all the users are disconnected.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Any suggestions or ideas as to what we can do to eliminate these annoying
disconnects would be most appreciated.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Thanks and 73 - Dave N3RD</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Associate Sysop - K3WW DXSpider</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">More info:</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">1. If the script is run manually by the sysop, the disconnects do not occur.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">2. The update script has not changed in a long time, but these user
disconnects started to occur after a fairly recent update of Spider. It took us a
while to figure out what was going on. We prefer to stay current with Spider.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">3. DXSpider V1.55 build 0.102</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">4. Linux info (Fedora Core 7):</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">[root@spider-linux ~]# uname -a</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">Linux spider-linux 2.6.22.5-76.k3wwspider7.fc7 #1 SMP Mon Sep 17
17:17:26 EDT 2007 i686 i686 i386 GNU/Linux</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">[root@spider-linux ~]#</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">5. This is the script that is run by crontab to update the usdb database:</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">[root@spider-linux /spider/local_cmd]# cat get-usdbraw.sh</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">#! /bin/sh</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">#</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">cd /tmp</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">rm -f usdbraw*</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">date >> /spider/local_cmd/wget-usdbraw-log</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">until wget "http://ftp.w1nr.net/usdbraw.gz"; do date >>
/spider/local_cmd/wget-usdbraw-log; done</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">rm -f /spider/data/usdb.v1</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">cd /spider/perl</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">perl create_usdb.pl /tmp/usdbraw.gz</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">cd ../data</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">chown spideradmin:spider usdb.v1</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">cd ../perl</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">./console.pl <<EOF</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">load/usdb</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">bye</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">EOF</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">#</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">#</span></font></div>
<div align="left"><font face="Arial"><span style=" font-size:12pt">------- End of forwarded message -------</span></font></div>
<div align="left"> </div>
</body>
</html>