From 9f02121a41a4ca24db140179266dd267145b70d5 Mon Sep 17 00:00:00 2001 From: nedko Date: Sat, 5 Mar 2005 22:10:31 +0000 Subject: [PATCH] MySQL realated stuff documented. --- INSTALL | 64 ++++++++++++++++++++++++++++++++++++---------------------------- 1 file changed, 36 insertions(+), 28 deletions(-) diff --git a/INSTALL b/INSTALL index 7560d3d..9ec510c 100644 --- a/INSTALL +++ b/INSTALL @@ -4,12 +4,12 @@ MDB Installation Notes for FC3 (Draft) The following packages are needed in order to compile MediaDatabase on your Linux box. All packages are available in RPMs, so there should not be problem installing them. - 1. GTK >= 2.6 - 2. libglade - - 3. The Configuration File Library (CFL) which could be found here http://www.nongnu.org/cfl/ - 4. GDSL - CFL needs GDSL library to work. GDSL could be found on http://www.nongnu.org/gdsl/ - 5. mysql-devel package - 6. sqlite and sqlite-devel + 1. GTK >= 2.6 + 2. libglade - + 3. The Configuration File Library (CFL) which could be found here http://www.nongnu.org/cfl/ + 4. GDSL - CFL needs GDSL library to work. GDSL could be found on http://www.nongnu.org/gdsl/ + 5. mysql-devel package + 6. sqlite and sqlite-devel MySQL-devel and SQLite packages are available for Fedora Core 3. @@ -19,46 +19,54 @@ MDB Installation Notes for FC3 (Draft) Example: cp sample.conf ~/.mediadatabase - 1.2 Setting up SQLite installation + 1.2 Setting up SQLite database To create the file execute: sqlite /home/user/.media.db To create the database - sqlite /home/lordross/.media.db < ../sql/mediadatabase-empty.sqlite + sqlite /home/lordross/.media.db < sql/mediadatabase-empty.sqlite - 1.3 Setting up MySQL installation - Will not be documented for now + 1.3 Setting up MySQL database + 1.3.1 Prerequisites. MySQL server running and accepting network requests. + 1.3.2 Create empty tables by executing: + mysql -h your_host -u your_username -p < sql/mediadatabase-empty.mysql 2. Configuration 2.1 The config file - To fully run MDB you need to edit the configuration file for your user (see 1.1). The configuration will - be made from the file until the GTK configuration frontend is ready. + To fully run MDB you need to edit the configuration file for your user (see 1.1). The configuration will + be made from the file until the GTK configuration frontend is ready. - First you need to setup the mount, unmount and mount point options. Only one CD/DVD drive is - currently supported. They look like this: + First you need to setup the mount, unmount and mount point options. Only one CD/DVD drive is + currently supported. They look like this: - mount = "/bin/mount /media/cdrecorder" - unmount = "/bin/umount /media/cdrecorder" - mountdir = "/media/cdrecorder" + mount = "/bin/mount /media/cdrecorder" + unmount = "/bin/umount /media/cdrecorder" + mountdir = "/media/cdrecorder" - Then you need to setup the database frontend. Uncomment the database you want to use: + Then you need to setup the database frontend. Uncomment the database you want to use: - # Which backend to use - backend = "SQLite" - #backend = "MySQL" + # Which backend to use + backend = "SQLite" + #backend = "MySQL" - For the SQLite database front end you need to properly setup the following lines. + For the SQLite database backend you need to properly setup the following lines. - [SQLite] - dbfile = "/home/lordross/.media.db" + [SQLite] + dbfile = "/home/lordross/.media.db" - Note the full path for dbfile. Something like ~/.media.db will not work. + Note the full path for dbfile. Something like ~/.media.db will not work. - The dbfile is the file you created in 1.2. + The dbfile is the file you created in 1.2. - For MySQL frontend + For the MySQL database backend you need to properly setup the following lines. - Not documented. + [MySQL] + host = "mysqlserver.domain.org" + user = "mediadatabase" + pass = "password_for_user_mediadatabase" + db = "mediadatabase" + + Config file can also be changed from the GTK frontend. 3. Running -- 2.11.4.GIT