[Dxspider-support] ipaddr is null in mysql DB

[JMarcio S]

Hi Dirk,

       Thanks for info, I consider the dx spider a very good application
and now with a lot of quick search options in the 'mojo 1.57' sh/dx is
fast, very good job, thank you!

I'm running on a VM (Digital Ocean), with very little RAM and CPU used.

I am not running dxspider on older versions. Currently, I have two nodes in
the VM, the first version is: 155, build 0.204 and the second virtual
machine is: 1.57 build 252 (mojo).

To populate the MySQL database, I configure DXVARS, I don't write code for
this, only dxspider package.

# the SQL database DBI dsn

$dsn = "dbi:mysql:dxcluster:xxx.xxx.xxx.xx:yyyy”;

$dbuser = “xxxxx”;

$dbpass = “xxxxxxx”x;

and then the process is automatic, the DB is populated with the fields
(freq, spotcall, time, comment, spotter, spotdxcc.spotterdxcc, origin, itu,
cq, usstate, and ipaddr).

all of these fields are loaded normally when using node version 155, build
0.204

when using node version 1.57 build 252 the ipaddr field is not loaded. I
thought it had something to do with the new version of DXspider.

I'm not sure if I found the right information. I started 'watchdbg' and the
result was:

version 1.57/252

09:34:23 (chan) <- I PY4OG-2
PC92^DH1TW-2^34462^A^^7K1TTT-1:208.125.133.190^H93^

09:34:23 (chan) <- I PY4OG-2
PC92^IW1QLH-6^34462^A^^7JG1VGX-8:3.115.254.10^H94^

09:34:46 (chan) <- I PY4OG-2 PC11^70154.0^OK2BRD^ 5-Jun-2020^0934Z^<ES>

version 155/0204

09:40:24 -> D PY4OG-4 PC92^F4BWT-3^34824^D^^5F6BVP-3^H93^

09:40:24 -> D PY3NZ-8 PC92^F4BWT-3^34824^D^^5F6BVP-3^H93^

09:40:24 <- I WB3FFV-2 PC41^IW2CLM^1^Dome^H29^~

         Mysql DB is only for queries on a rest API created to connect with
mobile devices, you can see the results accessing the iDX App only for iOS
devices. This database was the way found to develop this interface is also
to add new information to the spot line, such as dxpeditions, lotw, special
events, beacons and other filters in real time. I cannot say if it is a
faster solution, but it is imperceptible.

To send spots I use Telnet tcp/socket via standard dxspider, ipaddr is
correct.

No problem, currently I don't use the ip filter in mysql just in DxSpider
and there, everything works fine. I just thought of helping to fix any bug
in the 'mojo' version, but everything is understood now. Well, I will now
try a new installation and replace the necessary DBI drivers for the mysql
interface.

      thank you again

     73 J.Marcio PY4OG

Em qua., 3 de jun. de 2020 às 09:10, Dirk Koopman via Dxspider-support <
dxspider-support at tobit.co.uk> escreveu:

> I don't know why that should be. At this point I need to write the
> programmer's lament: "I never touched that bit of the code".
>
> My changes are just concerned with searching, not spot storage.
>
> Are you getting PC61 style spots? Are they mainly first or not? This last
> question is because I store the first version of a spot that comes in.
> There are still (too many) old DXSpider nodes out there that do not
> generate PC61 instead of PC11 (and the less said about DXSummit the better).
>
> It would be interesting to compare the output of this:
>
>  grepdbg 'I [-\w]+ PC[61]1'
>
> to a SQL query.
>
> I WISH SYSOPs WOULD UPDATE THEIR SOFTWARE TO THE LATEST VERSION ON THEIR
> BRANCH. The mojo branch is a bit experimental, particularly as I am stuck
> at home not doing very much. But if you on the standard 'master' branch,
> you should update your software at least every couple of months. It gets
> you some fixes that the mojo branch work has found and also updated prefix
> information. The fact that there are so many PC11 spots still being
> generated means that your *node has not been updated since at least 2012*!
>
> Back to the point:
>
> This is the entire code that stores a spot. @_ contains the expanded spot
> data (the spot + all the country, zone and US state data) in separate
> fields.
>
> sub add
> {
>     my $buf = join('^', @_);
>     $fp->writeunix($_[2], $buf);
>     if ($main::dbh) {
>         $main::dbh->begin_work;
>         $main::dbh->spot_insert(\@_);
>         $main::dbh->commit;
>     }
>     $totalspots++;
>     if ($_[0] <= 30000) {
>         $hfspots++;
>     } else {
>         $vhfspots++;
>     }
>     if ($_[3] =~ /(?:QSL|VIA)/i) {
>         my $q = QSL::get($_[1]) || new QSL $_[1];
>         $q->update($_[3], $_[2], $_[4]);
>     }
> }
>
> Now, I am afraid that I don't run a MySQL database and am not generally a
> fan because it has a nasty tendency to take every spare piece of RAM that
> it can find - although that behaviour may now have changed in the 8 years
> or so since I last looked at this.
>
> 73 Dirk G1TLH
>
> On 03/06/2020 02:43, JMarcio S via Dxspider-support wrote:
>
>  Hi Dirk
>     The ipaddr in the Mysql database is null, after Mojo. Any format
> changes? current is: VARCHAR 40. (running DXSpider V1.57 build 252).
>     Thank you again
>
> J.Marcio PY4OG
>
> _______________________________________________
> Dxspider-support mailing listDxspider-support at tobit.co.ukhttps://mailman.tobit.co.uk/mailman/listinfo/dxspider-support
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at tobit.co.uk
> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support
>


-- 
J.Marcio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20200605/d194cb16/attachment.htm>