[Dxspider-support] US Database not loaded

Sat Oct 10 17:48:58 CEST 2020

Hi Dirk,

Thanks for your prompt reply.   It helped me to sort the problem.

For completeness:

The problem was:

The node started but during the startup, the output  showed "US Database not
loaded" rather than "US Database loaded"
The node continued the startup process and ran successfully.   
In console, issuing the command  load/usdb resulted in "US Database not
loaded".   Hum

usdb.v1 was correctly present in local_data and not data.   

Dirk, your email reply contained the vital clue in your suggested line:

$ cd /tmp; wget -q ftp://ftp.w1nr.net/usdbraw.gz; 
/spider/perl/create_usdb.pl /tmp/usdbraw.gz; rm -f /tmp/usdbraw.gz

I tried this and it worked perfectly.    US Database now loaded ok.   

So what went wrong.   Well my install script that I used to re-build the
node missed the "-q" parameter after wget.   This was the only difference.
I don't know the relevance of -q (but will find out).    I am puzzled
because I have previously built 2 nodes using the same script and it worked
or so I  thought.    Anyway, a teaser for my brain on a rainy day.   

I have also added your line to the cron which is a great idea.

Thanks again for your help Dirk.    Hope you are on the road to recovery.

Regards

Mike G3YPP
Sysop for mx0nca-2
Norfolk Coast ARS

-----Original Message-----
From: Dxspider-support [mailto:dxspider-support-bounces at tobit.co.uk] On
Behalf Of dxspider-support-request at tobit.co.uk
Sent: 10 October 2020 11:00
To: dxspider-support at tobit.co.uk
Subject: Dxspider-support Digest, Vol 213, Issue 7

Send Dxspider-support mailing list submissions to
	dxspider-support at tobit.co.uk

To subscribe or unsubscribe via the World Wide Web, visit
	https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support
or, via email, send a message with subject or body 'help' to
	dxspider-support-request at tobit.co.uk

You can reach the person managing the list at
	dxspider-support-owner at tobit.co.uk

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Dxspider-support digest..."

Today's Topics:

   1. US Database not loaded (mike at g3ypp.uk)
   2. Re: US Database not loaded (Dirk Koopman)

----------------------------------------------------------------------

Message: 1
Date: Fri, 9 Oct 2020 16:27:04 +0100
From: <mike at g3ypp.uk>
To: <dxspider-support at tobit.co.uk>
Subject: [Dxspider-support] US Database not loaded
Message-ID:

<!&!AAAAAAAAAAAYAAAAAAAAAD3P8qIGAItHiKGvbLvX5zbCgAAAEAAAAKkCmIoqpe9ApnnCNkKo
VKoBAAAAAA==@g3ypp.uk>

Content-Type: text/plain; charset="us-ascii"

Hi Dirk et al,

After not being able to restart my node after a computer crash, I decided it
would just be quicker to rebuild it from scratch.

That I have done and the node is successfully running 1.57 mojo build 338.
Everything seems to be working fine EXCEPT that I can't load the US
Database.   I have tried deleting usdb.v1, re-creating it etc.   No joy.

Running Debian 10 (Buster) on a PC previously running the node perfectly.

Any ideas?

Regards

Mike

Sysop MX0NCA-2

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20201009
/fc50e6c3/attachment-0001.htm>

------------------------------

Message: 2
Date: Fri, 9 Oct 2020 17:16:36 +0100
From: Dirk Koopman <djk at tobit.co.uk>
To: Mike Costello via Dxspider-support <dxspider-support at tobit.co.uk>
Subject: Re: [Dxspider-support] US Database not loaded
Message-ID: <f73eed6c-82ec-ec7e-f826-0a231e0448b3 at tobit.co.uk>
Content-Type: text/plain; charset="windows-1252"; Format="flowed"

When you say "can't" does that mean the node stops with an error? Or is 
it ineffective, i.e sh/usdb w1aw or somesuch returns an error message or 
no output?

In my (mojo branch only) crontab in /spider/local_cmd I have these lines:

31 3 * * 6 spawn('cd /tmp; wget -q ftp://ftp.w1nr.net/usdbraw.gz; 
/spider/perl/create_usdb.pl /tmp/usdbraw.gz; rm -f /tmp/usdbraw.gz')
35 3 * * 6 run_cmd('load/usdb')

I copy'n'pasted the line in the spawn command above into a spare shell 
window and after a few seconds got this:

$ cd /tmp; wget -q ftp://ftp.w1nr.net/usdbraw.gz; 
/spider/perl/create_usdb.pl /tmp/usdbraw.gz; rm -f /tmp/usdbraw.gz

1452902 records
$

Started up my dev node and got this:

09Oct2020 at 15:58:03 (*) DXSpider V1.57, build 338 (git: mojo/56526488[r]) 
started
09Oct2020 at 15:58:03 (*) Copyright (c) 1998-2020 Dirk Koopman G1TLH
09Oct2020 at 15:58:03 (*) loading prefixes ...
09Oct2020 at 15:58:03 (*) US Database loaded
09Oct2020 at 15:58:03 (*) loading band data ...
09Oct2020 at 15:58:03 (*) loading user file system ...
09Oct2020 at 15:58:03 (*) starting listeners ...

and this in a console:

G1TLH-2 de GB7TLH? 9-Oct-2020 1610Z dxspider >
sh/usdb w1aw
W1AW??? -> Newington, CT

So, for me and for others it would appear to work.

Please check that you *don't* have a old /spider/data/usdb.v1 in 
/spider/data and that you *do* have a /spider/local_data directory and 
that the usdb.v1 is appoximately this big:

/spider/local_data$ ls -l usdb.v1
-rw-rw-r-- 1 djk djk 66289664 Oct? 9 17:08 usdb.v1

73 Dirk G1TLH

On 09/10/2020 16:27, Mike Costello via Dxspider-support wrote:
>
> Hi Dirk et al,
>
> After not being able to restart my node after a computer crash, I 
> decided it would just be quicker to rebuild it from scratch.
>
> That I have done and the node is successfully running 1.57 mojo build 
> 338.??? Everything seems to be working fine EXCEPT that I can?t load 
> the US Database. ?I have tried deleting usdb.v1, re-creating it etc.?? 
> No joy.
>
> Running Debian 10 (Buster) on a PC previously running the node perfectly.
>
> Any ideas?
>
> Regards
>
> Mike
>
> Sysop MX0NCA-2
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at tobit.co.uk
> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20201009
/9fe23090/attachment-0001.htm>

------------------------------

Subject: Digest Footer

_______________________________________________
Dxspider-support mailing list
Dxspider-support at tobit.co.uk
https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support

------------------------------

End of Dxspider-support Digest, Vol 213, Issue 7
************************************************