HTML-PHP-Java-Perl Flux auf Server installieren

[Hailogugo]

Guten Tag,

ich bin momentan damit beschäftigt mein Flux b4rt auf einen neuen Server zu installieren. Leider bekomme ich bei der Anlegung der Datenbank durch den Installationsskript eine Fehlermeldung.

Fehlermeldung ist die folgende:

Spoiler

Database - Creation + Test - MySQL

The installation will now try to connect to the database server,
create a new database if applicable and run some tests to check we can
create tables in the database.



Query Error:
CREATE TABLE tf_test (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) TYPE=MyISAM


Error:

Ich habe bereits in anderen Foren mich umgehört und habe dort gelesen das man alle Type=MyISAM auf Engine=MyISAM ändern soll.
Das half nun auch noch nicht ganz außer das ich, wenn ich über den Webassistenten der Datenbaq die SQL Datei einfüge das er alles annimmt.
Aber der Installationsskript funktioniert dann noch nicht.


Hier meine geänderte SQL Datei

Spoiler

-- -----------------------------------------------------------------------------

-- $Id: mysql_torrentflux-b4rt-1.0.sql 1504 2006-11-07 14:34:11Z b4rt $
-- -----------------------------------------------------------------------------

--

-- MySQL-File for 'torrentflux-b4rt-1.0'.

--

-- This Stuff is provided 'as-is'. In no way will the authors be held

-- liable for any damages to your soft- or hardware from this.

-- -----------------------------------------------------------------------------



--

-- tf_cookies

--

CREATE TABLE tf_cookies (

cid int(5) NOT NULL auto_increment,

uid int(10) NOT NULL default '0',

host VARCHAR(255) default NULL,

data VARCHAR(255) default NULL,

PRIMARY KEY (cid)

) ENGINE=MyISAM;



--

-- tf_links

--

CREATE TABLE tf_links (

lid int(10) NOT NULL auto_increment,

url VARCHAR(255) NOT NULL default '',

sitename VARCHAR(255) NOT NULL default 'Old Link',

sort_order TINYINT(3) UNSIGNED default '0',

PRIMARY KEY (lid)

) ENGINE=MyISAM;



INSERT INTO tf_links VALUES (NULL,'http://tf-b4rt.berlios.de/','tf-b4rt','0');



--

-- tf_log

--

CREATE TABLE tf_log (

cid int(14) NOT NULL auto_increment,

user_id VARCHAR(32) NOT NULL default '',

file VARCHAR(200) NOT NULL default '',

action VARCHAR(200) NOT NULL default '',

ip VARCHAR(15) NOT NULL default '',

ip_resolved VARCHAR(200) NOT NULL default '',

user_agent VARCHAR(200) NOT NULL default '',

time VARCHAR(14) NOT NULL default '0',

PRIMARY KEY (cid)

) ENGINE=MyISAM;



--

-- tf_messages

--

CREATE TABLE tf_messages (

mid int(10) NOT NULL auto_increment,

to_user VARCHAR(32) NOT NULL default '',

from_user VARCHAR(32) NOT NULL default '',

message TEXT,

IsNew int(11) default NULL,

ip VARCHAR(15) NOT NULL default '',

time VARCHAR(14) NOT NULL default '0',

force_read TINYINT(1) default '0',

PRIMARY KEY (mid)

) ENGINE=MyISAM;



--

-- tf_rss

--

CREATE TABLE tf_rss (

rid int(10) NOT NULL auto_increment,

url VARCHAR(255) NOT NULL default '',

PRIMARY KEY (rid)

) ENGINE=MyISAM;



--

-- tf_users

--

CREATE TABLE tf_users (

uid int(10) NOT NULL auto_increment,

user_id VARCHAR(32) NOT NULL default '',

password VARCHAR(34) NOT NULL default '',

hits int(10) NOT NULL default '0',

last_visit VARCHAR(14) NOT NULL default '0',

time_created VARCHAR(14) NOT NULL default '0',

user_level TINYINT(1) NOT NULL default '0',

hide_offline TINYINT(1) NOT NULL default '0',

theme VARCHAR(100) NOT NULL default 'default',

language_file VARCHAR(60) default 'lang-english.php',

state TINYINT(1) NOT NULL default '1',

PRIMARY KEY (uid)

) ENGINE=MyISAM;



--

