GitHub - magicbug/DX-Cluster-to-SQL: Perl script that connects to the Ham Radio DX Cluster via Telnet and adds spots to MySQL

magicbug / DX-Cluster-to-SQL Public

Notifications You must be signed in to change notification settings
Fork 3
Star 7

Perl script that connects to the Ham Radio DX Cluster via Telnet and adds spots to MySQL

www.dxcluster.co.uk

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
Monitoring Scripts		Monitoring Scripts
README		README
dx tables.sql		dx tables.sql
spotsucker.pl		spotsucker.pl

Repository files navigation

Spots SQL Schema

CREATE TABLE `spots` (
  `nr` bigint(20) NOT NULL AUTO_INCREMENT,
  `call` varchar(12) NOT NULL DEFAULT '',
  `freq` float unsigned NOT NULL DEFAULT '0',
  `dxcall` varchar(12) NOT NULL DEFAULT '',
  `comment` varchar(30) NOT NULL DEFAULT '',
  `time` datetime NOT NULL,
  `band` float NOT NULL DEFAULT '0',
  `dx_prefix` varchar(10) NOT NULL,
  `dx_name` varchar(150) NOT NULL,
  `dx_cqz` float NOT NULL,
  `dx_ituz` float NOT NULL,
  `dx_cont` varchar(5) NOT NULL,
  `dx_long` float NOT NULL,
  `dx_lat` float NOT NULL,
  `spotter_prefix` varchar(10) NOT NULL,
  `spotter_name` varchar(150) NOT NULL,
  `spotter_cqz` float NOT NULL,
  `spotter_ituz` float NOT NULL,
  `spotter_cont` varchar(5) NOT NULL,
  `spotter_long` float NOT NULL,
  `spotter_lat` float NOT NULL,
  PRIMARY KEY (`nr`),
  KEY `dxcall` (`dxcall`),
  KEY `time` (`time`,`band`),
  KEY `freq` (`freq`),
  KEY `band` (`band`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

to run the automation script use a cron.

00 */2 * * * /bin/bash /usr/home/bwirel/public_html/dxcluster/start-spotsucker.sh