<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">Michael Serowik via Dxspider-support je
10.10.2024 ob 16:53 napisal:<br>
</div>
<blockquote type="cite"
cite="mid:000201db1b24$360ac650$a22052f0$@verizon.net">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator"
content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Aptos;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Sorry for long post but wanted to give as
much information as I can.</p>
</div>
</blockquote>
<p>Have you tried to create database manually?</p>
<p>- as sysop (not root !) create the database. From mysql console:
<code>CREATE DATABASE dxcluster;<br>
<br>
</code>- give the right privileges to the user you are using for
dxspider.
For example:
<code>GRANT ALL PRIVILEGES ON dxcluster.* to 'sysop'@'localhost';</code></p>
<p>- create spot table with following command: </p>
<p>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</p>
<p>- reboot your system<br>
</p>
<p>73, Dan S50U</p>
<div class="moz-signature">-- <br>
<a href="https://s50clx.infrax.si">S50CLX DX Cluster</a></div>
</body>
</html>