<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">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>