It should also have a Mac, PC and Linux client interface, which would basically implement a CDDB lookup on an inserted CD and enter it into the database.
Goal: | To provide a centralized Media Tracking database for organizing what
CDs, Movies, Video Games, Books, etc. are owned, where they are
(e.g. "Filed", "New", "On Loan", "Wanted") etc. Also, a nice printable interface will help keep from duplicating purchases. |
---|---|
Scope: | 1) Web-based User Interface for data entry & retrieval. 2) CDDB-type platform specific client for automating entry of CDs. 3) Advanced reporting functions? |
Prerequisites: | 1) Apache. 2) PHP (3.05 or greater). 3) PostgreSQL. |
Installation Instructions
The package should be installed into web-space, e.g. (assuming a
standard Red Hat installation):
This will create the directory mediatracker
As user 'postgres', type createuser
webserveruser, replacing webserveruser with
the user name that your web server uses to run - you can determine this
with the command ps aux | grep httpd
psql < /home/httpd/html/mediatracker/documentation/pg-structures.txt
This will create the database and related database elements
required for MediaTracker to work.