<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>The CREATE TABLE goes in error on my Server version:
10.5.12-MariaDB-0+deb11u1 Debian 11 <br>
</p>
<p>
<blockquote type="cite">ERROR 1064 (42000): You have an error in
your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near ''spot'
( 'rowid' int(11) NOT NULL AUTO_INCREMENT, 'freq' double NOT
NULL, 'sp...' at line 1<br>
</blockquote>
I have worked around it and found that it doesn't like sigle
hyphen *'* but want the backtick *`*.</p>
<p>Now I have created the table and i have rebooted but DxSpider
cannot still access to MariaDB.</p>
<p>
<blockquote type="cite">DBI
connect('dxcluster:localhost:3306','sysop',...) failed: Access
denied for user 'sysop'@'localhost' (using password: YES) at
/spider/perl/DXSql.pm line 63.</blockquote>
I've changed the DBI setup params into old parameters file (not
Mojo branch)<br>
</p>
<p>
<blockquote type="cite">
<pre>spider/local/DXVars.pm</pre>
</blockquote>
and (1) access don't have error and (2) table can be populated.</p>
<p>I think that this feature in MOJO branch still point to old
DXVars.pm path.</p>
<p>[SOLVED]</p>
<p>Thanks guys for your suggests.</p>
<pre>73 de Leo IZ5FSA
</pre>
<p><br>
</p>
<div class="moz-cite-prefix">Il 25/03/2022 09:03, Danilo Brelih via
Dxspider-support ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:113485375.9717274.1648195402184.JavaMail.zimbra@users.siol.net">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div style="font-family: arial,helvetica,sans-serif; font-size:
12pt; color: #000000">
<div><br data-mce-bogus="1">
</div>
<div>If I remember correctly DXSpider doesn't create database
itself. Try creating database manually first.</div>
<div><br data-mce-bogus="1">
</div>
<div>- Create database with:</div>
<div><br data-mce-bogus="1">
</div>
<div><span style="color: #24292f; font-family: ui-monospace,
SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation
Mono', monospace; font-size: 13.6px; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: left; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgba(175,
184, 193, 0.2); text-decoration-thickness: initial;
text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"
data-mce-style="color: #24292f; font-family: ui-monospace,
SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation
Mono', monospace; font-size: 13.6px; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: left; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgba(175,
184, 193, 0.2); text-decoration-thickness: initial;
text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"> CREATE
DATABASE dxspider;</span></div>
<div><br data-mce-bogus="1">
</div>
<div>- Give right privilages to the user you are using for
dxspider with:</div>
<div><code style="box-sizing: border-box; font-family:
ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas,
'Liberation Mono', monospace; font-size: 13.6px; padding:
0.2em 0.4em; margin: 0px; background-color:
var(--color-neutral-muted); border-radius: 6px; color:
#24292f; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial;"
data-mce-style="box-sizing: border-box; font-family:
ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas,
'Liberation Mono', monospace; font-size: 13.6px; padding:
0.2em 0.4em; margin: 0px; background-color:
var(--color-neutral-muted); border-radius: 6px; color:
#24292f; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial;"><br
data-mce-bogus="1">
</code></div>
<div><code style="box-sizing: border-box; font-family:
ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas,
'Liberation Mono', monospace; font-size: 13.6px; padding:
0.2em 0.4em; margin: 0px; background-color:
var(--color-neutral-muted); border-radius: 6px; color:
#24292f; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial;"
data-mce-style="box-sizing: border-box; font-family:
ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas,
'Liberation Mono', monospace; font-size: 13.6px; padding:
0.2em 0.4em; margin: 0px; background-color:
var(--color-neutral-muted); border-radius: 6px; color:
#24292f; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial;">GRANT ALL
PRIVILEGES ON dxspider.* to 'sysop'@'localhost';</code></div>
<div><br data-mce-bogus="1">
</div>
<div>- Creating table with:</div>
<div><br data-mce-bogus="1">
</div>
<div><span style="color: #24292f; font-family: -apple-system,
BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial,
sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;" data-mce-style="color: #24292f; font-family:
-apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica,
Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;">CREATE TABLE 'spot' ( 'rowid' int(11) NOT NULL
AUTO_INCREMENT, 'freq' double NOT NULL, 'spotcall'
varchar(14) NOT NULL, 'time' int(11) NOT NULL, 'comment'
varchar(255) DEFAULT NULL, 'spotter' varchar(14) NOT NULL,
'spotdxcc' smallint(6) DEFAULT NULL, 'spotterdxcc'
smallint(6) DEFAULT NULL, 'origin' varchar(14) DEFAULT NULL,
'spotitu' tinyint(4) DEFAULT NULL, 'spotcq' tinyint(4)
DEFAULT NULL, 'spotteritu' tinyint(4) DEFAULT NULL,
'spottercq' tinyint(4) DEFAULT NULL, 'spotstate' char(2)
DEFAULT NULL, 'spotterstate' char(2) DEFAULT NULL, 'ipaddr'
varchar(40) DEFAULT NULL, PRIMARY KEY ('rowid'), KEY
'spot_ix1' ('time'), KEY 'spot_ix2' ('spotcall'), KEY
'spiderweb_spotter' ('spotter') ) ENGINE=InnoDB
AUTO_INCREMENT=2598318 DEFAULT CHARSET=utf8mb4</span></div>
<div><br>
</div>
<div><span style="color: #24292f; font-family: -apple-system,
BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial,
sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;" data-mce-style="color: #24292f; font-family:
-apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica,
Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;"><span style="color: #000000; font-family:
arial, helvetica, sans-serif; font-size: 16px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform:
none; white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;" data-mce-style="color: #000000;
font-family: arial, helvetica, sans-serif; font-size:
16px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;">Reboot.</span></span></div>
<div><span style="color: #24292f; font-family: -apple-system,
BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial,
sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;" data-mce-style="color: #24292f; font-family:
-apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica,
Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;"><span style="color: #000000; font-family:
arial, helvetica, sans-serif; font-size: 16px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform:
none; white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;" data-mce-style="color: #000000;
font-family: arial, helvetica, sans-serif; font-size:
16px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;"><br data-mce-bogus="1">
</span></span></div>
<div><span style="color: #24292f; font-family: -apple-system,
BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial,
sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;" data-mce-style="color: #24292f; font-family:
-apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica,
Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji';
font-size: 16px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: #ffffff; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial; display: inline !important;
float: none;"><span style="color: #000000; font-family:
arial, helvetica, sans-serif; font-size: 16px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform:
none; white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;" data-mce-style="color: #000000;
font-family: arial, helvetica, sans-serif; font-size:
16px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;">GL Dan, S50U</span></span></div>
<div><br>
</div>
<div><br>
</div>
<span id="zwchr" data-marker="__DIVIDER__">----- Dne 25. Mar.
2022 ob 07:55 je The DXSpider Support list
<a class="moz-txt-link-rfc2396E" href="mailto:dxspider-support@tobit.co.uk"><dxspider-support@tobit.co.uk></a> napisal(a):<br>
</span>
<div data-marker="__QUOTED_TEXT__">
<blockquote style="border-left: 2px solid #1010FF;
margin-left: 5px; padding-left: 5px; color: #000;
font-weight: normal; font-style: normal; text-decoration:
none; font-family: Helvetica,Arial,sans-serif; font-size:
12pt;" data-mce-style="border-left: 2px solid #1010FF;
margin-left: 5px; padding-left: 5px; color: #000;
font-weight: normal; font-style: normal; text-decoration:
none; font-family: Helvetica,Arial,sans-serif; font-size:
12pt;">Nope... error still remain the same.<br>
<br>
Is there a documentation around the mysql/sqlite dxspider
support?<br>
<br>
reading source all seems to be nice...<br>
<br>
<br>
Il 25/03/2022 00:20, Dirk Koopman via Dxspider-support ha
scritto:<br>
> Try changing the $dsn strings to be the same (i.e. lose
the ':3306').<br>
><br>
> On 24/03/2022 23:04, IZ5FSA via Dxspider-support wrote:<br>
>> Hi OMs,<br>
>><br>
>> I have this error on access to MariaDB.<br>
>><br>
>>> DBI
connect('dxcluster:localhost:3306','sysop',...) failed:
Access <br>
>>> denied for user 'sysop'@'localhost' (using
password: YES ) at <br>
>>> /spider/perl/DXSql.pm line 63.<br>
>> In /spider/local-new/DXVars.pm I have:<br>
>><br>
>>> # the SQL database DBI dsn<br>
>>> #$dsn =
"dbi:SQLite:dbname=$root/data/dxspider.db";<br>
>>> #$dbuser = "";<br>
>>> #$dbpass = "";<br>
>>><br>
>>> # the SQL database DBI dsn<br>
>>> $dsn = "dbi:mysql:dxcluster:localhost:3306";<br>
>>> $dbuser = "sysop";<br>
>>> $dbpass = "MyPassword";<br>
>> In MariaDB the user "sysop" have grant full access
to the dxcluster <br>
>> database.<br>
>><br>
>><br>
>> If I use this script, access is fine...<br>
>><br>
>>> #!/usr/bin/perl<br>
>>><br>
>>> use DBI;<br>
>>><br>
>>> $source = "DBI:mysql:dxcluster:localhost";<br>
>>> $username = "sysop";<br>
>>> $password = "MyPassword";<br>
>>><br>
>>> $dbc = DBI->connect($source, $username,
$password)<br>
>>> or die "Unable to connect to mysql:
$DBI::errstr\n";<br>
>>><br>
>>> $sql = $dbc->prepare("SELECT count(*) FROM
spot_backup");<br>
>>><br>
>>> $out = $sql->execute()<br>
>>> or die "Unable to execute sql:
$sql->errstr";<br>
>>><br>
>>> while (($id, $name) =
$sql->fetchrow_array())<br>
>>> {<br>
>>> print "Id: $id Name: $name\n";<br>
>>> }<br>
>> ...and obviously it return<br>
>><br>
>>> Id: 0 Name:<br>
>> because table is empty.<br>
>><br>
>> I cannot find any documentation of this DBI feature
in docs.<br>
>><br>
>> Where is the trick? In the MariaDB parameters?
Anyone have tryed this <br>
>> kind of error?<br>
>><br>
>> best 73 de Leo IZ5FSA<br>
>><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> Dxspider-support mailing list<br>
>> <a class="moz-txt-link-abbreviated" href="mailto:Dxspider-support@tobit.co.uk">Dxspider-support@tobit.co.uk</a><br>
>>
<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><br>
><br>
><br>
> _______________________________________________<br>
> Dxspider-support mailing list<br>
> <a class="moz-txt-link-abbreviated" href="mailto:Dxspider-support@tobit.co.uk">Dxspider-support@tobit.co.uk</a><br>
>
<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><br>
<br>
_______________________________________________<br>
Dxspider-support mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Dxspider-support@tobit.co.uk">Dxspider-support@tobit.co.uk</a><br>
<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><br>
</blockquote>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></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>
</body>
</html>