mysql-mp3 v0.5 -------------- A simple MP3 streaming server for use with a MySQL database. Right now this is a functioning prototype, but that shouldn't put you off trying it out. Requirements ------------ The main requirements are Perl and a MySQL database installation. The code currently assumes MySQL will be used, but this is hidden behind an abstraction layer, so other databases are possible with some small hacking. The Perl installation requires the use of several modules: DBI HTML::Template Install these however you like. For a Debian system use: apt-get update apt-get install libhtml-template-perl apt-get install libdbi-perl Installation ------------ Run 'make install' to install the software into /usr/local/bin. A simple 'make uninstall' will remove the two Perl scripts. Using ----- 1. Create database: cat tables.sql | mysql --user=root -p This creates a database called `mp3` with two tables, one for files and one for directories. Note that if you already have a database with this name it will be dropped. 2. Run mysql-mp3-index.pl, after adjusting items at the start - you'll need to change the following settings: DB_USER = "root" DB_PASS = "" DB_TABLE= "mp3" ROOT = "/home/mp3" Everything else should be left as is. 3. Run mysql-mp3-streamer.pl, after adjusting the lines at the start. You'll need to adjust the four values you adjusted in step 2, plus: PORT = 9999 4. Visit: http://localhost:9999/ 5. Feedback to : steve@steve.org.uk Steve --