Stortebeker |
2nd August 2019 15:39 |
Quote:
Originally Posted by dj dan
(Post 53930)
Hi guys just installing u232 only got as far as starting xbt_tracker
Ive added my mysql connect details to xbt_tracker.config but when i run
./xbt_tracker
this is the outcome
Table '******_*****.xbt_config' doesn't exist
select name, value from xbt_config where value is not null
Table '******_*****.xbt_config' doesn't exist
select name, value from xbt_config where 0
dont think ive missed anything anhy help would be great thanks
|
You dont have the tables in database . Don't bother to reinstall xbt just import this tables in your sql:
Code:
--
-- Table structure for table `xbt_announce_log`
--
CREATE TABLE IF NOT EXISTS `xbt_announce_log` (
`id` int(11) NOT NULL,
`ipa` int(10) unsigned NOT NULL DEFAULT '0',
`port` int(11) NOT NULL DEFAULT '0',
`event` int(11) NOT NULL DEFAULT '0',
`info_hash` blob NOT NULL,
`peer_id` blob NOT NULL,
`downloaded` bigint(20) NOT NULL,
`left0` bigint(20) NOT NULL,
`uploaded` bigint(20) NOT NULL,
`uid` int(11) NOT NULL DEFAULT '0',
`mtime` int(11) NOT NULL DEFAULT '0',
`useragent` varchar(51) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `xbt_client_whitelist`
--
CREATE TABLE IF NOT EXISTS `xbt_client_whitelist` (
`id` int(10) UNSIGNED NOT NULL,
`peer_id` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`vstring` varchar(200) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `xbt_client_whitelist`
--
INSERT INTO `xbt_client_whitelist` (`id`, `peer_id`, `vstring`) VALUES
(1, '-', 'all');
-- --------------------------------------------------------
--
-- Table structure for table `xbt_config`
--
CREATE TABLE IF NOT EXISTS `xbt_config` (
`name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`value` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `xbt_config`
--
INSERT INTO `xbt_config` (`name`, `value`) VALUES
('torrent_pass_private_key', 'MG58LNj5LHHz49A9PKhAkxIH8Aa');
-- --------------------------------------------------------
--
-- Table structure for table `xbt_deny_from_hosts`
--
CREATE TABLE IF NOT EXISTS `xbt_deny_from_hosts` (
`begin` int(11) NOT NULL,
`end` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `xbt_files`
--
CREATE TABLE IF NOT EXISTS `xbt_files` (
`fid` int(11) NOT NULL,
`info_hash` blob NOT NULL,
`leechers` int(11) NOT NULL DEFAULT '0',
`seeders` int(11) NOT NULL DEFAULT '0',
`completed` int(11) NOT NULL DEFAULT '0',
`announced_http` int(11) NOT NULL DEFAULT '0',
`announced_http_compact` int(11) NOT NULL DEFAULT '0',
`announced_http_no_peer_id` int(11) NOT NULL DEFAULT '0',
`announced_udp` int(11) NOT NULL DEFAULT '0',
`scraped_http` int(11) NOT NULL DEFAULT '0',
`scraped_udp` int(11) NOT NULL DEFAULT '0',
`started` int(11) NOT NULL DEFAULT '0',
`stopped` int(11) NOT NULL DEFAULT '0',
`flags` int(11) NOT NULL DEFAULT '0',
`mtime` int(11) NOT NULL DEFAULT '0',
`ctime` int(11) NOT NULL DEFAULT '0',
`balance` int(11) NOT NULL DEFAULT '0',
`freetorrent` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `xbt_files_users`
--
CREATE TABLE IF NOT EXISTS `xbt_files_users` (
`fid` int(11) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
`active` tinyint(4) NOT NULL DEFAULT '0',
`announced` int(11) NOT NULL DEFAULT '0',
`completed` int(11) NOT NULL DEFAULT '0',
`downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`left` bigint(20) unsigned NOT NULL DEFAULT '0',
`uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`mtime` int(11) NOT NULL DEFAULT '0',
`leechtime` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`seedtime` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`upspeed` int(10) unsigned NOT NULL DEFAULT '0',
`downspeed` int(10) unsigned NOT NULL DEFAULT '0',
`peer_id` char(8) COLLATE utf8_unicode_ci NOT NULL,
`completedtime` int(11) unsigned NOT NULL DEFAULT '0',
`ipa` int(11) unsigned NOT NULL DEFAULT '0',
`connectable` tinyint(4) NOT NULL DEFAULT '1',
`mark_of_cain` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`hit_and_run` int(11) NOT NULL DEFAULT '0',
`started` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DEFAULT;
-- --------------------------------------------------------
--
-- Table structure for table `xbt_scrape_log`
--
CREATE TABLE IF NOT EXISTS `xbt_scrape_log` (
`id` int(11) NOT NULL,
`ipa` int(11) NOT NULL,
`info_hash` blob,
`uid` int(11) NOT NULL,
`mtime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|