muwed - music web database v0.26 -------------------------------- Copyright (C) 2001-2004 by Andreas S. Krebs (muwed@sberk.net) --------------- GNU General Public License Disclamer --------------- This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. -------------------------------------------------------------------- Features: --------- -postgres based MP3 database -perl script to add files to database -PHP web frontend to access and manage the database -web frontend has integrated support to control irmp3 player -MP3 ID3v2 tag support (can display APIC frame) Notes: ------ 1. This version of muwed requires irmp3 v0.5.7pre1 or pre2 with the provided patch installed. Other versions may work, but haven't been tested. 2. The database management functions of muwed don't perform any kind of access control. If you want access control, use apache's access control functions to restrict access to muwed/manage folder. Requirements: ------------- The following components are required and have to be installed in order to use muwed. For information about how to obtain and install the components see the provided links. -PostgreSQL database [http://www.postgresql.org/] -perl [http://www.perl.org/] + DBI - Database independent interface for Perl [http://www.cpan.org/] + MP3::Info module [http://sourceforge.net/projects/mp3-info/] + MP3::Tag module [http://tagged.sourceforge.net] -PHP4 [http://www.php.net/] + Postgres modules -phpHtmlLib [http://phphtmllib.newsblob.com/] -apache web server [http://www.apache.org/] + configured to run php scripts -IRMP3 v0.5.7pre1 [http://irmp3.sourceforge.net/] + with mod_netctl buildin My configuration: ----------------- on my fedora core 2 system I use the following rpms and tarballs: -postgresql-7.4.2-1.i386.rpm -postgresql-server-7.4.2-1.i386.rpm -perl-5.8.3-18.i386.rpm -perl-DBI-1.40-4.i386.rpm -perl-DBD-Pg-1.31-5.i386.rpm -http://prdownloads.sourceforge.net/mp3-info/MP3-Info-1.01.tar.gz -http://prdownloads.sourceforge.net/tagged/tagged-0.40.tar.gz -php-4.3.8-2.1.i386.rpm -php-pgsql-4.3.8-2.1.i386.rpm -http://phphtmllib.newsblob.com/downloads/download.php?version=2.4.1 -httpd-2.0.51-2.7.i386.rpm -http://prdownloads.sourceforge.net/irmp3/irmp3-v0.5.7pre1.tar.gz Quick Installation: ------------------- 1. create the muwed database by running the create_muwed.sh script (change dbname or dbuser if needed) 2. copy the muwed folder into the root directory of your apache web server 3. copy the files from the cgi-bin folder to the /cgi-bin folder of your web server and make sure you can execute perl scripts 4. install phphtmllib so that muwed can access it (modify muwed/phphtmllib.inc - default is document root of your web server) 5. make sure irmp3 v0.5.7pre1 is installed with mod_netctl builtin 6. edit the muwed/config.inc file so that they represent your configuration 7. add a song to your database using the add2muwed.pl script 8. add playlists to your database using the addplaylist.pl script (songs of the playlist have to be added first!) 9. access the database via http:///muwed and enjoy Upgrade from version v0.1x: --------------------------- 1. backup your database running "pg_dump muwed >muwed_backup" as postgres user ("man pg_dump" for more information) 2. run upgrade_0.1x-0.24.sh script 3. follow steps 2-6 from the quick installation above Todo: ----- -documentation -playlist editing support (any ideas how to do reordering in html?) -store queries as dynamic playlists (e.g. all songs of genre rock) -setting id3 tags in mp3 files from database -supporting other databases -supporting other players like icecast -...