-- tf_torrents

--

CREATE TABLE tf_torrents (

torrent VARCHAR(255) NOT NULL default '',

running ENUM('0','1') NOT NULL default '0',

rate SMALLINT(4) NOT NULL default '0',

drate SMALLINT(4) NOT NULL default '0',

maxuploads TINYINT(3) unsigned NOT NULL default '0',

superseeder ENUM('0','1') NOT NULL default '0',

runtime ENUM('True','False') NOT NULL default 'False',

sharekill SMALLINT(4) unsigned NOT NULL default '0',

minport SMALLINT(5) unsigned NOT NULL default '0',

maxport SMALLINT(5) unsigned NOT NULL default '0',

maxcons SMALLINT(4) unsigned NOT NULL default '0',

savepath VARCHAR(255) NOT NULL default '',

btclient VARCHAR(32) NOT NULL default 'tornado',

hash VARCHAR(40) DEFAULT '' NOT NULL,

datapath VARCHAR(255) NOT NULL default '',

PRIMARY KEY (torrent)

) ENGINE=MyISAM;



--

-- tf_trprofiles

--

CREATE TABLE tf_trprofiles (

id MEDIUMINT(8) NOT NULL auto_increment,

name VARCHAR(255) NOT NULL default '',

owner INT(10) NOT NULL default '0',

public ENUM('0','1') NOT NULL default '0',

rate SMALLINT(4) NOT NULL default '0',

drate SMALLINT(4) NOT NULL default '0',

maxuploads TINYINT(3) unsigned NOT NULL default '0',

superseeder ENUM('0','1') NOT NULL default '0',

runtime ENUM('True','False') NOT NULL default 'False',

sharekill SMALLINT(4) unsigned NOT NULL default '0',

minport SMALLINT(5) unsigned NOT NULL default '0',

maxport SMALLINT(5) unsigned NOT NULL default '0',

maxcons SMALLINT(4) unsigned NOT NULL default '0',

rerequest MEDIUMINT(8) unsigned NOT NULL default '0',

PRIMARY KEY (id)

) ENGINE=MyISAM;



--

-- tf_torrent_totals

--

CREATE TABLE tf_torrent_totals (

tid VARCHAR(40) NOT NULL default '',

uptotal BIGINT(80) NOT NULL default '0',

downtotal BIGINT(80) NOT NULL default '0',

PRIMARY KEY (tid)

) ENGINE=MyISAM;



--

-- tf_xfer

--

CREATE TABLE tf_xfer (

user_id VARCHAR(32) NOT NULL default '',

date DATE NOT NULL default '0000-00-00',

download BIGINT(80) NOT NULL default '0',

upload BIGINT(80) NOT NULL default '0',

PRIMARY KEY (user_id,date)

) ENGINE=MyISAM;



--

-- tf_settings_user

--

CREATE TABLE tf_settings_user (

uid INT(10) NOT NULL,

tf_key VARCHAR(255) NOT NULL default '',

tf_value TEXT NOT NULL

) ENGINE=MyISAM;



--

-- tf_settings

--

CREATE TABLE tf_settings (

tf_key VARCHAR(255) NOT NULL default '',

tf_value TEXT NOT NULL,

PRIMARY KEY (tf_key)

) ENGINE=MyISAM;



INSERT INTO tf_settings VALUES ('path','/usr/local/torrentflux/');

INSERT INTO tf_settings VALUES ('advanced_start','1');

INSERT INTO tf_settings VALUES ('max_upload_rate','10');

INSERT INTO tf_settings VALUES ('max_download_rate','0');

INSERT INTO tf_settings VALUES ('max_uploads','4');

INSERT INTO tf_settings VALUES ('minport','49160');

INSERT INTO tf_settings VALUES ('maxport','49300');

INSERT INTO tf_settings VALUES ('rerequest_interval','1800');

INSERT INTO tf_settings VALUES ('enable_search','1');

INSERT INTO tf_settings VALUES ('show_server_load','1');

INSERT INTO tf_settings VALUES ('loadavg_path','/proc/loadavg');

INSERT INTO tf_settings VALUES ('days_to_keep','30');

INSERT INTO tf_settings VALUES ('minutes_to_keep','3');

INSERT INTO tf_settings VALUES ('rss_cache_min','20');

INSERT INTO tf_settings VALUES ('page_refresh','60');

