The Open Media Collectors Database (OpenDb) is a PHP and MySQL based inventory application that allows you to easily catalog and lend out your stuff. Its primary purpose is to catalog media related items, such as DVD’s, Books, CD’s etc, but its so flexible you can use it to catalog pretty much anything.
Opendb ships with many media related (DVD, VCD, CD, VHS, games, books, and laser discs.) item type definitions, or you can download a user contributed item type or create your own. Currently the application is at version 18.104.22.168 and there is active development in the SVN.
To install the Open Media Collectors Database (OpenDb) on your site, you will need the following:
- WebServer (Apache 1.3, 2.x, IIS,…) – Apache is recommended, but IIS should work too.
- PHP 4.3.0+, 5.X
- track_vars must be enabled.
- register_globals can be enabled/disabled. You should really have this disabled for security reasons anyway!
- php-mysql or php-mysqli module must be installed, so that PHP can access MySQL.
- php-gd module for image thumbnail generation.
- MySQL Database 4.X, 5.X
- SMTP server or PHP email configured. If this is not possible, be sure to set the email configuration Mailer to ‘none’. The borrower functionality is severely restricted without email functionality.
The current version for OpenDB is 22.214.171.124 and can be found at http://sourceforge.net/projects/opendb/. Download the file to your server. The downloaded file is in zipned format which will require unzip to open. Our destination for the files is /var/www/html/opendb, for which we will need to create the directory and unzip the file contents.
$ sudo mkdir /var/www/html/opendb
$ sudo unzip OpenDb-126.96.36.199.zip -d /var/www/html/opendb
Change a few directory permissions for the installer to be able to work correctly.
$ cd /var/www/html/opendb
chmod ugo+w ./log ./include ./importcache ./itemcache ./upload ./httpcache
Now that the files are in their final destination we can run the OpenDb installer. Run the OpenDb installer, by opening the install.php in your browser. Use a URL something like http://<your_server>/opendb/install.php
I attached an OpenOffice Doc with more detail OpenDb Installation