<div dir="ltr"><div><br></div>Thanks for testing on an SQL database, it worked fine!<div>This is not an error in MySq DB!<br>I'm not getting PC-61, just points PC92 -11 - 41 - 93 on node PY4OG-4 (mojo 1.57), this node is connected to PY4OG-2 (V1.55 build 0.215), the last node gets the spots type PC-61, but does not send PC61 to PY4OG-4 (mojo). see below the same spots.<div>-------------------------------------------------------------<br><div>node PY4OG-2 DXSpider V1.55 build 0.215 <br><div>
<p class="gmail-p1" 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"">22:56:25 <- I GB7DJK PC61^7027.0^W2I/STAYHOME^ 6-Jun-2020^2256Z^CW^GM0OPS^GB7DJK^86.185.254.194^H15^~</p>
<p class="gmail-p1" 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"">22:56:25 -> D WB3FFV-2 PC61^7027.0^W2I/STAYHOME^ 6-Jun-2020^2256Z^CW^GM0OPS^GB7DJK^86.185.254.194^H14^~</p>
<p class="gmail-p1" 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"">22:56:25 -> D PY3NZ-8 PC61^7027.0^W2I/STAYHOME^ 6-Jun-2020^2256Z^CW^GM0OPS^GB7DJK^86.185.254.194^H14^~</p>
<p class="gmail-p1" 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"">22:56:25 -> D PY4OG-4 PC11^7027.0^W2I/STAYHOME^ 6-Jun-2020^2256Z^CW^GM0OPS^GB7DJK^H14</p>
<p class="gmail-p1" 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"">22:56:25 <- I WB3FFV-2 PC61^7027.0^W2I/STAYHOME^ 6-Jun-2020^2256Z^CW^GM0OPS^GB7DJK^86.185.254.194^H13^~</p>
<p class="gmail-p2" 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">-------------------------------------------------------</p><p class="gmail-p2" 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">NODE PY4OG-4 (mojo 1.57 build 258) set/node PY4OG-2</p>
<p class="gmail-p1" 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"">22:56:25 (chan) <- I PY4OG-2 PC11^7027.0^W2I/STAYHOME^ 6-Jun-2020^2256Z^CW^GM0OPS^GB7DJK^H14</p><p class="gmail-p1" 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"">-------------------------------------------------------</p>You're right! PC61, but where did I go wrong? Any configuration?</div><div><br></div><div>..."you can connect to <a href="http://gb7djk.dxcluster.net/" target="_blank">gb7djk.dxcluster.net</a> 7300 and get them there. I have set you up on -2 and -3 as a node" </div><div>Please could you change py4og-3 to py4og-4 on your node?</div><div><br>I will try to install DXSpider from scratch!<br>Good weekend and thanks for helping.<br><div>PY4OG J.Marcio</div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em sáb., 6 de jun. de 2020 às 13:20, Dirk Koopman via Dxspider-support <<a href="mailto:dxspider-support@tobit.co.uk">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>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
<a href="http://gb7djk.dxcluster.net" target="_blank">gb7djk.dxcluster.net</a> 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">
<div dir="ltr">
<p>Hi Dirk,<span style="white-space:pre-wrap"> </span></p>
<p> 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>I'm running on a VM (Digital Ocean), with very
little RAM and CPU used.</p>
<p>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>To populate the MySQL database, I configure
DXVARS, I don't write code for this, only dxspider package.</p>
<p># the SQL database DBI dsn</p>
<p>$dsn = "dbi:mysql:dxcluster:xxx.xxx.xxx.xx:yyyy”;</p>
<p>$dbuser = “xxxxx”;</p>
<p>$dbpass = “xxxxxxx”x;</p>
<p>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>all of these fields are loaded normally when using
node version 155, build 0.204</p>
<p>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><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>version 1.57/252</p>
<p>09:34:23 (chan) <- I PY4OG-2
PC92^DH1TW-2^34462^A^^7K1TTT-1:208.125.133.190^H93^</p>
<p>09:34:23 (chan) <- I PY4OG-2
PC92^IW1QLH-6^34462^A^^7JG1VGX-8:3.115.254.10^H94^</p>
<p>09:34:46 (chan) <- I PY4OG-2
PC11^70154.0^OK2BRD^ 5-Jun-2020^0934Z^<ES></p>
<p>version 155/0204</p>
<p>09:40:24 -> D PY4OG-4
PC92^F4BWT-3^34824^D^^5F6BVP-3^H93^</p>
<p>09:40:24 -> D PY3NZ-8
PC92^F4BWT-3^34824^D^^5F6BVP-3^H93^</p>
<p>09:40:24 <- I WB3FFV-2 PC41^IW2CLM^1^Dome^H29^~</p>
<p> 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><span style="white-space:pre-wrap"> </span>To send
spots I use Telnet tcp/socket via standard dxspider, ipaddr is
correct.</p>
<p><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> thank you again</p>
<p> 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">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">Dxspider-support@tobit.co.uk</a>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">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">Dxspider-support@tobit.co.uk</a><br>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" rel="noreferrer" target="_blank">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></fieldset>
<pre>_______________________________________________
Dxspider-support mailing list
<a href="mailto:Dxspider-support@tobit.co.uk" target="_blank">Dxspider-support@tobit.co.uk</a>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">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">Dxspider-support@tobit.co.uk</a><br>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" rel="noreferrer" target="_blank">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr">J.Marcio</div></div>