INSERT INTO tf_settings VALUES ('default_theme','default');

INSERT INTO tf_settings VALUES ('default_language','lang-english.php');

INSERT INTO tf_settings VALUES ('debug_sql','1');

INSERT INTO tf_settings VALUES ('torrent_dies_when_done','False');

INSERT INTO tf_settings VALUES ('sharekill','0');

INSERT INTO tf_settings VALUES ('pythonCmd','/usr/bin/python');

INSERT INTO tf_settings VALUES ('searchEngine','TorrentSpy');

INSERT INTO tf_settings VALUES ('TorrentSpyGenreFilter','a:1:{i:0;s:0:\"\";}');

INSERT INTO tf_settings VALUES ('TorrentBoxGenreFilter','a:1:{i:0;s:0:\"\";}');

INSERT INTO tf_settings VALUES ('TorrentPortalGenreFilter','a:1:{i:0;s:0:\"\";}');

INSERT INTO tf_settings VALUES ('enable_torrent_download','1');

INSERT INTO tf_settings VALUES ('enable_file_priority','1');

INSERT INTO tf_settings VALUES
('searchEngineLinks','a:5:{s:7:\"isoHunt\";s:11:\"isohunt.com\";s:7:\"NewNova\";s:11:\"newnova.org\";s:10:\"TorrentBox\";s:14:\"torrentbox.com\";s:13:\"TorrentPortal\";s:17:\"torrentportal.com\";s:10:\"TorrentSpy\";s:14:\"torrentspy.com\";}');

INSERT INTO tf_settings VALUES ('maxcons','40');

INSERT INTO tf_settings VALUES ('enable_mrtg','1');

INSERT INTO tf_settings VALUES ('showdirtree','1');

INSERT INTO tf_settings VALUES ('maxdepth','0');

INSERT INTO tf_settings VALUES ('enable_multiops','1');

INSERT INTO tf_settings VALUES ('enable_wget','1');

INSERT INTO tf_settings VALUES ('enable_multiupload','1');

INSERT INTO tf_settings VALUES ('enable_xfer','1');

INSERT INTO tf_settings VALUES ('enable_public_xfer','1');

INSERT INTO tf_settings VALUES ('bin_grep','/bin/grep');

INSERT INTO tf_settings VALUES ('bin_netstat','/bin/netstat');

INSERT INTO tf_settings VALUES ('bin_php','/usr/bin/php');

INSERT INTO tf_settings VALUES ('bin_awk','/usr/bin/awk');

INSERT INTO tf_settings VALUES ('bin_du','/usr/bin/du');

INSERT INTO tf_settings VALUES ('bin_wget','/usr/bin/wget');

INSERT INTO tf_settings VALUES ('bin_unrar','/usr/bin/unrar');

INSERT INTO tf_settings VALUES ('bin_unzip','/usr/bin/unzip');

INSERT INTO tf_settings VALUES ('bin_cksfv','/usr/bin/cksfv');

INSERT INTO tf_settings VALUES ('btclient','tornado');

INSERT INTO tf_settings VALUES ('btclient_tornado_options','');

INSERT INTO tf_settings VALUES ('btclient_transmission_bin','/usr/local/bin/transmissioncli');

INSERT INTO tf_settings VALUES ('btclient_transmission_options','');

INSERT INTO tf_settings VALUES ('metainfoclient','btshowmetainfo.py');

INSERT INTO tf_settings VALUES ('enable_restrictivetview','1');

INSERT INTO tf_settings VALUES ('perlCmd','/usr/bin/perl');

INSERT INTO tf_settings VALUES ('ui_displayfluxlink','1');

INSERT INTO tf_settings VALUES ('ui_dim_main_w','900');

INSERT INTO tf_settings VALUES ('enable_bigboldwarning','1');

INSERT INTO tf_settings VALUES ('enable_goodlookstats','1');

INSERT INTO tf_settings VALUES ('ui_displaylinks','1');

INSERT INTO tf_settings VALUES ('ui_displayusers','1');

INSERT INTO tf_settings VALUES ('xfer_total','0');

INSERT INTO tf_settings VALUES ('xfer_month','0');

INSERT INTO tf_settings VALUES ('xfer_week','0');

INSERT INTO tf_settings VALUES ('xfer_day','0');

