-
Hi
Depending on the version of MySQL that you have you can set triggers with mySQL to run events when something happens, ie when the leecher has finished the download you can set the trigger to action when the initial database updates; to update your second database.
MySQl 5 is required.
Ian.
2006-03-28 16:27:44 UTC in Extended BitTorrent Client and Tracker
-
Hi
True it seems my new install of mySQL was set to InnoDB as default, but that is an issue in the SQL you supply that you should not assume anything, it has taken me a long time to learn that lesson with the Apps I do :)
I am building the front end for the tracker now, will take me a while as I am learning BT technology at the same time.
Thanks for the tracker seems a useful tool, but...
2006-03-28 16:25:56 UTC in Extended BitTorrent Client and Tracker
-
Ok changing the MySQL table type from InnoDB to MyISAM made the above errors go away
Olaf, if you are not going to use any of the advanced features of the InnoDB table type then there is no point using it, it is slower than MyISAM. InnoDB however can store more than the 50M record limit that MyISAM has.
Again more docs need to be written on this aspect I think.
2006-03-26 15:12:27 UTC in Extended BitTorrent Client and Tracker
-
Ok
I managed to get some feedback from the CLI by entering "XBT Tracker.exe" and waiting a long time :)
It firstly stated that the most of the fields didnt have default values, for mySQL in strict mode you need to add in the default value for INT fields ie default='0' so re-did the SQL and now I have inserts.
However I am getting :
Table storage engine for 'xbt_announce_log'...
2006-03-26 15:02:52 UTC in Extended BitTorrent Client and Tracker
-
Ok
Having read further is the issue related to running mysql 5? - it really should cause an issue as 4.1 and 5 run the same connections parameters and queries.
Please let me know.
Ian.
2006-03-26 14:44:27 UTC in Extended BitTorrent Client and Tracker
-
Hi
Still confused, I have now entered:
"XBT Tracker" http://localhost:2710/announce in the CMD line, it doesnt hang this time just goes to the next prompt.
I also entered "XBT Tracker" it hangs then in a browser enter: http://localhost:2710/announce
Can you be more specifc please, I think I am very close.
Ian.
2006-03-26 14:13:21 UTC in Extended BitTorrent Client and Tracker
-
Ok as I thought the Client and the Tracker are two different products. So I am none the wiser how to get into the CLI for the Tracker, the usual methods seem to reap zero rewards.
Look forward to your response I will continue to browse the forums for the answers
Ian.
2006-03-26 13:49:50 UTC in Extended BitTorrent Client and Tracker
-
Hi
Yes this was the first thing I did to allow the logs, I assume allowing this logs connections into the DB.
In CMD I enter "XBT Tracker" in the directory, but dont know any of the other commands to access this, entering the above simply makes the CMD hang for a long time. Do I have to download the Command Line Interface client also? I have just seen this in the home page?
A...
2006-03-26 13:42:58 UTC in Extended BitTorrent Client and Tracker
-
Hi,
Running on windows XP with PHP 5, Apache 2.x
I have got the XBT Tracker installed. I test via http://localhost:2710/statistics and can see:
leechers 0
seeders 1
peers 1
torrents 1
announced 2
announced http 0 0 %
announced http compact 2 100 %
announced http no peer id 0 0 %
announced udp 0 0 %
scraped 0
up time 4.4 minutes
anonymous connect 1
anonymous announce 1...
2006-03-26 08:52:48 UTC in Extended BitTorrent Client and Tracker
-
Logged In: YES
user_id=299291
Multi langiage is implemented.
2003-10-07 01:41:02 UTC in PHP Multiple Newsletters
