MP3db 0.7

MP3db is a database for MP3-files on removable media. MP3dbs data will be saved on a SQL-databaseserver with information about media, album and its covers.
Local languages can easily added (at present only english and german language are available).
Installation:
To install MP3db a SQL-database is needed. At present are supported and tested:
- MySQL: Version 4.0 and higher
- PostgreSQL: Version 8.0 and higher (<= 8 are untested)
Installation MySQL:
Please install the database (and console-utils under linux) on your PC. Now open a databaseconsole (Linux per commandline: mysql -u root -p, under Windows from the starting menu) and execute following commands:
GRANT USAGE ON *.* TO user@% IDENTIFIED BY password; <- creates an user "user" with password "password". Chance this to your own values. "%" allows all hosts to connect to the database (even out of the internet if no firewall installed). If you dont want to allow this you have to chance it to e.g. "localhost" so only connections from the same computer will be accepted.
GRANT SELECT, CREATE, DROP, ALTER, INSERT, UPDATE, DELETE, LOCK TABLES, INDEX ON mp3db.* to user@%; <- assigns to the user "user" connected from any host ("%") the needed rights on the database "mp3db".
CREATE DATABASE mp3db; <- creates the database "mp3db". Now you can leave the databaseconsole with exit an proceed on the bottom of this site.
Installation PostgreSQL (under Windows):
Please install the database and create an user with password in the administrationtool "pgAdmin" (in starting menu).
Now create a database (e.g. mp3db) with this user as owner.
Now start MP3db. The error message shown has to be ignored, because the setting hasnt been made yet. Select "Settings" in the Optionmenu.
First select or enter the path to your CD/DVD-drive for reading MP3s. Then choose your database type out ouf drop-down-box "JDBC-Driver" die entsprechende Datenbank. Depending on database the URL must be entered.
At MySQL-databases: jdbc:mysql://[host]/[database]
At PostgreSQL-databases: jdbc:postgresql://[host]/[database]
Example: A MySQL-database running on the lokal computer with a database "mp3db". You have to enter: "mysql://localhost/mp3db"
You have to enter your username and password to their fields and click on "Create database". The database structure will be created. If errors will be shown like "table not found" ignore them. They relate to removing old structur before creating (will be removed in later versions).
MP3db is now ready for use.
Enhancements:
- Created setup and logo, bug fixing and optimization, internal changes