Bravo List
Register
Go Back   > Bravo List > Source Code > Active Trackers > Project U-232
Reply
  #1  
Old 27th July 2019, 10:16
dj dan's Avatar
dj dan dj dan is offline
Member
 
Join Date: Aug 2014
Posts: 1
Default u232 install
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
Reply With Quote
  #2  
Old 30th July 2019, 22:57
antimidas's Avatar
antimidas antimidas is offline
Senior Member
 
Join Date: Mar 2011
United States
Posts: 64
Default
Quote:
Originally Posted by dj dan View Post
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
Are you trying to use MySQL 5.7+?? and did you check xbt in the install? May need to import the xbt tables from install files. If you are running mysql 5.7, you need to remove and install mariadb or mysql 5.6 or lower.
Reply With Quote
  #3  
Old 30th July 2019, 23:35
son's Avatar
son son is offline
VIP
 
Join Date: Dec 2015
P2P
Posts: 48
Default
hi, just a shot in the dark, did you setup xb==>+c++
Reply With Quote
  #4  
Old 2nd August 2019, 09:36
Napon's Avatar
Napon Napon is offline
Banned
 
Join Date: Feb 2016
P2P
Posts: 525
Default
why run xbt_trackeryou do know its for a very full site with seeds and leachs oh and xbt_tracker as never been working on tdv
Reply With Quote
  #5  
Old 2nd August 2019, 14:23
z3ro's Avatar
z3ro z3ro is offline
Senior Member
 
Join Date: Oct 2010
P2P
Posts: 119
Default
Quote:
Originally Posted by dj dan View Post
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
rehearse

ssh winscp open

1. edit xbt_tracker.conf
2. upload xbt for example home folder
3. chmod 777 xbt_tracker.conf and make.sh
4. ssh open putty
5. cd /home/xbt/Tracker
6. ./make.sh
7. ./xbt_tracker ( its good mysql 5.5 ) php verzion 7.0 or more
Attached Files
File Type: gz xbt.tar.gz (88.3 KB, 3 views)
Reply With Quote
  #6  
Old 2nd August 2019, 15:39
Stortebeker's Avatar
Stortebeker Stortebeker is offline
Member
 
Join Date: May 2019
Posts: 8
Default
Quote:
Originally Posted by dj dan View Post
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;

Last edited by Stortebeker; 2nd August 2019 at 15:49.
Reply With Quote
  #7  
Old 2nd August 2019, 20:33
z3ro's Avatar
z3ro z3ro is offline
Senior Member
 
Join Date: Oct 2010
P2P
Posts: 119
Default
no no xbt table import V4 and V5 verzion

Last edited by Thor; 8th August 2019 at 11:03. Reason: Don't Quote a Post that's directly above, use the Reply button instead.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 09:06. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2020, vBulletin Solutions Inc.