INSERT INTO tf_settings VALUES ('enable_bulkops','1');

INSERT INTO tf_settings VALUES ('week_start','Monday');

INSERT INTO tf_settings VALUES ('month_start','1');

INSERT INTO tf_settings VALUES ('hack_multiupload_rows','6');

INSERT INTO tf_settings VALUES ('hack_goodlookstats_settings','63');

INSERT INTO tf_settings VALUES ('enable_dereferrer','1');

INSERT INTO tf_settings VALUES ('auth_type','0');

INSERT INTO tf_settings VALUES ('index_page_connections','1');

INSERT INTO tf_settings VALUES ('index_page_stats','1');

INSERT INTO tf_settings VALUES ('index_page_sortorder','dd');

INSERT INTO tf_settings VALUES ('index_page_settings','1266');

INSERT INTO tf_settings VALUES ('bin_sockstat','/usr/bin/sockstat');

INSERT INTO tf_settings VALUES ('nice_adjust','0');

INSERT INTO tf_settings VALUES ('xfer_realtime','1');

INSERT INTO tf_settings VALUES ('skiphashcheck','0');

INSERT INTO tf_settings VALUES ('enable_umask','0');

INSERT INTO tf_settings VALUES ('enable_sorttable','1');

INSERT INTO tf_settings VALUES ('drivespacebar','tf');

--

INSERT INTO tf_settings VALUES ('bin_vlc','/usr/local/bin/vlc');

INSERT INTO tf_settings VALUES ('debuglevel','0');

INSERT INTO tf_settings VALUES ('docroot','/var/www/');

INSERT INTO tf_settings VALUES ('enable_index_ajax_update_silent','0');

INSERT INTO tf_settings VALUES ('enable_index_ajax_update_users','1');

INSERT INTO tf_settings VALUES ('wget_ftp_pasv','0');

INSERT INTO tf_settings VALUES ('wget_limit_retries','3');

INSERT INTO tf_settings VALUES ('wget_limit_rate','0');

INSERT INTO tf_settings VALUES ('enable_index_ajax_update_title','1');

INSERT INTO tf_settings VALUES ('enable_index_ajax_update_list','1');

INSERT INTO tf_settings VALUES ('enable_index_meta_refresh','0');

INSERT INTO tf_settings VALUES ('enable_index_ajax_update','0');

INSERT INTO tf_settings VALUES ('index_ajax_update','10');

INSERT INTO tf_settings VALUES ('details_type','ajax');

INSERT INTO tf_settings VALUES ('details_update','5');

INSERT INTO tf_settings VALUES ('auth_basic_realm','torrentflux-b4rt');

INSERT INTO tf_settings VALUES ('servermon_update','5');

INSERT INTO tf_settings VALUES ('enable_home_dirs','1');

INSERT INTO tf_settings VALUES ('path_incoming','incoming');

INSERT INTO tf_settings VALUES ('enable_tmpl_cache','0');

INSERT INTO tf_settings VALUES ('btclient_mainline_options','');

INSERT INTO tf_settings VALUES ('bandwidthbar','tf');

INSERT INTO tf_settings VALUES ('display_seeding_time','1');

INSERT INTO tf_settings VALUES ('ui_displaybandwidthbars','1');

INSERT INTO tf_settings VALUES ('bandwidth_down','10240');

INSERT INTO tf_settings VALUES ('bandwidth_up','10240');

INSERT INTO tf_settings VALUES ('webapp_locked','0');

INSERT INTO tf_settings VALUES ('enable_btclient_chooser','1');

INSERT INTO tf_settings VALUES ('enable_transfer_profile','1');

INSERT INTO tf_settings VALUES ('transfer_profile_level','2');

INSERT INTO tf_settings VALUES ('transfer_customize_settings','1');

INSERT INTO tf_settings VALUES ('downloadhosts','0');

INSERT INTO tf_settings VALUES ('pagetitle','torrentflux-b4rt');

INSERT INTO tf_settings VALUES ('fluxd_dbmode','php');

INSERT INTO tf_settings VALUES ('fluxd_loglevel','0');

INSERT INTO tf_settings VALUES ('fluxd_Fluxinet_enabled','0');

INSERT INTO tf_settings VALUES ('fluxd_Qmgr_enabled','0');

INSERT INTO tf_settings VALUES ('fluxd_Rssad_enabled','0');

