<!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">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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"><span style=" font-size:12pt"><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"> </div>
</body>
</html>