<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<div class="moz-cite-prefix">Funnily enough I ran into this the
other day. The problem appears to be permissions and ownership.<br>
<br>
The usdb.v1 file must be owned by sysop group sysop and the
permissions should be 0664 (-rw-rw-r--)<br>
<br>
-rw-rw-r-- 1 sysop sysop 67969024 Dec 25 03:31
/spider/local_data/usdb.v1<br>
<br>
If it isn't then modern perls (don't know when this started) won't
"tie" the database and then error, giving you the "Not Loaded".<br>
<br>
cd /spider/local_data; chown sysop:sysop usdb.v1; chmod 0664
usdb.v1<br>
<br>
should fix it.<br>
<br>
I put out a way to do this automatically in the crontab recently.
But some people have issues. It is on my list to look at. <br>
<br>
Dirk<br>
<br>
On 28/12/2021 15:42, Rob Harrison via Dxspider-support wrote:<br>
</div>
<blockquote type="cite"
cite="mid:DB9P251MB02893C1CE2FACD592665D498E3439@DB9P251MB0289.EURP251.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">I re-did it as sysop on linux box and I
think it worked<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="mso-fareast-language:EN-GB" lang="EN-US">From:</span></b><span
style="mso-fareast-language:EN-GB" lang="EN-US">
Dxspider-support
<a class="moz-txt-link-rfc2396E" href="mailto:dxspider-support-bounces@tobit.co.uk"><dxspider-support-bounces@tobit.co.uk></a>
<b>On Behalf Of </b>Rob Harrison via Dxspider-support<br>
<b>Sent:</b> 28 December 2021 15:34<br>
<b>To:</b> The DXSpider Support list
<a class="moz-txt-link-rfc2396E" href="mailto:dxspider-support@dxcluster.org"><dxspider-support@dxcluster.org></a><br>
<b>Cc:</b> Rob Harrison <a class="moz-txt-link-rfc2396E" href="mailto:g4ujs@outlook.com"><g4ujs@outlook.com></a><br>
<b>Subject:</b> [Dxspider-support] USDB - HELP<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Help please<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I downloaded usdbraw.gz on a windows
machine, copied it to the linux box /temp<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And then<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">root@GB7UJS:/spider/perl#
/spider/perl/create_usdb.pl /tmp/usdbraw.gz<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">which returned<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">1507865 records<o:p></o:p></p>
<p class="MsoNormal">root@GB7UJS:/spider/perl#<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">then I logged in as sysop on a terminal and
did load/usdb<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">and got<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">US database not loaded.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Where did I go wrong please?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Rob<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span
style="font-size:14.0pt;font-family:"Arial",sans-serif;color:#004080;mso-fareast-language:EN-GB"
lang="EN-US">Rob Harrison</span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#00204E;mso-fareast-language:EN-GB"
lang="EN-US"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#000040;mso-fareast-language:EN-GB"
lang="EN-US">Green Lane House, Whixall, Shropshire, SY13
2PT.</span><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#FF9900;mso-fareast-language:EN-GB"
lang="EN-US">M:</span></b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-GB"
lang="EN-US"> <b>07826 958358</b></span><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#FF9900;mso-fareast-language:EN-GB">E: <u><a
href="mailto:g4ujs@outlook.com" moz-do-not-send="true"><span
style="color:#FF9900">g4ujs@outlook.com</span></a></u></span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="color:black;mso-fareast-language:EN-GB"
lang="EN-US"> </span></b><b><span
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#FF9900;mso-fareast-language:EN-GB"
lang="EN-US">_________________________________________________________________________________________________</span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00204E;mso-fareast-language:EN-GB"
lang="EN"> </span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00204E;mso-fareast-language:EN-GB"
lang="EN-US">This e-mail and any attachments are not
guaranteed to be free from viruses, and are for the
intended addressee(s) only</span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00204E;mso-fareast-language:EN-GB"
lang="EN-US">and may contain confidential and/or
privileged material, so if you are not a named or
intended addressee, do not use,</span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00204E;mso-fareast-language:EN-GB"
lang="EN-US">retain or disclose such information. </span></b><span
style="color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:18.0pt;font-family:Webdings;color:green;mso-fareast-language:EN-GB">P</span><span
style="font-size:10.0pt;font-family:"Times New
Roman",serif;color:navy;mso-fareast-language:EN-GB"> </span><b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:green;mso-fareast-language:EN-GB">Consider
the environment. Please don't print this e-mail unless you
really need to.<o:p></o:p></span></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Dxspider-support mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Dxspider-support@tobit.co.uk">Dxspider-support@tobit.co.uk</a>
<a class="moz-txt-link-freetext" href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a>
</pre>
</blockquote>
<br>
</body>
</html>