[Dxspider-support] usdb and dxqsl not working?

[Dirk Koopman]

Sadly, there is a big gulf between the (very) old Berkeley DB file 
formats and more modern ones and it isn't simply between 32 and 64 bits 
either. Anything earlier than 5.8 perl is likely to be incompatible. 
However, the good(ish) news is that since then it seems that the 
promised upward compatibility has been largely maintained - but there 
have also been issues with the Storable system module. I have tried 
moving away from BDB but there is nothing that does all the jobs that it 
does or is even more unreliable (and that, sadly, includes sqlite). I 
won't (as standard) use a separate, network/socket connected, database - 
although I am open to adding (more) 3rd party hooks to them. But 
anything that involves users is likely not to change as deterministic 
speed is important to the code. And I won't ditch writing away the "raw" 
data (like spots, users etc) to files - just in case :-)

This is why the rebuilding mechanisms are there - because stuff happens. 
Your dxsql database will contain all the information that the old one 
has because it is using the same mechanism as the "realtime" software 
and from the same data (the spots) to do the regeneration. The file is 
easy enough to read and the source is available :-), but I really ought 
to add a count to show how many records were processed and how many 
lines of data there are.

Actually, the dxqsl stuff was written March 2003, so if you have spot 
data from before then (2002), you will actually have more data in there 
than you had on your old system. Mine has data going back to 1997.

Dirk G1TLH

On 28/11/16 06:07, Rene Olsen via Dxspider-support wrote:
> Hi.
>
> It seems as if none of the data files I have from my old system can be used.
>
> I also had to recreate the users.v3 file by running perl user_asc. The old users.v3 file didn't
> work. I don't recall spider giving out any errors when I started it, but the users just wasn't
> there.
>
> My sh/dxqsl and sh/usdb also seems to be working now.
>
> I deleted both the qsl.v1 and the usdb file in the data folder, and recreated them by running
> create_qsl and create_usdb. Luckily I have spots going back to 2002, so I guess the qsl.v1
> file has all the same information as the old one, eventhough it is quite a bit smaller. The new
> one is around 9 MB in size, and the old one is 12 MB in size. But maybe the old one has
> more information in it. I don't know. Is there any way to see how many entries the qsl.v1 file
> has?
>
> Wether it is the change from 32 to 64 bit, or the change in perl version and newer versions of
> the modules I don't know. But I have had to recreate all the data files.
>
> Vy 73 de René / OZ1LQH
>
>
> On 27 Nov 2016 at 19:00, dxspider-support at dxcluster.or wrote:
>
>> Hi.
>>
>> Just as I thought everything was working like it should I can see that sh/usdb and sh/dxqsl
>> doesn't seem to work.
>>
>> It looks to me like the file qsl.v1 is not even being updated anymore.
>>
>> Should this not just happen automatically?
>>
>> Or does a db need to be created for it to work.
>>
>> The docs really don't mention much about it.
>>
>> Hopefully it is not something with the format of the qsl.v1 after I have moved from the old 32
>> bit machine running perl 5.6.1 to the current 64 bit system running perl v5.20.2.
>>
>> Any idea what I have to do to get sh/usdb and sh/dxqsl to work again?
>>
>> I would really hate to loose all the information in the qsl.v1 file, since it has been gathering
>> data for a lot of years.
>>
>> I have of course downloaded the usdb file and done a create_usdb.pl and afterwards a
>> load/usdb.
>>
>> But whenever I do a sh/usdb request I am just being told that it isn't found.
>>
>> sh/usdb k3zo
>> K3ZO    -> Not Found
>>
>> sh/usdb w3lpl
>> W3LPL   -> Not Found
>>
>> And sh/dxqsl returns this:
>>
>> sh/dxqsl 5h1ww
>> Call           Manager   Times  Last Time Seen      De
>> Sorry, but key: 5H1WW was not found in QSL
>>
>> I have no idea what I have done wrong. Everything just worked on the old system.
>>
>> Vy 73 de René / OZ1LQH
>>
>
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at dxcluster.org
> http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support