<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">There is at least one DXSpider instance
which sees 1000+ users and 30 odd nodes most weekends now running
in Digital Oceans smallest $5 droplet. <br>
<br>
I though I would just check that the mysql spot insertion still
works so I installed the version of MariaDB that comes with Ubuntu
18.04 and (after I got the permissions right) this happens:<br>
MariaDB [dxspider]> select * from spot;<br>
<tt>+-------+---------+--------------+------------+---------------------------------+---------+----------+-------------+----------+---------+--------+------------+-----------+-----------+--------------+-----------------+</tt><tt><br>
</tt><tt>| rowid | freq | spotcall | time |
comment | spotter | spotdxcc |
spotterdxcc | origin | spotitu | spotcq | spotteritu |
spottercq | spotstate | spotterstate | ipaddr |</tt><tt><br>
</tt><tt>+-------+---------+--------------+------------+---------------------------------+---------+----------+-------------+----------+---------+--------+------------+-----------+-----------+--------------+-----------------+</tt><tt><br>
</tt><tt>| 1 | 14294 | W2I/STAYHOME | 1591459020 | CQ
CQ | PB5X | 226 | 139
| WA9PIE-2 | 8 | 5 | 27 | 14 |
NULL | NULL | 84.104.178.54 |</tt><tt><br>
</tt><tt>| 2 | 14260 | KY4X | 1591459020 |
NULL | K4NAU | 226 |
226 | AE5E | 8 | 4 | 8 | 4 |
KY | SC | 45.16.255.32 |</tt><tt><br>
</tt><tt>| 3 | 21027.4 | 4U1UN | 1591459020 | No copy
2el,KN10 | SV2EVS | 284 | 156 |
SV2HRT-1 | 8 | 5 | 28 | 20 | NULL
| NULL | 37.6.159.17 |</tt><tt><br>
</tt><tt>| 4 | 28074 | KG5ABO | 1591459020 | FT-8,
Texas | VE3PV | 226 | 197 |
VK3AMA-2 | 7 | 4 | 4 | 4 | TX
| NULL | 108.160.156.103 |</tt><tt><br>
</tt><tt>| 5 | 14042.8 | WB2UBW/SIM | 1591459020 |
CW | W3RZ | 151 |
226 | K5DX | 18 | 14 | 8 | 5 |
NULL | PA | NULL |</tt><tt><br>
</tt><tt>| 6 | 14018.1 | PR7AB | 1591459020 |
CW | PP1CZ | 142 |
142 | VE7CC-1 | 13 | 11 | 15 | 11 |
NULL | NULL | 181.213.78.201 |</tt><tt><br>
</tt><tt>| 7 | 14248 | ND4X | 1591459020 | KY QP
cq cq | MI0SAI | 226 | 63 |
N0VD-7 | 8 | 4 | 27 | 14 | KY
| NULL | NULL |</tt><tt><br>
</tt><tt>| 8 | 7112 | IZ4AFM | 1591459020 | San
Miguel | EA1BQR | 85 | 34 |
EA4URE-2 | 28 | 15 | 37 | 14 | NULL
| NULL | 192.168.1.110 |</tt><tt><br>
</tt><tt>| 9 | 70154 | G0WUU | 1591459020 |
KO02LI<ES>IO92 FT8 -14dB Tnx | SP5AOZ | 61
| 152 | EA6VQ-1 | 27 | 14 | 28
| 15 | NULL | NULL | NULL |</tt><tt><br>
</tt><tt>| 10 | 21027.4 | 4U1UN | 1591459020 |
NIL | F8CRS | 284 |
42 | SR2PUT | 8 | 5 | 27 | 14 |
NULL | NULL | 84.17.52.174 |</tt><tt><br>
</tt><tt>| 11 | 144308 | F5RNN | 1591459020 |
<JN25JH> dept 26 tnx Jean paul | F0FGF | 42
| 42 | OK2CQR-1 | 27 | 14 | 27
| 14 | NULL | NULL | 94.23.250.107 |</tt><tt><br>
</tt><tt>| 12 | 14210 | OH6STAYHOME | 1591459080 | strong in
uk | 2E0GLN | 130 | 61 |
HA6DX | 18 | 15 | 27 | 14 | NULL
| NULL | NULL |</tt><tt><br>
</tt><tt>| 13 | 7071 | EA3IIH | 1591459080 | dipl.dia
mundial medio ambiente | EA3IAZ | 34 | 34 |
WA9PIE-2 | 37 | 14 | 37 | 14 | NULL
| NULL | 147.161.123.183 |</tt><tt><br>
</tt><tt>+-------+---------+--------------+------------+---------------------------------+---------+----------+-------------+----------+---------+--------+------------+-----------+-----------+--------------+-----------------+</tt><br>
<br>
Now, I did find a small issue with the code but that only affected
reading the database, not inserting new spots. <br>
<br>
Please could you check that you are getting PC61 spots as well as
PC11. Only the PC61 spots contain the IP addresses, e.g:<br>
<br>
<tt><- I GB7DJK PC11^14188.0^4S7JL/MM^6-Jun-2020^1615Z^now CQ
By numbers !!^MI0SAI^N0VD-7^H98^~</tt><tt><br>
</tt><tt><br>
</tt><tt><- I GB7DJK PC61^50313.00^OH7KM^06-Jun-2020^1615Z^FT8
-7 +269hz KP11 CQ DX^WW1L^VE7CC-1^67.255.65.68^H95^~</tt><tt><br>
</tt><tt><br>
</tt><tt><- I GB7DJK PC61^50313.00^OH3SR^06-Jun-2020^1615Z^FT8
-13 +1789hz KP21^WW1L^VE7CC-1^67.255.65.68^H95^~</tt><tt><br>
</tt><br>
If you want a reliable source of PC61 then you can connect to
gb7djk.dxcluster.net 7300 and get them there. I have set you up on
-2 and -3 as a node. <br>
<br>
Dirk G1TLH<br>
<br>
On 05/06/2020 22:55, JMarcio S via Dxspider-support wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANSj2WK+X_Pw6LJjx584csiD_x6nBGh4QJt41EEJnfXRSsi-ew@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">Hi Dirk,<span style="white-space:pre-wrap"> </span></p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""> 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! <span> </span></p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">I'm running on a VM (Digital Ocean), with very
little RAM and CPU used.</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">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).</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">To populate the MySQL database, I configure
DXVARS, I don't write code for this, only dxspider package.</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""># the SQL database DBI dsn</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">$dsn = "dbi:mysql:dxcluster:xxx.xxx.xxx.xx:yyyy”;</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">$dbuser = “xxxxx”;</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">$dbpass = “xxxxxxx”x;</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">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).</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">all of these fields are loaded normally when using
node version 155, build 0.204</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">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.<span> </span></p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""><span style="white-space:pre-wrap"> </span>I'm not
sure if I found the right information. I started 'watchdbg'
and the result was:<span> </span></p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">version 1.57/252</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">09:34:23 (chan) <- I PY4OG-2
PC92^DH1TW-2^34462^A^^7K1TTT-1:208.125.133.190^H93^</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">09:34:23 (chan) <- I PY4OG-2
PC92^IW1QLH-6^34462^A^^7JG1VGX-8:3.115.254.10^H94^</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">09:34:46 (chan) <- I PY4OG-2
PC11^70154.0^OK2BRD^ 5-Jun-2020^0934Z^<ES></p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">version 155/0204</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">09:40:24 -> D PY4OG-4
PC92^F4BWT-3^34824^D^^5F6BVP-3^H93^</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">09:40:24 -> D PY3NZ-8
PC92^F4BWT-3^34824^D^^5F6BVP-3^H93^</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue"">09:40:24 <- I WB3FFV-2 PC41^IW2CLM^1^Dome^H29^~</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue";min-height:14px"> 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.<span> </span><br>
</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""><span style="white-space:pre-wrap"> </span>To send
spots I use Telnet tcp/socket via standard dxspider, ipaddr is
correct.</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""><span style="white-space:pre-wrap"> </span>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.</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""> thank you again</p>
<p
style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:"Helvetica
Neue""> 73 J.Marcio PY4OG</p>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Em qua., 3 de jun. de 2020 às
09:10, Dirk Koopman via Dxspider-support <<a
href="mailto:dxspider-support@tobit.co.uk" target="_blank"
moz-do-not-send="true">dxspider-support@tobit.co.uk</a>>
escreveu:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>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".<br>
<br>
My changes are just concerned with searching, not spot
storage. <br>
<br>
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).<br>
<br>
It would be interesting to compare the output of this:<br>
<br>
<tt> grepdbg 'I [-\w]+ PC[61]1'</tt><br>
<br>
to a SQL query. <br>
<br>
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 <u>node has not been updated since at
least 2012</u>!<br>
<br>
Back to the point:<br>
<br>
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. <br>
<br>
<tt>sub add</tt><tt><br>
</tt><tt>{</tt><tt><br>
</tt><tt> my $buf = join('^', @_);</tt><tt><br>
</tt><tt> $fp->writeunix($_[2], $buf);</tt><tt><br>
</tt><tt> if ($main::dbh) {</tt><tt><br>
</tt><tt> $main::dbh->begin_work;</tt><tt><br>
</tt><tt> $main::dbh->spot_insert(\@_);</tt><tt><br>
</tt><tt> $main::dbh->commit;</tt><tt><br>
</tt><tt> }</tt><tt><br>
</tt><tt> $totalspots++;</tt><tt><br>
</tt><tt> if ($_[0] <= 30000) {</tt><tt><br>
</tt><tt> $hfspots++;</tt><tt><br>
</tt><tt> } else {</tt><tt><br>
</tt><tt> $vhfspots++;</tt><tt><br>
</tt><tt> }</tt><tt><br>
</tt><tt> if ($_[3] =~ /(?:QSL|VIA)/i) {</tt><tt><br>
</tt><tt> my $q = QSL::get($_[1]) || new QSL $_[1];</tt><tt><br>
</tt><tt> $q->update($_[3], $_[2], $_[4]);</tt><tt><br>
</tt><tt> }</tt><tt><br>
</tt><tt>}<br>
<br>
</tt>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.<br>
<br>
73 Dirk G1TLH<br>
<br>
On 03/06/2020 02:43, JMarcio S via Dxspider-support wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr"> Hi Dirk
<div> The ipaddr in the Mysql database is null, after
Mojo. Any format changes? current is: VARCHAR 40.
(running DXSpider V1.57 build 252).<br clear="all">
<div> Thank you again</div>
<div><br>
</div>
<div dir="ltr">
<div dir="ltr">J.Marcio PY4OG</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Dxspider-support mailing list
<a href="mailto:Dxspider-support@tobit.co.uk" target="_blank" moz-do-not-send="true">Dxspider-support@tobit.co.uk</a>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank" moz-do-not-send="true">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Dxspider-support mailing list<br>
<a href="mailto:Dxspider-support@tobit.co.uk" target="_blank"
moz-do-not-send="true">Dxspider-support@tobit.co.uk</a><br>
<a
href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">
<div dir="ltr">J.Marcio</div>
</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>