[Dxspider-support] Assistance with Setup

[Danilo Brelih]

Michael Serowik via Dxspider-support je 10.10.2024 ob 16:53 napisal:
>
> Sorry for long post but wanted to give as much information as I can.
>
Have you tried to create database manually?

- as sysop (not root !) create the database. From mysql console: |CREATE 
DATABASE dxcluster;

|- give the right privileges to the user you are using for dxspider. For 
example: |GRANT ALL PRIVILEGES ON dxcluster.* to 'sysop'@'localhost';|

- create spot table with following command:

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

- reboot your system

73, Dan S50U

-- 
S50CLX DX Cluster <https://s50clx.infrax.si>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20241010/03de883e/attachment.htm>