INSERT INTO tf_settings VALUES ('fluxd_Watch_enabled','0');

INSERT INTO tf_settings VALUES ('fluxd_Trigger_enabled','0');

INSERT INTO tf_settings VALUES ('fluxd_Clientmaint_enabled','0');

INSERT INTO tf_settings VALUES ('fluxd_Fluxinet_port','3150');

INSERT INTO tf_settings VALUES ('fluxd_Qmgr_interval','15');

INSERT INTO tf_settings VALUES ('fluxd_Qmgr_maxTotalTorrents','5');

INSERT INTO tf_settings VALUES ('fluxd_Qmgr_maxUserTorrents','2');

INSERT INTO tf_settings VALUES ('fluxd_Rssad_interval','1800');

INSERT INTO tf_settings VALUES ('fluxd_Rssad_jobs','');

INSERT INTO tf_settings VALUES ('fluxd_Watch_interval','120');

INSERT INTO tf_settings VALUES ('fluxd_Watch_jobs','');

INSERT INTO tf_settings VALUES ('fluxd_Trigger_interval','600');

INSERT INTO tf_settings VALUES ('fluxd_Clientmaint_interval','600');



--

-- tf_settings_dir

--

CREATE TABLE tf_settings_dir (

tf_key VARCHAR(255) NOT NULL default '',

tf_value TEXT NOT NULL,

PRIMARY KEY (tf_key)

) ENGINE=MyISAM;



INSERT INTO tf_settings_dir VALUES ('dir_public_read','1');

INSERT INTO tf_settings_dir VALUES ('dir_public_write','0');

INSERT INTO tf_settings_dir VALUES ('dir_enable_chmod','1');

INSERT INTO tf_settings_dir VALUES ('enable_dirstats','1');

INSERT INTO tf_settings_dir VALUES ('enable_maketorrent','1');

INSERT INTO tf_settings_dir VALUES ('dir_maketorrent_default','tornado');

INSERT INTO tf_settings_dir VALUES ('enable_file_download','1');

INSERT INTO tf_settings_dir VALUES ('enable_view_nfo','1');

INSERT INTO tf_settings_dir VALUES ('package_type','tar');

INSERT INTO tf_settings_dir VALUES ('enable_sfvcheck','1');

INSERT INTO tf_settings_dir VALUES ('enable_rar','1');

INSERT INTO tf_settings_dir VALUES ('enable_move','0');

INSERT INTO tf_settings_dir VALUES ('enable_rename','1');

INSERT INTO tf_settings_dir VALUES ('move_paths','');

INSERT INTO tf_settings_dir VALUES
('dir_restricted','lost+found:CVS:Temporary Items:Network Trash
Folder:TheVolumeSettingsFolder');

INSERT INTO tf_settings_dir VALUES ('enable_vlc','1');

INSERT INTO tf_settings_dir VALUES ('vlc_port','8080');



--

-- tf_settings_stats

--

CREATE TABLE tf_settings_stats (

tf_key VARCHAR(255) NOT NULL default '',

tf_value TEXT NOT NULL,

PRIMARY KEY (tf_key)

) ENGINE=MyISAM;



INSERT INTO tf_settings_stats VALUES ('stats_enable_public','0');

INSERT INTO tf_settings_stats VALUES ('stats_show_usage','1');

INSERT INTO tf_settings_stats VALUES ('stats_deflate_level','9');

INSERT INTO tf_settings_stats VALUES ('stats_txt_delim',';');

INSERT INTO tf_settings_stats VALUES ('stats_default_header','0');

INSERT INTO tf_settings_stats VALUES ('stats_default_type','all');

INSERT INTO tf_settings_stats VALUES ('stats_default_format','xml');

INSERT INTO tf_settings_stats VALUES ('stats_default_attach','0');

INSERT INTO tf_settings_stats VALUES ('stats_default_compress','0');

Vielleicht kann mir hier einer weiter helfen.

Dankeschön.

Hat keiner einen Tip für mich.

 

[sumsi]

AW: Flux auf Server installieren

ich kenne mich leider nicht damit aus, bitte abwarten vllt. melden sich jemanden der dir helfen kann.

 

[Hailogugo]

AW: Flux auf Server installieren

Ich habe jetzt als Lösung torrentflux ng installiert. funktioniert gut.